StorageTek 312564001 manual DB2 Manager User Guide

Models: 312564001

1 189
Download 189 pages 56.09 Kb
Page 139
Image 139

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.

136

DB2 Manager User Guide

 

StorageTek Proprietary

Page 139
Image 139
StorageTek 312564001 manual DB2 Manager User Guide