View previous topic :: View next topic
|
Author |
Message |
Ragav86
New User
Joined: 27 Jan 2010 Posts: 37 Location: chennai
|
|
|
|
hi can any one tell me how to see the PKLIST parameters for the particular plan (how the packages bounded in to the plan)? |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi Ragav,
You can start with this query
Code: |
SELECT DISTINCT A.NAME , A.CREATOR , B.LOCATION ,
B.COLLID , B.TIMESTAMP
FROM SYSIBM.SYSPLAN A , SYSIBM.SYSPACKLIST B
WHERE A.NAME = B.PLANNAME AND A.NAME = 'WARPAMS '
AND A.CREATOR = 'PROD'
ORDER BY A.NAME |
For more information, DB2 V9 SQL REFERENCE - Appendix Additional information for DB2 SQL - DB2 Catalog Tables.
Thanks,
Sushanth |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Ragav,
Can i know why ?
This information is required.
Sushanth |
|
Back to top |
|
|
Ragav86
New User
Joined: 27 Jan 2010 Posts: 37 Location: chennai
|
|
|
|
hi sushanth,
thank for your replay
just i want to know how the packages bounded with plan.... |
|
Back to top |
|
|
|