GETACCELARCHIVE bind option
The GETACCELARCHIVE bind option specifies whether a static SQL query that is bound for acceleration retrieves archived data on the accelerator, instead of active data.
When a package that is bound with this bind option runs, the GETACCELARCHIVE value, instead of the GET_ACCEL_ARCHIVE subsystem parameter, provides the initial value for the CURRENT GET_ACCEL_ARCHIVE special register. The CURRENT GET_ACCEL_ARCHIVE special register specifies whether a query that references a table that is archived on an accelerator server uses the archived data. Therefore, by rebinding the application package with the GETACCELARCHIVE bind option, you can also specify that accelerated dynamic SQL queries in an application retrieve only archived data on the accelerator. You can specify this bind option instead of either modifying the application to add an explicit SET CURRENT GET_ACCEL_ARCHIVE statement or setting the GET_ACCEL_ARCHIVE subsystem parameter. For dynamic SQL queries in a package, the bind option value that is specified overrides the GET_ACCEL_ARCHIVE subsystem parameter. This bind option does not have a default value, so if you do not specify this bind option, the GET_ACCEL_ARCHIVE subsystem parameter initializes the special register.
GETACCELARCHIVE |
|
On: BIND and REBIND
PACKAGE Not valid for REBIND of a native SQL procedure package. |
- ( NO )
- Specifies that no static SQL query is bound to retrieve archived
data from the accelerator. If the static query also is not bound for
acceleration, the query is bound to run in DB2®.
If the static query is bound for acceleration because the QUERYACCELERATION bind option was specified, the query is routed to the accelerator when the application runs; however, the query does not retrieve any archived data.
- ( YES )
- Specifies that if all of the following criteria are met, the query
is bound for acceleration and retrieves the archived data on the accelerator
when the application runs:
- The QUERYACCELERATION bind option is also specified.
- The static SQL query references an accelerated table that has partitioned data archived on an accelerator.
- The static query satisfies the acceleration criteria that is specified by the QUERYACCELERATION bind option.
If the static query does not satisfy the acceleration criteria that is specified by the QUERYACCELERATION bind option, the BIND or REBIND PACKAGE operation fails with an error message for that query.
Process | Default value |
---|---|
BIND PACKAGE | None |
REBIND PACKAGE | None |
There is no default value for this bind option. The GETACCELARCHIVE bind option does not inherit the setting from the GET_ACCEL_ARCHIVE subsystem parameter.