Previous Topic: Controlling Dynamic Plan SelectionNext Topic: Sample JCL for Dynamic Plan Selection Table Assembly


DCPLAN Macro Parameters

Here are the DCPLAN macro parameters. For example JCL that shows the parameters in use, see Sample JCL for Dynamic Plan Selection Table Assembly.

AUTHID=(xxxxxxxx,yyyyyyyy,R,xxxxxxxx,yyyyyyyy,R...)

Use this parameter to specify the AUTHID substitution value.

xxxxxxxx represents the old, or from AUTHID.

yyyyyyyy represents the new, or to AUTHID.

Both the from and the to AUTHID must be specified. The values specified must be complete, that is to say, wildcard characters are not allowed.

Specify R to denote the end of a replacement pair (R is required).

Valid Entries:

A valid AUTHID, not to exceed 18 alphanumeric characters.

Default Value:

(No default)

PLNEXIT=

Use this parameter to indicate whether a plan selection "exit" is to be invoked.

NO specifies no plan selection exit.

YES indicates the system-level plan selection exit is to be used.

Use PLNEXIT=xxxxxxxx with the TYPE=INIT parameter to define a system-level plan selection exit. To specify a unique plan selection exit for this set, specify PLNEXIT=xxxxxxxx with the other TYPE=ENTRY specifications. For more information about writing plan selection exit routines, see Dynamic Plan Selection Exit Routines.

Valid Entries:

NO, YES, or the name (up to 8 alphanumeric characters) of the plan selection exit to be used.

Default Value:

NO

TYPE=

INIT must be specified first (and only once) to set up initialization values for the table. The only other parameter that may be specified together with TYPE=INIT is PLNEXIT=name (if applicable). In this case, PLNEXIT=name specifies the system-level plan selection exit name.

END must be specified last (and only once) to complete generation of the Dynamic Plan Selection Table. No other parameters can be specified with TYPE=END.

ENTRY creates the entries in the Dynamic Plan Selection Table. Specify TYPE=ENTRY as many times as needed to define the criteria for your Dynamic Plan Selection Table.

Valid Entries:

INIT, END, ENTRY

Default Value:

(No default)

TXID=xxxx

Defines the transaction identifier for which a switch in an AUTHID value may occur. The transaction ID can be specified as a unique value (that is to say, all four characters specified), or wildcard characters may be used to limit the number of entries that may be required to exist in the table. The following wildcard characters may be used:

?

A question mark means allow any character in this position to be accepted in selection determination.

*

An asterisk means ignore any characters in this and subsequent positions and use only the characters before the * (asterisk) in selection determination.

For example, D?Y? would include any transaction with D in the first position and Y in the third position of the transaction ID in the selection determination, while DB* would include any transaction beginning with DB in the selection determination.

Valid Entries:

Any combination of up to 4 alphanumeric characters, which may include the wildcard characters ? or * (a question mark or an asterisk).

Default Value:

(No default)