expiration of this time interval. Refer to the Lifecycle Director Archive Manager User Guide for information about setting
Functions
The DB2 Manager
•It will process and validate a series of execution parameters from a SYSIN file, and an SQLIN row selection parameter which will govern execution of the utility. The utility will then obtain information from DB2 about the table from which the rows to be
•It will scan the DB2 table, and select migrated rows for
•For each selected row, a
•When the number of requests accepted by Archive Manager has reached the batch size specified in the execution parameters, the program will issue a request to Archive Manager to process the batch. This will cause Archive Manager to sort all requests in the batch into the most efficient sequence for retrieval from tape, and to create disk copies of each object in the batch. Note that the same object may appear multiple times in each batch, if multiple rows within that object have been selected for pre- fetch processing. Archive Manager will ignore duplicate object requests in the batch.
•After all rows in the table have been processed in this manner, a report will be produced giving the total number of rows which have been pre- fetched.
JCL requirements
The following JCL may be used to execute the utility:
//*
//STEP130 EXEC PGM=OTDBP130,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 | |
//SYSPRINT | DD | SYSOUT=* |
//* |
|
|
DD entries should be specified as follows:
100 | DB2 Manager User Guide |
| StorageTek Proprietary |