Start of change

ACCELERATOR bind option

The ACCELERATOR option sets the preferred target accelerator server or servers for accelerated static SQL queries and is the default value for the CURRENT ACCELERATOR special register used for dynamic SQL queries when the SET CURRENT ACCELERATOR statement is not issued.

Command option Option values Used with
ACCELERATOR
  • accelerator-name
Note:
  1. The ACCELERATOR bind option is not valid for REBIND of packages for advanced triggers.

The bind option value affects runtime behavior only.

If a specified accelerator does not exist during bind time, a warning is issued.

If the specified preferred accelerator server is not enabled or available at runtime, Db2 will send the queries to other available accelerator servers.

Default values for ACCELERATOR

Process Default value
BIND SERVICE None
BIND PACKAGE None
REBIND PACKAGE Existing value
End of change