StorageTek 312564001 User Manual

136

DB2 Manager User Guide

StorageTek

Proprietary

Action: Check that the correct DB2 table name has been specified in the

SQLIN file. If not, correct the entry and re-submit the job.

OTD14012

All columns in the DB2 table have been specified as KEY fields

Explanation: There are no non-indexed columns in the table being analyzed. The

utility requires that there be at least one non-index column in the
table. Processing of the utility is terminated with condition code 12.

Action: Check that the correct table name has been specified in the SQLIN

statement. If it has, and the table contains no non-index columns,
then the utility cannot be executed against this table.

OTD14013

Retrieval using the specified KEY fields cannot be made via
INDEXONLY processing

Explanation: Scanning of the table using the key fields specified in the SELECT

statement in the SQLIN file cannot be performed via index-only
processing. Execution of the utility cannot continue, and is
terminated with a condition code 12.

Action: Modify the SELECT statement in the SQLIN file to ensure that the

specified columns are those used to uniquely index a row in the table,
and re-submit the job.

OTD14014

Return Code xx, Supp codes X'yyyyyyyy' received during OPEN |
QUERY | CLOSE processing for Archive Manager database zzzz

Explanation: An error has been received from an Archive Manager open, query or

close request. ‘xx’ gives the return code and ‘yyyyyyyy’ the
hexadecimal supplementary reason codes received from Archive
Manager. Execution of the utility has been terminated with condition
code 12.

Action: Refer to the Archive Manager User Manual for a description of the

return and supplementary codes displayed in the message. Take the
appropriate corrective action and re-submit the job. If no obvious
reason for the error can be identified, contact your local STK support
representative.