•Parameter specification and validation report. This will contain a list of execution parameters specified (or defaulted) in file SYSIN, and a validation error report if errors are detected in parameter specification. It will also specify the table identification statement coded in the SQLIN file.
•Execution report. Any errors or warning conditions encountered during execution of the utility will be identified in this report.
•Summary processing report. At end of processing, the utility will write the summary processing report which will identify the total number of rows in the table, the number of migrated rows, the number of rows normalized during processing (ie. wrongly located migrated rows which have been moved from a
•Detailed processing report. If PRINT=DETAIL is specified (or defaulted) in the execution parameters, the utility will create an entry in this report for each migrated row in the table. This entry will contain the following information for each migrated row:
oId of Archive Manager database containing deleted object
oArchive Manager database storage level containing deleted object o Primary key of deleted object
o Archive date of deleted object
o Archive Manager tape sequence number containing start of deleted object
o Archive Manager tape sequence number containing end of deleted object
o Identifier of tape block containing start of deleted object
See Figure 6 for an example of the detailed processing report.
(C) StorageTek Corp. | Lifecycle Director | YYYY/MM/DD HH:MM:SS Page nnnn |
OTDBP170 | DB2 Manager V1.1 |
|
Database Housekeeping Utility |
| |
TABLE: OTDBSYST.TAB1A | Processing report |
|
|
|
DBid S Primary | Archive | Start | End | Tape | ||
| L Key | Date | Seq | Seq | Block | |
ST02 | 0 | 0000005C | 2003/02/05 | 00001 | 00001 | 01400005 |
ST02 | 0 | 0000005D | 2003/02/05 | 00001 | 00001 | 01400010 |
ST02 | 0 | 00000061 | 2003/02/12 | 00001 | 00001 | 014001A2 |
...........
Figure 6: Detailed processing report
Condition codes
The database housekeeping utility will set a condition code on completion.
This code may take the following values:
0 - | the utility has been executed successfully. |
|
| DB2 Manager User Guide | 113 |
| StorageTek Proprietary |
|
