|
View previous topic :: View next topic
|
| Author |
Message |
arunvp2
New User
Joined: 14 Nov 2008
Posts: 6
Location: Bangalore
|
|
|
|
| If DB2 table gets altered ,how to identify the impacted programs through packages or plans? |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| Quote: |
| 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. |
|
| Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008
Posts: 283
Location: chennai
|
|
|
|
| .systabauth will give you all the plans and packages that are using a particular table. That should be a good starting point. |
|
| Back to top |
|
|
|
|
