Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Use of PROCOPT=AP. Will this allow me to..

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
Author Message
psubra001

New User


Joined: 01 Feb 2006
Posts: 15

PostPosted: Tue Apr 22, 2008 2:49 pm    Post subject: Use of PROCOPT=AP. Will this allow me to..
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
References
kalukakkad

Active User


Joined: 10 Mar 2005
Posts: 73

PostPosted: Tue Apr 22, 2008 3:26 pm    Post subject: Reply to: Use of PROCOPT=AP. Will this allow me to..
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    Post subject:
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

IMS Moderator


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

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

Experience is a wonderfull thing....... did you try and learn?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1