Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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
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    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

kalukakkad

New User


Joined: 10 Mar 2005
Posts: 81

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

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting error on PROCOPT=P option Raghu navaikulam IMS DB/DC 5 Wed Mar 23, 2016 5:55 pm
No new posts Will ""PROCOPT = A"&qu... VarunJ1991 IMS DB/DC 2 Mon Mar 11, 2013 9:56 pm
No new posts Procopt Query narasimha.g IMS DB/DC 3 Fri Aug 26, 2011 6:13 pm
No new posts can someone give a brief of what does... shradha dorugade IMS DB/DC 5 Thu Jul 28, 2011 11:28 am
No new posts PROCOPT in PSB enileshk IMS DB/DC 4 Sat Aug 21, 2010 9:24 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us