DSNT320I csect-name bind-type FOR PACKAGE = package-name FAILED. bind-type OPTION option-name IS USED BUT IS INVALID BECAUSE DB2 SUBSYSTEM PARAMETER ACCEL = NO, AND THIS DB2 SUBSYSTEM IS NOT ENABLED FOR QUERY ACCELERATION.
Explanation
A BIND or REBIND PACKAGE that specifies the QUERYACCELERATION or GETACCELARCHIVE bind options failed because the DB2® subsystem is not enabled for query acceleration.
- csect-name
- The name of the control section that issued the message.
- bind-type
- The type of bind subcommand: BIND or REBIND.
- package-name
- The fully qualified name of the package in the following format: 'location.collection.package.(version)'.
- option-name
- The bind option QUERYACCELERATION or GETACCELARCHIVE.
System action
The named package is not bound.
User response
Change the value of the ACCEL subsystem parameter to AUTO or COMMAND to enable the DB2 subsystem for query acceleration. You cannot change the ACCEL subsystem parameter online. You must stop and restart DB2 for a change to ACCEL to take effect.
If you cannot change the ACCEL subsystem parameter, you must remove the QUERYACCELERATION and GETACCELARCHIVE bind options.
