DSNT321I csect-name bind-type FOR PACKAGE = package-name FAILED. bind-type OPTION option-name IS USED BUT IS INVALID BECAUSE THE DB2 TABLE SYSACCEL.SYSACCELERATEDPACKAGES OR ITS INDEXES DO NOT EXIST OR ARE NOT DEFINED CORRECTLY.
Explanation
A BIND or REBIND PACKAGE that specifies the QUERYACCELERATION or GETACCELARCHIVE bind options failed because the DB2® table SYSACCEL.SYSACCELERATEDPACKAGES or its indexes do not exist or are not defined correctly. These bind options require that these SYSACCEL objects are created correctly before running BIND or REBIND PACKAGE.
DB2 supplies the DDL for these objects in job DSNTIJAS. If the DDL was run but modified from its original form, the objects might not be created according to the correct specifications.
- 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
Create the SYSACCEL.SYSACCELERATEDPACKAGES table and its indexes by running the DDL that is supplied in job DSNTIJAS. Do not modify the DDL unless directed by IBM® Support. If the DDL was modified incorrectly, contact IBM Support for assistance.
If you cannot correctly create the SYSACCEL.SYSACCELERATEDPACKAGES table and its indexes, you must remove the QUERYACCELERATION and GETACCELARCHIVE bind options.