Application Performance Analyzer for z/OS, Version 11.1, Customization Guide

Enabling DB2 EXPLAIN - Creating a PLAN_TABLE

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.

  1. For DB2 Version 9 and earlier, edit and submit job CAZPLANT in hlq.SCAZSAMP to create a PLAN_TABLE. For DB2 Version 10, edit and submit job CAZPLANX in hlq.SCAZSAMP to create a PLAN_TABLE.
  2. The qualifier for this PLAN_TABLE defaults to the authorization ID of the started task. You can override this default by changing the DB2Qualifier setting in the configuration file. See DB2Qualifier underCONFIG SAMPLE statement.

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.




Rate this page

[ Top of Page | Previous Page | Next Page | Contents | Index ]