Setting default parameters
Query
Analyzer uses a collection of default parameter settings. These
default settings are saved from session to session in your ISPF
profile data set (under an application ID of RAAX). You can set
these default parameters by selecting option D from the Query Analyzer Selection Menu.
Table 93. Set Default Parameters
DB2P -- Set Default Parameters --------------------------------------- 8.1.0
Command ===>
1. REXX Program Name............. ===>
2. Plan Table Owner/Current SQLID ===>
Create Plan Table In
3a. Database...................... ===>
3b. Table Space................... ===>
|
If you press Enter, all input fields will
be validated. If any errors are detected during input validation,
the panel will be redisplayed with an error message. If there are
no errors, then these default values will be saved.
If you press PF3, all input fields will
be ignored and you will return to the Query Analyzer Selection Menu.
The previous default values will be restored.
The fields on the panel are:
- REXX Program Name
- (This field is optional.) Specify the name of your exit routine,
if you have written one. If you leave this field blank, the sample
exit routine, RAARXQA, will be used.
- Plan Table Owner/Current SQLID
- (This field is optional.) If a value is entered here, it will
be used as the CURRENT SQLID during query analysis. This ID will
become the owner of the PLAN_TABLE used for the EXPLAIN command.
It also will become the owner of all unqualified tables in FROM
clauses. Before setting this value, review the restrictions for
setting CURRENT SQLID in the DB2 Administration Guide.
- Create Plan Table In Database
- (This field is optional.) Specify the database in which Query
Analyzer should create a PLAN_TABLE for a user if one does not exist.
If you leave this field blank and a PLAN_TABLE does not exist, query
analysis will be bypassed.
- Create Plan Table In Table Space
- (This field is optional.) Specify the table space in which
Query Analyzer should create a PLAN_TABLE for a user if one does
not exist. You cannot enter a value in this field unless you enter
a value in the Create Plan Table In Database field.
