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.