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

• Query number. This specifies the query number used for the explain.

  If multiple people are sharing the same plan_table, it is recommended that they all use a different query number. If this is not done, the users will be able to see (and delete!) other people's explain results.

• Plan table schema for DB2 z/OS. This specifies the schema name of the PLAN_TABLE containing the explain results.

  If you leave this blank, AQT will use your own userid.

  This option only determines which schema will be used when displaying the explain results. For the explain results to go into schema different than your own userid, you will need to run the command set current sqlid='xxxx' prior to running the explain. AQT will not do this for you.

• Run Explain under Plan table Schema. When this option is selected, AQT will change the session SQLID to the value of Plan table schema for DB2 z/OS before running the explain. This will ensure that the explain information is written to the explain tables in the Plan table schema.

  After the explain has been done, the SQLID is set back to the user's userid.

• Use Visual Explain for DB2 z/OS. This specifies whether the DB2 z/OS explain results will be displayed using Visual Explain.

  Configuration of this feature has not been completed, so use with caution for DB2 z/OS.