|
View previous topic :: View next topic
|
| Author |
Message |
Kiran Chava
New User
.jpg)
Joined: 07 Jul 2010
Posts: 9
Location: India
|
|
|
|
Hi,
Could anyone please tell me how to find the plan name during the runtime.
I am running a DB2 proc using a work load manager. I need to know which plan/database is being used. |
|
| Back to top |
|
 |
Pons
New User
Joined: 25 May 2007
Posts: 61
Location: Coimbatore
|
|
|
|
| Guess, this is realted to DB2 question. But this is an COBOL forum... |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Just curious - why does someone believe this is needed at runtime? |
|
| Back to top |
|
|
Kiran Chava
New User
Joined: 07 Jul 2010
Posts: 9
Location: India
|
|
|
|
We have to write the database name to a file which we will be sending to a datawarehousing application. We cant use a parm to get this info as this is being run thru a WLM.
I am running a DB2 proc using a work load manager. I need to know which plan/database is being used.
It would be fine even if I get the WLM name. I can derive the database name from that. |
|
| Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada
|
|
|
|
| Have you investigated the DB2 special registers? CURRENT SCHEMA, CURRENT PACKAGESET etc. Check the SQL reference manual, one of them might be what you are looking for. |
|
| Back to top |
|
|
Kiran Chava
New User
Joined: 07 Jul 2010
Posts: 9
Location: India
|
|
|
|
| Thanks don.leahy the PACKAGESET has worked for me. I got the collid and based on that I derived the Database name. |
|
| Back to top |
|
|
|
|
