Start of change

DSNT324I   csect-name bind-type FOR PACKAGE = package-name FAILED, BECAUSE THE DB2 SYSACCEL TABLES OR INDEXES ARE NOT DEFINED CORRECTLY.

Explanation

A REBIND or BIND COPY PACKAGE failed because DB2® detected that SYSACCEL objects exist but are not defined correctly. Even though the QUERYACCELERATION or GETACCELARCHIVE bind options are not specified on the REBIND or BIND COPY subcommand, if these SYSACCEL objects exist DB2 must use them to determine if the package was previously bound with QUERYACCELERATION. If these SYSACCEL objects do not exist, DB2 does not use them if REBIND or BIND COPY do not specify QUERYACCELERATION or GETACCELARCHIVE.

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)'.

System action

The named package is not bound.

User response

If you want DB2 to use the SYSACCEL objects that you created, verify that you ran 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 objects, you must remove the QUERYACCELERATION and GETACCELARCHIVE bind options.

End of change