StorageTek Lifecycle Director DB2 Manager 312564001 User Manual

Page of 189
 
44 
DB2 Manager User Guide 
 StorageTek 
Proprietary 
DB2 Manager Control Region 
 
All access to Archive Manager databases containing migrated rows is 
performed via the DB2 Manager control region.   This is a started task, which 
must be initiated prior to performing any DB2 row migration or retrieval 
activities.   
This chapter describes the operation and control of the DB2 Manager control 
region. 
The DB2 Manager control region performs the following functions: 
•  Enables DB2 Manager for Archive Manager database processing. 
•  Enables interception of all SQL insert, update and retrieve commands for 
DB2 tables which have been enabled for DB2 Manager migration 
processing.  
•  Establishes the environment for object storage and retrieval from Archive 
Manager. 
•  Processes SQL retrieve and update requests for rows which have been 
migrated to Archive Manager. 
•  Performs object storage processing when migrating rows to an Archive 
Manager database. 
•  Performs SMF record creation to record DB2 Manager row access activity. 
•  Processes requests from the operator interface facility. 
No other system activities are required in order to enable DB2 Manager row 
storage and  retrieval processing.  In particular, no modifications are required 
to existing application coding to allow access to rows which have been 
migrated to an Archive Manager database. 
 
Control region initialization 
The DB2 Manager control region is initiated as an MVS started task.  Any 
valid procedure name may be assigned to this started task.  The procedure 
used for starting this task was created during the DB2 Manager installation 
process.  JCL to execute this procedure is supplied in the sample JCL library 
distributed with the product. 
The following points should be noted regarding creation and maintenance of 
the LCDDB2 procedure: