DSNT222I csect-name bind-type WARNING FOR object-type = object-name USE OF OPTHINT RESULTS IN count-1 STATEMENTS WHERE OPTHINT FULLY APPLIED count-2 STATEMENTS WHERE OPTHINT NOT APPLIED OR PARTIALLY APPLIED count-3 STATEMENTS WHERE OPTHINT IS NOT FOUND
Explanation
The OPTHINT option of Bind or
Rebind was specified. This message gives counts of the number of statements
where a hint was fully applied, not fully applied, or not found.
- csect-name
- The name of the csect from which the message was issued.
- bind-type
- Type of BIND subcommand: BIND or REBIND.
- object-type
- PLAN or PACKAGE
- 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'.
- count 1
- The number of statements where hints were found, and all hints found were successfully applied.
- count 2
- The number of statements where hints were found and at least one of those hints could not be successfully applied.
- count 3
- The number of statements where there were no matching optimization hints found.
System action
Processing continues normally.
Programmer response
Examine the counts to ensure that the specified optimization hints were applied to the intended statements. Refer to SQL codes +394 and +395 for more information about individual statements.