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: Start of changeYESEnd of change
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.