IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Get the plan name in a runing programm.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 2358
Location: Israel

PostPosted: Mon Feb 20, 2006 4:45 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts current batch plan DB2 3
No new posts Log an Plan name/id or Job Id using D... DB2 1
No new posts Usage/Utiliy of Plan in DB2 DB2 4
No new posts How do I define a DB2 plan for a web ... CICS 5
No new posts Finding the plan when code compiled u... DB2 2
Search our Forums:

Back to Top