|
|
| Author |
Message |
Souvik.Sinha
New User
Joined: 22 Apr 2005
Posts: 15
Location: New York, USA
|
|
|
|
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 |
|
 |
References
|
 Posted: Tue Apr 26, 2005 12:23 pm Post subject: Re: How to find all Tables Names used from Plan? |
|
|
|
|
somasundaran_k
Active User
Joined: 03 Jun 2003
Posts: 141
|
|
|
|
Try this
| Code: |
Select BNAME
from SYSIBM.SYSPLANDEP
where DNAME = 'your plan name'
and BTYPE = 'T'
;
|
hth
-Som |
|
| Back to top |
|
|
Souvik.Sinha
New User
Joined: 22 Apr 2005
Posts: 15
Location: New York, USA
|
|
|
|
| Thank you Soma. Thank you so much! The query gave my just the thing, which I was looking for. |
|
| Back to top |
|
|
|
|
