Identify the tables used in the particular program

sivatechdrive · Posted: Thu Oct 18, 2007 11:54 am

Hi friends

I have a query in DB2

I was given the dbrmname, package name & plan name

without looking at the program
Is there any way to identify the tables used in the particular program
( i.e using sysibm tables)

Thanks n Regards
Prasad

hemanth.nandas · Active User Joined: 18 Aug 2007 Posts: 120 Location: India

Hi Prasad,

nuthan · Posted: Thu Oct 18, 2007 12:17 pm

Prasad,
let us know any particlaur reason for not looking in to the program.

Srihari Gonugunta · Posted: Thu Oct 18, 2007 1:22 pm

The following queries will return the list of objects used by a plan and package respectively. Check the link given below for more information.

select * from sysibm.syspackdep where dname='package';
select * from sysibm.sysplandep where dname='plan';

publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/zpldep.htm

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

Hi Srihari,

have u tried the query.

I have tried but its not working.

Cmd Column Name Selection Criteria
--- ------------------ -----------------------------------------------------
*** ********************************* TOP ***********************************
___ BNAME
___ BQUALIFIER ='DB2TUNT'
___ BTYPE ='T'
___ DLOCATION
___ DCOLLID
___ DNAME ='PGMNAME'
___ DCONTOKEN
___ IBMREQD
___ DOWNER
___ DTYPE
*** ******************************* BOTTOM

If plan is specified for DNAME,then i did not get any results.

i know that DNAME="pgmname' will give the tables used.i have tested this also n getting the results.

Srihari Gonugunta · Posted: Thu Oct 18, 2007 5:48 pm

Sri,
I tried both the queries before posting.

And for SYSIBM.SYSPLANDEP, As per the description for SYSIBM.SYSPLANDEP, the DNAME should be plan name.

Might be, in your case, Program name and plan name are same. Please check the link I have given.

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

Hi srihari,

here Pgm name and plan name are different.i have tried syspackdep(that i have shown in my prev mail).

omnamashiva · New User Joined: 24 Sep 2007 Posts: 10 Location: chennai

Hi friends,
Answer quite simple friend, you know the DBRMlib name , go to DBRM lib mostly it be PDS , (something like unit.DBRMLIB etc) , Open the particular DBRM member(ie mostly it will be your PGM name), you will be able to what all the tables used in that program , with CONTOKEN token(when pgm binded) etc..
Let me know if you need further information

Regards,
Arunchalla