To use dynamic EXPLAIN with the Application Performance Analyzer UDB component, Application Performance Analyzer started tasks must have access to a PLAN_TABLE. Bypass this section if you do not use the EXPLAIN feature.
The CREATE statement in job CAZPLANT is in the 49-column format compatible with DB2 Version 6. The 51-column format (for DB2 Version 7) and the 58-column format for (DB2 Version 8) can be used instead. For DB2 Version 10, the PLAN_TABLE must be created using job CAZPLANX. Whichever PLAN_TABLE is used, the EXPLAIN feature will only make use of the first 49 columns when reporting the results of an EXPLAIN.
You can specify the database and tablespace name in which the PLAN_TABLE will be created by adding the appropriate lines to the CREATE statement.
The CREATE statement applies if the escape character the DB2® subsystem is the quote character ("). However, if the DB2 subsystem has been installed with the quote character as the SQL string delimiter, then the escape character is the apostrophe ('). In this case, the quotes in the CREATE statement must be changed to apostrophes.
[ Top of Page | Previous Page | Next Page | Contents | Index ]