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
•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:
oConcatenated DB2 key of row
oId 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 | |
OTDBP140 | DB2 Manager | V1.1 |
|
Table Analysis | Utility |
| |
Table: OTDBSYST.TAB1A | Processing report |
| |
|
|
| |
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 |
...........
108 | DB2 Manager User Guide |
| StorageTek Proprietary |
