Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how to find which package is related to which plan

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: how to find which package is related to which plan
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    Post subject: Re: how to find which package is related to which plan
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us