List of Tables from Plan

IBM's flagship relational database management system

List of Tables from Plan

Postby raghav08 » Thu Jan 05, 2012 3:06 pm


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.

Posts: 18
Joined: Wed Oct 27, 2010 5:10 pm
Has thanked: 0 time
Been thanked: 0 time

Re: List of Tables from Plan

Postby GuyC » Thu Jan 05, 2012 7:29 pm

SYSIBM.SYSPACKDEP holds all dependencies of a package.
I can explain it to you, but i can not understand it for you.
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Return to DB2


  • Related topics
    Last post