Filter
Top Products
94 DB2 Manager User Guide
StorageTek Proprietary
A print report is issued by the utility giving details of the execution
parameters, the row restore selection criteria and summary information about
the rows restored from Archive Manager.
Functions
The DB2 Manager row restore utility performs the following functions:
• It will process and validate a series of execution parameters from a
SYSIN file, and an SQLIN object selection parameter which will govern
execution of the utility. The utility will then obtain information from DB2
about the table to be updated.
• It will scan the DB2 table, and select migrated rows for restore from the
Archive Manager database which satisfy the selection criteria specified in
the SYSIN dataset. An entry is written to an internal table for each
selected row.
• After all rows in the table have been processed in this manner, the utility
will sort all entries in the table into ascending database sequence. This
will allow the utility to access the migrated rows in the most efficient
manner, with the minimum amount of tape handling processing.
• The utility will process the sorted table sequentially. For each entry, the
utility will update the corresponding table row by setting the archive
indicator column (OTDBIND) back to ‘0’. This will cause the row to be
retrieved from the Archive Manager database, and the 18-byte archive
stub (in the table’s archive partition) to be replaced by the actual row (in
one of the table’s non-archive partitions).
• Following successful update of a row, all subsequent access to that row
will be satisfied from the DB2 table as normal. Access to the migrated
row will have been lost. Storage space within the Archive Manager
database for that row may be reclaimed by executing the DB2 Manager
database housekeeping utility (as described on page 109).
• At the end of processing, a report will be produced giving the total number
of rows which have been restored.
JCL requirements
The following JCL may be used to execute the utility:
//*
//STEP120 EXEC PGM=OTDBP120,REGION=4096K
//*
//STEPLIB DD DSN=Database.Manager.load.library,DISP=SHR
// DD DSN=Archive.Manager.load.library,DISP=SHR
//*
//OTASxxxx DD DSN=Archive.Manager.index.dataset,DISP=SHR
//SYSIN DD DSN=Execution.parameter.file,DISP=SHR
//SQLIN DD DSN=Row-restore.criteria.file,DISP=SHR
//SYSPRINT DD SYSOUT=*
//*
DD entries should be specified as follows: