APCOMPARE bind option
The APCOMPARE option determines whether the new access paths are different from the older access paths.
APCOMPARE |
|
On: BIND PACKAGE, REBIND PACKAGE, and REBIND TRIGGER PACKAGE |
- (NO)
- DB2® does not compare access paths.
- (NONE)
- DB2 does not compare access paths.
- (WARN)
- DB2 compares the old and new access paths for each matching statement. If the access paths are structurally dissimilar, DB2 sends message DSNT285I and continues processing the package.
- (ERROR)
- DB2 compares the old and new access paths for each matching statement. If the access paths are structurally dissimilar, DB2 sends message DSNT285I and terminates package processing.
The APCOMPARE option is ignored for packages and package copies that were bound prior to DB2 9. You can identify the version on which a package or package copy was bound by checking the RELBOUND column in the SYSIBM.SYSPACKAGE or SYSIBM.SYSPACKCOPY catalog table.
Defaults:
Process | Default value |
---|---|
BIND PLAN | N/A |
BIND PACKAGE | NONE |
REBIND PLAN | NONE |
REBIND PACKAGE | NONE |