Filter
Top Products
DB2 Manager User Guide 113
StorageTek Proprietary
• 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 non-archive to the archive partition, and vice
versa), and number of Archive Manager objects deleted.
• 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:
o Id of Archive Manager database containing deleted object
o Archive Manager database storage level containing deleted object
o Primary key of deleted object (4-byte hexadecimal value)
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
DB2 Manager V1.1
OTDBP170 Database Housekeeping Utility
Processing report
TABLE: OTDBSYST.TAB1A
---------------------------------------------------------------------------------------------------------
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.