Filter
Top Products
DB2 Manager User Guide 93
StorageTek Proprietary
DB2 Manager Utilities
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.
6