Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
How to find all Tables Names used from Plan?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
Souvik.Sinha

New User


Joined: 22 Apr 2005
Posts: 15
Location: New York, USA
PostPosted: Tue Apr 26, 2005 12:23 pm    Post subject: How to find all Tables Names used from Plan?
 Reply with quote
I was just wondering how to find out all the tables used in a Plan. To speak in an explanatory way - we have some programs, which use many DB2 tables. We bind them using different plans. Now this is what I am looking for - I would like to specify only one plan name and want to get all the tables, which are being used by all the programs, bound in that plan.

I hope that I have been able to explain it. Can anyone help me out?
Back to top
View user's profile Send private message
References
somasundaran_k

Active User


Joined: 03 Jun 2003
Posts: 141
PostPosted: Tue Apr 26, 2005 6:00 pm    Post subject:
Reply with quote
Try this


Code:

Select BNAME
from SYSIBM.SYSPLANDEP 
    where DNAME = 'your plan name'
    and BTYPE = 'T'
    ;



hth
-Som
Back to top
View user's profile Send private message
Souvik.Sinha

New User


Joined: 22 Apr 2005
Posts: 15
Location: New York, USA
PostPosted: Tue Apr 26, 2005 6:05 pm    Post subject:
Reply with quote
Thank you Soma. Thank you so much! The query gave my just the thing, which I was looking for.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1