Page 1 of 1

List of Tables from Plan

PostPosted: Thu Jan 05, 2012 3:06 pm
by raghav08
Hello,

Please assist me to find the list of tables those are attached to a given DB2 Plan.

In my system there is DB2 plan called SRVXFINM, and this is associated with 13 packages, now I need to get the list of tables that used in the Plan SRVXFINM.

Thanks.

Re: List of Tables from Plan

PostPosted: Thu Jan 05, 2012 7:29 pm
by GuyC
SYSIBM.SYSPACKDEP holds all dependencies of a package.