DSNT297I csect-name bind-type WARNING FOR object-type = object-name USE OF SELECTIVITY OVERRIDES RESULTS IN count-1 STATEMENTS WHERE SELECTIVITY OVERRIDES ARE FULLY APPLIED count-2 STATEMENTS WHERE SELECTIVITY OVERRIDES ARE INVALID count-3 STATEMENTS WHERE SELECTIVITY OVERRIDES ARE NOT FOUND

Explanation

During bind or rebind one or more statements matched a query in SYSIBM.SYSQUERY catalog table for which selectivity overrides were specified. This message gives counts of the number of statements for which selectivity overrides were fully applied, invalidated, or not found.

csect-name

The name of the control section that issued the message.

bind-type

Type of BIND subcommand: BIND or REBIND

object-type

PLAN, PACKAGE, or SERVICE

object-name

If object-type is PLAN, object-name is the name of the plan.

If object-type is PACKAGE, object-name is the name of the package in the format 'location-id.collection-id.package-id'.

If object-type is SERVICE, object-name is the name of the service in the format 'location-id.collection-id.service-name.

count-1

The number of statements for which selectivity overrides were found, and all selectivity overrides were successfully applied.

count-2

The number of statements for which selectivity overrides were found but were not applied because one of more overrides were found to be invalid,

count-3

The number of statements for which no selectivity overrides were found.