Condition codes
The table migration utility will set a condition code on completion. This code may take the following values:
0 - | the utility has been executed successfully. |
4 - | a warning condition has been encountered during processing |
| of the utility. A warning message will have been written to the |
| SYSPRINT dataset. The utility has been executed |
| successfully. |
8 - | an error condition has been encountered during processing of |
| the utility. An error message will have been written to the |
| SYSPRINT dataset. Execution of the utility has continued. |
12 - | a serious error has been encountered during processing of the |
| utility. An error message will have been written to the |
| SYSPRINT dataset. Execution of the utility has been |
| terminated. |
Utility failure and restart considerations
If the table migration utility fails to complete successfully (return code greater than 8), consult the error report in the SYSPRINT dataset to identify the cause of the problem. Refer to chapter 7 for a description of the message(s) appearing in the error report. All rows successfully processed prior to the last successful commit point before failure will have been successfully migrated from DB2 to Archive Manager, and any access requests for those objects will be satisfied by DB2 Manager from the appropriate Archive Manager database.
After correcting the error, the utility may be rerun with an execution parameter of “RESTART=YES” specified. The utility will automatically restart processing from the last successful commit point during the failed execution. No other special actions need to be taken prior to
Operator commands
Execution of the utility may be terminated at any point by entering the following command through the system console:
(STO)P jobname
where ‘jobname’ is the name of the job used to execute the object management procedure.
The utility will acknowledge receipt of this command via message OTD10023, and perform normal termination processing. All database updates performed by the utility prior to termination will be committed, and the utility will terminate with a condition code of 4.
DB2 Manager User Guide | 87 |
StorageTek Proprietary |
|