Joined: 20 Oct 2006 Posts: 6962 Location: porcelain throne
how to identify the impacted programs through packages or plans?
by looking at the sysibm.sysplans (spelling) and .syspackages tables.
but, you have to know the package/plan names.
there are other threads in the forum (last month or so) that discussed this very topic and there were some very good suggestions made as how to determine which modules are impacted by an alter of a DB2 table.