View previous topic :: View next topic
|
Author |
Message |
prasun dhara
New User
Joined: 01 Mar 2008 Posts: 49 Location: kolkata
|
|
|
|
Hi ,
I need the list of plan names where a particular packages was bound.
Example : if Package A is bound to 5 plans M,N,O,P,Q
I should be able to find them using sql query on SYSTEM catalog (SYSPACKAGE,SYSPLAN etc)
Could you please provide me the query?
Thanks
Prasun |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you ask your dba - such a query may already exist. . . |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
start from this :
Code: |
from sysibm.syspackage pa
join sysibm.syspacklist pk on pk."COLLID"=pa."COLLID" and pk.NAME in (pa.name,'*')
join sysibm.sysplan pl on pl.NAME = pk.PLANNAME |
location does matter , but not often. |
|
Back to top |
|
|
|