Db2 optimization routines panel: DSNTIPRM

The DSNTIPRM panel allows you to modify configuration options for routines that are to be used for optimization.

Scrolling the panel

Because space on this panel is limited, all fields might not be displayed at one time, and it is defined as a scrollable panel in ISPF. The number of fields that are displayed depends on how many rows your ISPF device can display, whether you use split screen mode, and where you split the screen. You can scroll the panel to see more fields if More displays in the upper right side of the panel followed by + or -. The + indicates that you can scroll down, and - indicates that you can scroll up.

To scroll through the fields, use the DOWN and UP scroll commands . (You can also assign your PF keys to the DOWN and UP commands.)

Figure 1. Db2 query optimization routines panel: DSNTIPRM

 +---------- DB2 ROUTINES: ADVANCED CONFIGURATION OPTIONS -----------+
 | DSNTIPRM            DB2 optimization routines                     |
 | ===>                                                              |
 | DSNAHVPM                                                          |
 |   WLM ENV NAME  ===> DSNWLM_GENERAL                               |
 |   GRANT EXECUTE ===> user-id                                      |
 |   PACKAGE OWNER ===> user-id                                      |
 |                                                                   |
 |PRESS: ENTER to continue UP/DOWN to scroll RETURN to exit          |
 +------------------------------------------------------------—-––---+

WLM ENV NAME

Specify the WLM environment name for the routine.

Acceptable values:	a valid WLM environment name
Default:	DSNWLM_GENERAL
DSNZP`xxx`:	none

GRANT EXECUTE

Specify one or more authorization IDs that are to be granted EXECUTE access on the routine. Use commas to separate individual IDs. Do not use embedded blanks. You can enter up to 44 characters, including commas.

The default setting user-id is the TSO user ID that is used to run the installation CLIST.

Acceptable values:	at least one valid authorization ID
Default:	`user-id`
DSNZP`xxx`:	none

PACKAGE OWNER

Specify the authorization ID of the package owner for the routine. The BIND PACKAGE command for the routine uses this value for the OWNER option. The default is the TSO user ID that is used to run the Db2 installation CLIST.

Acceptable values:	blank, or a valid authorization ID
Default:	`user-id`
DSNZP`xxx`:	none