After correcting the error, the utility may be rerun normally. No special actions need to be taken prior to
Archive Manager housekeeping processing
Standard Archive Manager object management processing should be performed on a regular basis to delete the expired
OTDBP140 - the table analysis utility
OTDBP140 is the DB2 Manager table analysis utility program. The program is executed as a batch job in order to produce a detailed and/or summary analysis of the rows in a DB2 table which has been enabled for row migration processing by DB2 Manager.
A print report is issued by the utility giving details of the execution parameters, summary information about the rows in the DB2 table, and optionally a detailed report on the contents of the table.
Functions
The DB2 Manager table analysis utility performs the following functions:
•It will process and validate a series of execution parameters from a SYSIN file, and an SQLIN table identification parameter which will govern execution of the utility. The utility will then obtain information from DB2 about the table to be analyzed.
•It will scan the DB2 table, and identify whether a row has been migrated to DB2 Manager or not. For each migrated row, it will optionally write an entry to the detailed processing report, identifying the row and its location in the associated Archive Manager database.
•At the end of processing, a summary processing report will be produced giving an analysis of table rows.
JCL requirements
The following JCL may be used to execute the utility:
//*
//STEP140 EXEC PGM=OTDBP140,REGION=4096K
DB2 Manager User Guide | 105 |
StorageTek Proprietary |
|
