StorageTek 312564001 manual DB2 Manager Utilities, OTDBP120 - the row restore utility

DB2 Manager Utilities

6

A number of batch utility programs are supplied with DB2 Manager, for provision of a range of facilities for supporting the DB2 Manager operational environment, and for extending functional capabilities supplied with other components of the product.

These utilities consist of:

•OTDBP120 – the DB2 Manager row restore utility. This utility allows customers to identify migrated rows which are to be restored from Archive Manager to DB2 storage. The utility will retrieve selected rows from Archive Manager storage, and restore them in the DB2 table from which they were originally migrated.

•OTDBP130 – the DB2 Manager pre-fetch utility. This utility allows customers to pre-fetch Archive Manager objects containing identified migrated rows from tape to disk storage within an Archive Manager database. The migration status of rows processed by this utility will remain unaltered.

•OTDBP140 – the DB2 Manager table analysis utility. This scans a DB2 table and issues a print report giving a detailed and/or summary analysis of the contents of the table, identifying rows which have been migrated to Archive Manager storage.

•OTDBP170 – the DB2 Manager database housekeeping utility. This scans a DB2 table and deletes any objects from the corresponding Archive Manager database which no longer hold active migrated rows. This will allow utilities supplied with the base Archive Manager product to reclaim space occupied by deleted objects.

OTDBP120 - the row restore utility

OTDBP120 is the DB2 Manager row restore utility program. The program is executed as a batch job in order to retrieve one or more migrated rows from an Archive Manager database and to return them to the DB2 table from which they were originally migrated. After restore, the rows will be implicitly deleted from the Archive Manager database, and will become resident in DB2 only. They will then be eligible for migration back to Archive Manager by the table migration utility OTDBP100 at some subsequent time.

The rows to be restored from Archive Manager are identified by the customer via search criteria in an SQL command, in an identical manner to the way in which rows are identified for selection for migration by OTDBP100. Execution of the program is controlled via a series of execution parameters.

DB2 Manager User Guide	93
StorageTek Proprietary