SYSIBM.SYSQUERYOPTS table

The SYSIBM.SYSQUERYOPTS table contains optimization parameters for the queries that are in the SYSIBM.SYSQUERY table.

Column name	Data type	Description	Use
QUERYID	BIGINT NOT NULL ON DELETE CASCADE	Unique identifier for the query. This column corresponds to the QUERYID column in the SYSIBM.SYSQUERY table.	G
COPYID	SMALLINT NOT NULL	The version of the plan hints for the query in this row. 0 Current version of the plan hints. 1 Previous version of the plan hints used by PLAN STABILITY 2 Original version of the plan hints used by PLAN STABILITY	G
REOPT	CHAR(1) NOT NULL	The value of the REOPT bind option that is in effect for the plan: 1 REOPT(ONCE) A REOPT(AUTO) N REOPT(NONE) Y REOPT(ALWAYS) blank REOPT is not specified	G
STARJOIN	CHAR(1) NOT NULL	Whether star join is enabled: Y Star join is enabled N Star join is disabled blank Star join is not specified	G
MAX_PAR_DEGREE	INTEGER NOT NULL	The maximum parallel degree. This column will contain a value between 0 and 254. If the value of the column is -1, the maximum parallel degree is not specified.	G
DEF_CURR_DEGREE	CHAR(3) NOT NULL	Whether query parallelism is enabled: ONE Query parallelism is disabled ANY Query parallelism is enabled blank Query parallelism is disabled	G
SJTABLES	INTEGER NOT NULL	The number of tables specified in a query to qualify for star join processing. If this column contains -1, star join processing is not specified.	G
	VARCHAR(128) NOT NULL	For IBM® internal use only	I
GROUP_MEMBER	VARCHAR(24) NOT NULL	The group member name to which the parameters are to be applied. This column contains blank if the group member name is not specified.	G
IBMREQD	CHAR(1) NOT NULL	A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies.	G