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

Find the list of plans where a particular package is present


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
prasun dhara

New User


Joined: 01 Mar 2008
Posts: 49
Location: kolkata

PostPosted: Wed Aug 10, 2011 12:43 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Aug 10, 2011 12:50 pm
Reply with quote

Hello,

Suggest you ask your dba - such a query may already exist. . .
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Wed Aug 10, 2011 1:03 pm
Reply with quote

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
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 To find whether record count are true... DFSORT/ICETOOL 6
No new posts How to create a list of SAR jobs with... CA Products 3
No new posts Find the size of a PS file before rea... COBOL Programming 13
No new posts Build dataset list with properties us... PL/I & Assembler 4
No new posts list pds members name starting with xyz CLIST & REXX 11
Search our Forums:

Back to Top