Plan Table report input specifications

You can use Plan Table input commands to set the parameters that SQL PA uses for analysis.

Explain process
The Explain process performs several checks and activities when it runs.
Configuring table access
The plan table report makes extensive use of Db2® system catalog tables.
Plan table access
The plan table report uses a PLAN_TABLE either prefixed with the authorization ID of the job submitter or belonging to the binder of the package being explained.
Input command requirements
The rules you must follow when using the input commands are explained.
Input commands
The input commands are read from a data set with the ddname INPUT. The following information describes detailed command specifications.
Input command definitions
The following information defines the input command statements and their valid values.
Subparameter definitions
The following information defines the subparameters and their valid values.
Specifying language and explaining data from another user
You can use the PARMS field to specify whether you want messages displayed in English or not. You can also use the PARMS field to extract EXPLAIN information from a PLAN_TABLE that belongs to another user.
Selected authorization identification
You can specify authorization ID that Explain uses to select the correct PLAN_TABLE.
User authorization table
The following information describes the columns in the user authorization table.
User defaults data set
Each Explain user can specify their own set of run time default values.
Transferring complex queries to SQL PA
Explain is able to output complex SQL queries to a data set that is used as input to SQL PA.