View previous topic :: View next topic
|
Author |
Message |
psubra001
New User
Joined: 01 Feb 2006 Posts: 15
|
|
|
|
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 |
|
|
kalukakkad
New User
Joined: 10 Mar 2005 Posts: 81
|
|
|
|
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 |
|
|
psubra001
New User
Joined: 01 Feb 2006 Posts: 15
|
|
|
|
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 |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
|
|
Experience is a wonderfull thing....... did you try and learn? |
|
Back to top |
|
|
|