Where exactly is a DB2 plan stored?
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:
And, the DB2 Catalog contains information about packages in the following tables:
Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our
This was first published in June 2004