DB2 Manager Control Region

4

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:

44

DB2 Manager User Guide

 

StorageTek Proprietary

Page 47
Image 47
StorageTek 312564001 manual DB2 Manager Control Region, Control region initialization