DSNT285I csect-name bind-type FOR object-type = object-name USE OF APCOMPARE RESULTS IN count-1 STATEMENTS WHERE COMPARISON IS SUCCESSFUL count-2 STATEMENTS WHERE COMPARISON IS NOT SUCCESSFUL count-3 STATEMENTS WHERE COMPARISON COULD NOT BE PERFORMED.

Explanation

csect-name
The name of the control section that issued the message.
bind-type
The type of bind subcommand: BIND or REBIND
object-type
The type of object: PACKAGE or SERVICE
object-name
The name of the package or service.
count-1
The number of statements where previous access path was identical to the incoming access path.
count-2
The number of statements where previous access path was not identical to the incoming access path.
count-3
The number of statements where the comparison could not be performed. This could happen either because the previous access path was not found, or because the no new access path was generated.

The sum of the total counters in message DSNT285I might be larger than the number of static statements in the package. The sum of counters is equal to number of the statements in the SYSIBM.SYSPACKSTMT table. If the sum is larger than the number of static statements in the package, one or more statements might have been bound twice, which occurs in the following situations:

  • SYSTIMESENSITIVE is set to YES, and the statement references a system-period temporal table or bitemporal table.
  • The ARCHIVESENSITIVE bind option is set to YES, and the statement references an archive table.

For more information about why these statements are bound twice, see the APCOMPARE bind option information.

System action

If APCOMPARE(WARN) was specified, the command proceeds normally. If APCOMPARE(ERROR) was specified, the command aborts. If APREUSE(ERROR) was specified, and count-2 is a non-zero value, the command aborts.

User response

Determine whether the APCOMPARE usage reported in the message matches the expected result. If EXPLAIN(YES) or EXPLAIN(ONLY) was used, refer to the PLAN_TABLE.REMARKS column for more information about individual statements that failed the access path comparison.