User defaults data set

Each Explain user can specify their own set of run time default values.

For example, the system default value for ACCTYPE on the plan and package statement is All, but you might want the default value to be Nonmatch. Changing the default value is possible if you specify your preferences in a defaults data set. Specified values are saved in the ANLPARM user parameter file.

The system default values are specified in Plan Table report input specifications. The specification rules given in that chapter also apply for the user default values specifications.

The following table shows the parameters that you can set to user-defined values.

Table 1. User-defined parameters
Parameter	Description	Example	System default
ACCTYPE	Show this access type only	Matching	All
INDEX	Index information	Tabscan	Yes
HOSTVAR	Show host variables	Yes	No
FORMAT	Formatting of the SQL statement	Yes	Yes
LEVEL	Level of report information	KEYdist	Detail
PLANINF	Level of plan information	Mini	Yes

The default values are specified in a data set for batch jobs, as shown below:

//...
//REPORT   DD  SYSOUT=*
//ANLPARM  DD  DSN=hlq.SANLPARM(ssidPARM),DISP=SHR
//DSNTRACE DD  SYSOUT=*
//...

Alternatively, the user default values may be specified inline in the job JCL as shown in the following example:

//...
//REPORT   DD  SYSOUT=*
//ANLPARM  DD  *
ACCTYPE TABSCAN
LEVEL   ALLINDEX
//DSNTRACE DD  SYSOUT=*
//...