anamikak
New User
Joined: 10 May 2006
Posts: 64
Location: Singapore
|
|
|
|
step1/
try this sql query in QMF or in DB2I
SELECT PLANNAME,COLLID,
FROM SYSIBM.SYSPACKLIST
WHERE PLANNAME ='YOUR PLAN NAME'
you will be able to see a list of collection ids to which your packages are bound.
after this you could follow either of the steps below.
step2A/
If you have BMC Db2 installed. you could selct the option of querying Db2 objects. In the object select the collection option and give the list of collections one after the other. This would give you the list of packages, having got the list of packages, query db2 for object as package, you woul get DBRMs So, the DBRMS are your db2 program names.
Step2B/
Try this sql query in QMF or in DB2I
ELECT A.NAME,B.NAME
FROM SYSIBM.SYSPACKAGE A,
SYSIBM.DBRM B
WHERE A.NAME IN ( list of collections ids )
and A.CONTOKEN = B.TIMESTAMP
here a.name refers to package name bound to the collection list AND B.name refers to Dbrms wich are your Db2 program.
OR, in a nutshell, the two queris can be combined as
SELECT A.NAME,B.NAME
FROM SYSIBM.SYSPACKAGE A,
SYSIBM.DBRM B
WHERE A.NAME IN ( SELECT COLLID
FROM SYSIBM.SYSPACKLIST C
WHERE C PLANNAME ='YOUR PLAN NAME' )
and A.CONTOKEN = B.TIMESTAMP
----------------------------------------------------------------------------------
now another consideration is when DBRMs are directly bound to your plan, ie there is no package bind. In such cases if you know your plan name, you can directly query SYSIBM.DBRM as
SELECT NAME FROM SYSIBM.DBRM
WHERE PLNAME = 'plan name'
The name that you get from this query refer to your db2 program.
Hope these methods help you.
Anamika
[/i] |
|
