< Day Day Up > |
A plan is an executable module containing the access path logic produced by the DB2 optimizer. It can be composed of one or more DBRMs and packages. Plans are created by the BIND command. When a plan is bound, DB2 reads the following DB2 Catalog tables:
NOTE The SYSIBM.SYSUSERAUTH table (the last one in the list) is read-only for BIND ADD . Information about the plan is then stored in the following DB2 Catalog tables:
Note that the DB2 Catalog stores only information about the plans. The executable form of the plan, called a skeleton cursor table , or SKCT, is stored in the DB2 Directory in the SYSIBM.SCT02 table. To learn more about the way that DB2 handles SKCTs at execution time, see Chapter 22, "The Table-Based Infrastructure of DB2." |
< Day Day Up > |