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.
| Acceptable values: | NO, YES |
|---|---|
| Default: |  YES |
| DSNZPxxx: | DSN6SPRM ACCELMODEL |
| Security parameter: | No |
- YES
- Enables modeling of query acceleration. 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.
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
- Disables modeling of query acceleration.