Options - Explain Plan

IDMS Options

These specify the name of the ACCESS_PLAN and ACCESS_CODE tables. These must exist before the Explain feature for IDMS will work.

Clicking on Create will create these tables with the names specified.

DB2 for z/OS

This specifies the schema for the PLAN_TABLE.

By default, DB2 will write the Explain result to the PLAN_TABLE in your own schema (eg. schema name = your signed-on userid). In this case, you do not need to specify this option.

This option only needs to be used if the Explain result is written to another schema. This can happen if you have customized the explain command to use DSN8EXP (or another stored procedure).

For Plan Table Schema, specify:

• a Schema name
• <currentschema>. This uses the id in the CLI setting CURRENTSCHEMA
• <schemalist1>. This uses the first id in your CLI setting SCHEMALIST