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

how to find which package is related to which plan
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
jonna

New User


Joined: 18 Apr 2005
Posts: 9
PostPosted: Mon Jul 11, 2005 4:29 pm
 Reply with quote
Hai,
how to find which package related to which plan,suppose i am having 10000 of packages...and 100 of plans...how did i know which packages related to which plans...plz give reply as soon as possible...
thanks®ards,
uma.
Back to top
View user's profile Send private message
withnams

New User


Joined: 06 Jul 2005
Posts: 26
Location: Chennai
PostPosted: Mon Jul 11, 2005 4:52 pm
 Reply with quote
The way i know is get COLLID from SYSIBM.SYSPACKAGES and get the plan name in SYSIBM.SYSPACKLIST for that COLLID...
Back to top
View user's profile Send private message
nayak

New User


Joined: 13 Jul 2005
Posts: 37
PostPosted: Wed Jul 13, 2005 11:18 pm
 Reply with quote
try this

SELECT BNAME,BCREATOR,BTYPE,DNAME FROM SYSIBM.SYSPLANDEP WHERE BTYPE='I' AND BNAME=index object nam


WHEN AN INDEX IS DROPPED JUST TO FIND OUT WHAT ARE THE PLANS GET AFFECTED
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 Find the size of a PS file before rea... COBOL Programming 13
No new posts Find the occurrence of Key Field (Par... DFSORT/ICETOOL 6
No new posts Find a record count/numeric is multip... COBOL Programming 1
No new posts Need to find a specific STRING COBOL Programming 11
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us