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?
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.
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)?