ACCELMODEL in macro DSN6SPRM
Specifies whether to enable the modeling of query workloads for evaluating the potential savings for both accumulated elapsed time and processor time if the plan is run on an accelerator server.
Only queries that DB2® deems eligible to run on an
accelerator server are included in the accelerator-related fields of accounting trace IFCID 3.
- NO
- Specifies that modeling is not done. NO is the default.
- YES
- Specifies that modeling is done.
The YES value
applies only when the following requirements are also met:
- The value of the QUERY ACCELRATION subsystem parameter value is NONE, ENABLE, ENABLE WITH FAILBACK or ELIGIBLE.
- The CURRENT GET_ACCEL_ARCHIVE special register value is NO.
- The GET_ACCEL_ARCHIVE subsystem parameter value is NO
If other values are specified, DB2 tries to accelerate queries instead of doing accelerator modeling.