StorageTek 312564001 manual Print reports, oConcatenated DB2 key of row

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:

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