DB2 graphic QMF Version 8

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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004