DSNT281I bind-command QUERY FOR query-type = query-identifier NOT SUCCESSFUL. REASON: reason-text

Explanation

Errors were detected during processing of a BIND QUERY or related operation on a query.

bind-command

The type of command that resulted in the message:

BIND

For BIND QUERY commands.

FREE

For FREE QUERY commands.

LOOKUP

For BIND QUERY commands when the LOOKUP(YES) option is in effect.

query-type

Information that identifies the query:

QUERYNO

The query is identified by the query number (QUERYNO) in the table DSN_USERQUERY_TABLE.

QUERYID

The query is identified by the query ID (QUERYID) in the table SYSIBM.SYSQUERY.

query-identifier

The query number or query ID, depending on the query-type value.

reason-text

reason-text is one of the following values:

1. PACKAGE INFORMATION IS INVALID

The specified package information is not valid

2. THE HINT, OPTION, OR OVERRIDE WAS NOT FOUND

The LOOKUP option was specified and the specified hint, option, or override was not found in the catalog tables.

3. THE STATEMENT TEXT CONTAINS AN ERROR

The statement text contains an error.

4. THE STATEMENT TYPE IS NOT SUPPORTED

The statement is of a type that is not supported by the BIND QUERY command.

5. BIND QUERY DOES NOT SUPPORT package-type PACKAGES

The query is from a package of a type that is not supported by the BIND QUERY command. Example values for package-type might include:

• 'TRIGGER'
• 'PROCEDURE'
• 'FUNCTION'

6. THE qualified-table-column COLUMN CONTAINS AN INVALID VALUE = invalid-value

The input table column that is identified by qualified-table-column contains an invalid value, which is provided as invalid-value.

7. A REQUIRED object-type qualifier.object-name DOES NOT EXIST

The specified object does not exist.

8. THE qualified-table-column COLUMN FOR PREDNO predno-value CONTAINS AN INVALID VALUE = invalid-value

The input table column that is identified by qualified-table-column contains an invalid value, which is provided as invalid-value. predno-value identifies the PREDNO value of the row that contains the invalid value.

9. THE qualified-table-column COLUMN CONTAINS AN INVALID COMBINATION OF VALUES: invalid-combination

qualified-table-column identifies a column that contains an invalid combination of values in several rows. Example values for invalid-combination include:

NON-MATCHING WEIGHT VALUES FOR ROWS WITH THE SAME INSTANCE VALUE: instance-value

For each query, every row with the same instance value must of have the same weight value.

SUM OF INSTANCE WEIGHTS > 1.0

For each query, the sum of weights for all instance values must be less-than or equal to 1.0.

NUMBER OF DISTINCT INSTANCE VALUES instance-count IS GREATER THAN max-instances.

Too many instances where specified. Db2 supports only as many instances as the value specified by max-instances

10. THE qualified-table-column COLUMN CONTAINS AN INVALID COMBINATION OF VALUES FOR PREDNO = predno-value: invalid-combination

The input table column that is identified the qualified-table-column value contains an invalid combination of values in several rows. Example invalid-combination values might include:

• MULTIPLE ROWS CONTAIN THE SAME INSTANCE VALUE instance-value
• DUPLICATE ROWS EXIST FOR THE SAME COMPOUND PREDICATE

The predno-value identifies the PREDNO value of the rows that contain the invalid combination of values.

11. INPUT TABLE COLUMNS CONTAIN INCOMPATIBLE VALUES additional-information

The value of additional-information is a string that identifies the reason that the command failed. Examples might include:

• THE VALUE OF THE STARJOIN COLUMN CANNOT BE 'Y' WHEN MORE THAN ONE SELECTIVITY INSTANCE EXISTS
• A VALUE IN THE PREDNO COLUMN OF DSN_SELECTIVITY TABLE DOES NOT EXIST IN DSN_PREDICATE_TABLE
• NONE OF THE FOLLOWING VALUES CONTAINS A 'Y' VALUE: ACCESSPATH_HINT, SELECTIVITY_OVERRIDE, AND OPTION_OVERRIDE
• ONE OF THE FOLLOWING COLUMNS CONTAINS A BLANK VALUE: ACCESSPATH_HINT, SELECTIVITY_OVERRIDE, AND OPTION_OVERRIDE. ALL MUST CONTAIN VALUES WHEN ANY IS SPECIFIED

When bind-command is LOOKUP, an instance of the DSNT281I message is issued for each row in the DSN_USERQUERY_TABLE that has matching rows in both the SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN catalog tables.