StorageTek 312564001 manual Functions, JCL requirements, DB2 Manager User Guide

migrated rows in the DB2 table will be resolved by the utility. This is required to ensure that re-organization of non-archive partitions can occur without reference to migrated rows in the Archive Manager database.

The table to be processed is identified by the customer via an SQL command. Execution of the program is controlled via a series of parameters in file SYSIN.

A print report is issued by the utility giving details of the execution parameters, and detailed and/or summary information about objects which have been deleted from Archive Manager. The detailed report will contain one entry for each object which has been deleted from the Archive Manager database. Each entry will contain the key of the Archive Manager object.

Functions

The DB2 Manager database housekeeping utility performs the following functions:

•It will process and validate a series of execution parameters from file SYSIN, and a table identification parameter from file SQLIN which will govern execution of the utility. The utility will then obtain information from DB2 about the table to be analyzed.

•It will sequentially scan the DB2 table identified in the SQLIN file, and for each migrated row will record information about the Archive Manager database object containing the migrated row. No access to the migrated rows themselves is required during the procedure.

•When all rows have been scanned, the utility will analyze the collected information to identify objects in the Archive Manager database which no longer contain any active migrated rows. It will issue a standard Archive Manager object deletion request for each such object. An entry may optionally be written to the detailed processing report for each deleted objects.

•At the end of processing, a report will be produced giving a summary analysis of the rows in the DB2 table and the objects deleted from the Archive Manager database.

JCL requirements

The following JCL may be used to execute the utility:

//*

//STEP170 EXEC PGM=OTDBP170,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=Table.identification.file,DISP=SHR
//SYSPRINT	DD	SYSOUT=*

	//*
110	DB2 Manager User Guide
	StorageTek Proprietary