A DB2 "plan" is stored in the DB2 Directory and information about the plan is stored in the DB2 Catalog.
The DB2 Directory table that contains actual plans is SYSIBM.SCT02 (and
SYSIBM.SPT01 contains actual packages). The plan is stored as cursor tables; packages as package tables. As DB2 runs programs it loads the cursor tables for plans and package tables for packages from the DB2 Directory tables into the EDM Pool.
The DB2 Catalog contains information about plans in the following tables:
SYSIBM.SYSDBRM
SYSIBM.SYSPLAN
SYSIBM.SYSPLANAUTH
SYSIBM.SYSPLANDEP
SYSIBM.SYSSTMT
And, the DB2 Catalog contains information about packages in the following tables:
SYSIBM.SYSPACKAGE
SYSIBM.SYSPACKAUTH
SYSIBM.SYSPACKDEP
SYSIBM.SYSPACKLIST
SYSIBM.SYSPACKSTMT
SYSIBM.SYSPKSYSTEM
SYSIBM.SYSPLSYSTEM
Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our discussion forums.
|
