How to find the Program/Plan related to Table.

amit.mainframe · New User Joined: 13 Mar 2005 Posts: 4 Location: pune

I added a new column in the Table, now I have to find which program need the change. How to find the member related to this Table?

bonniem · New User Joined: 09 Aug 2005 Posts: 67

Use 3.14 search.

Prajesh_v_p · Active User Joined: 24 May 2006 Posts: 133 Location: India

Hi ,

You can search the PLAN_TABLE for this purpose.
you can query this to get the plan program and table used by the program.

Hope this helps.

renjith · New User Joined: 07 Aug 2006 Posts: 11

Prajesh I am not agreeing with ur comment caz PLAN TABLE is used for tuning purpose and will not show the packages.

u can use

SELECT DNAME FROM SYSIBM.SYSPACKDEP WHERE BQUALIFIER='TABLE QUALIFIER' AND BNAM
E='UR TABLE NAME' AND BTYPE='T'

thanks
renjith