Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Get the plan name in a runing programm.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
farfadet

New User


Joined: 20 Feb 2006
Posts: 2

PostPosted: Mon Feb 20, 2006 4:28 pm    Post subject: Get the plan name in a runing programm.
Reply with quote

Hi,

How to get the executing plan name in a cobol programm ?

I want to known with plan is executing in a cobol programm.


Thanks.
Back to top
View user's profile Send private message

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Mon Feb 20, 2006 4:45 pm    Post subject:
Reply with quote

For batch: Take a look at the SYSTSIN card (the one that starts with "DSN RUN..."). You have the plan name there.

For CICS: Locate the starting transaction, then try 'CEMT I DB2T(transaction)'.

O.
Back to top
View user's profile Send private message
farfadet

New User


Joined: 20 Feb 2006
Posts: 2

PostPosted: Mon Feb 20, 2006 5:49 pm    Post subject:
Reply with quote

I known that the plan name is in the SYSTSIN card, but I want to get the plan name in the cobol programm.

I think that is possible to get the plan name with a SQL order. But I don't known the good SQL order.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Program and its corresponding plan vickey_dw DB2 4 Thu Apr 07, 2016 9:27 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts DB2 plan for DSNTEP2 / DSNTEP4 Mainak_Dalal DB2 3 Thu Jan 21, 2016 1:08 am
No new posts Multiple COBOL-DB2 pragrams calling b... deepak_shrivastava DB2 1 Wed Jan 06, 2016 3:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us