IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Use of PROCOPT=AP. Will this allow me to..


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
psubra001

New User


Joined: 01 Feb 2006
Posts: 15

PostPosted: Tue Apr 22, 2008 2:49 pm
Reply with quote

I've a common PSB for two programs. The PSB defines access to two DBs with PROCOPT=AP. Program 1 uses this PSB to do updates to Database 1 only. Program 2 uses this PSB to do updates to Database 2 only.

Will these programs run concurrently ?
ie. Can the 2nd program run parralel to first program, even if the database required by 2nd program was defined as PROCOPT=AP in the PSB? Or will this be kept on wait/lock until the first job completes?
Back to top
View user's profile Send private message
kalukakkad

New User


Joined: 10 Mar 2005
Posts: 81

PostPosted: Tue Apr 22, 2008 3:26 pm
Reply with quote

When an IMS program initiates, it locks the PSB it is using.
Hence, if your 2nd program is run concurrently it will fail because the PSB is already scheduled.

To run programs using the same PSB concurrently, the PSB needs to be defined with SCHDTYP=PARALLEL.

You may contact your IMS DBA to make the changes or confirm if the PSB already has SCHDTYP=PARALLEL.
Back to top
View user's profile Send private message
psubra001

New User


Joined: 01 Feb 2006
Posts: 15

PostPosted: Tue Apr 22, 2008 3:45 pm
Reply with quote

Yes. The SCHDTYP=PARALLEL.
So will this allow 2nd program to run successfully without a wait?
Or will this go on wait/abend since the DB required by this program is already held by PROCOPT=AP by the first program(even though this program doesn't use it)?
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Sun Apr 27, 2008 12:22 am
Reply with quote

Experience is a wonderfull thing....... did you try and learn?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Procopt G -concurrent Read IMS DB/DC 1
No new posts Getting error on PROCOPT=P option IMS DB/DC 5
No new posts Will ""PROCOPT = A"&qu... IMS DB/DC 2
No new posts Procopt Query IMS DB/DC 3
No new posts can someone give a brief of what does... IMS DB/DC 5
Search our Forums:

Back to Top