Start of change

OPTIOWGT in macro DSN6SPRM

Controls how DB2® balances the I/O cost and CPU estimates when selecting access paths.

Valid values are ENABLE, DISABLE, or OFF. ENABLE specifies that when selecting access paths, DB2 is to use a new formula that better balances the cost estimates of I/O response time and CPU usage. When DISABLE is specified, ENABLE is used instead. OFF specifies that DB2 is to use the original formula to balance the CPU and I/O estimates.

ENABLE is the default value.

Attention: Changing the OPTIOWGT parameter could impact the access paths of queries that are otherwise stable. For more advice on how to set this parameter, contact IBM® Software Support.

This subsystem parameter is deprecated in DB2 10.

End of change