Parallel Group-By SQL Reset Options

The server provides the following Parallel Group-By SQL reset options:

GRPSEL / NOGRPSEL

This option enables or disables the server Parallel Group-By facility.

/* Disable Parallel Group-By */
execute(reset nogrpsel)
 by sasspds ;

FMTGRPSEL / NOFMTGRPSEL

This option enables or disables the server Parallel Group-By use of formats.

/* Disable Parallel Group-By */
/* use of formats.            */
execute(reset nofmtgrpsel)
 by sasspds ;

SCANGRPSEL / NOSCANGRPSEL

Use this option to turn on and off the server Index Scan facility. The default server setting uses the Index Scan facility.

/* Disable index scan facility */
execute(reset noscangrpsel)
 by sasspds ;

/* Enable index scan facility */
execute(reset scangrpsel)
 by sasspds ;
Last updated: February 8, 2017