plan names affected

aklima · New User Joined: 25 Nov 2005 Posts: 23

1.how can we get the the plan names affected when a index is being droped?

2.how to get the list of affected programs due to atable change?

sathish_rathinam · Active User Joined: 22 Aug 2005 Posts: 57 Location: india

HI AKLIMA,

WE CAN GET THE AFFECTED PLANNAMES FROM SYSIBM.SYSPLANDEP table...

regards,
sathish

khamarutheen · Posted: Thu Dec 08, 2005 10:14 am Post subject: Plan

Hi frnd,

Yes adding to sathish_rathinam SYSIBM.SYSPLANDEP Records the dependencies of plans on tables, views, aliases, synonyms, table
spaces, indexes, functions, and stored procedures. so as per ur requirement view this table,,, but one thing is that u must have that rights to view it so.. check it in ur shop and do else it will say table not found or any other message