Filter
Top Products
108 DB2 Manager User Guide
StorageTek Proprietary
received by the utility, which will cause it to terminate with a condition code of
12. In these circumstances, the SQL statement should be corrected and the
job restarted.
Print reports
The table analysis utility will write a number of print reports to the SYSPRINT
dataset during execution. These consist of:
• 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 un-migrated rows and the number of
migrated rows.
• 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 Concatenated DB2 key of row
o Id of Archive Manager database containing migrated row
o Database storage level containing migrated row
o Key of Archive Manager object containing migrated row
o Archive date of Archive Manager object containing migrated row
o Start record number within Archive Manager object
o Record count
o Sequence number of tape containing start of object
o Sequence number of tape containing end of object
o Block id containing start of object
o An indicator (‘D’) which is set if a disk copy of the object exists in
the Archive Manager database
See Figure 5 below 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
OTDBP140 Table Analysis Utility
Processing report
Table: OTDBSYST.TAB1A
---------------------------------------------------------------------------------------------------------
DBid S Primary Archive Rec Rec Start End Tape D DB2 Concatenated
L Key Date No Count Seq Seq Block id Key
ST01 0 000000A3 2003/03/06 00053 00001 00002 00002 02400150 D AC00001201002
ST01 0 000000A3 2003/03/06 00068 00001 00002 00002 02400150 D AC00002201002
ST01 0 000000A3 2003/03/06 00071 00001 00002 00002 02400150 D AC00003211002
ST01 0 000000A3 2003/03/06 00065 00001 00002 00002 02400150 D AC00006241002
...........