Prepare for an Online Area Move for Index and Data Areas

The Online Area Move (OAM) functionality provides support for 24x7 businesses.
datacom
Product:
Datacom
/DB
Release: 14.01
OS: z/OS
The Online Area Move (OAM) functionality provides support for 24x7 businesses. Using the Multi-User Facility (MUF), you can move index and data areas from one physical data set to another. The user access to the data rows and indices that are stored in those areas is never interrupted.
This scenario describes how a database administrator (DBA) or a system programmer prepares for an OAM for index and data areas (data sets) from one physical 3390 data set to another 3390 data set. This scenario also covers the use of the DBUTLTY PREINIT function and new options to existing DBUTLTY functions. These functions and options are used to create and manage the target data set that the OAM process uses.
On this page:
Introduction
The OAM functionality allows you to move
Datacom
data sets to support your business needs without causing data access outages to your users.
Example of the business needs that you might encounter are:
  • Data sets are on older 3390 models that no longer provide adequate allocation sizes. For example, a 3390 Mod 3.
  • Data sets are not on 3390 models that are available at your selected Disaster Recovery (DR) site which restricts your ability to move all of your data efficiently to the DR site.
  • Data sets were sized for initial expected amounts of data. The data volume has grown significantly and the data set is now reaching maximum allowable extents.
Before you start an OAM process, create, allocate, and prepare a target data set that the OAM process can use.
Preparing for the Online Area Move - PREINIT
The following steps cover the process that you use to create and manage the target data sets before you execute the OAM process.
Create the PREINIT data set and store info in CXX
Allocate the target data set using standard JCL. You can allocate the data set before or as part of the DBUTLTY PREINIT execution. The DBUTLTY PREINIT function executes in a similar fashion as the existing DBUTLTY INIT function.
The DBUTLTY PREINIT function:
  • Establishes (allocate) and preinitialize (PREINIT) a new target data set for a given DATA or IXX area without changing or interrupting access to the existing (source) area.
  • Executes while the source area is online and available.
  • Determines the target data set attributes using the CXX information from the source area.
  • Provides initial data set location (volume) and size (allocation) from the JCL.
  • Provides secondary data set allocation information using the CXX or the JCL depending on how the source index or data area was defined in the
    Datacom Datadictionary
    .
DBUTLTY Parameters for the Index Area PREINIT
Function:
PREINIT
Parameters:
  • DBID=
    nnnnn
    Specifies the DBID of the Source Area (numeric 1- 5000).
  • AREA=IXX
    Specifies IXX (three characters). IXX is always specified.
  • IXXAREA=IXX/
    Inn
    Specifies either IXX or
    Inn
    where
    nn
    is index number (for example, I01).
  • BLKSIZE=
    nnnnn
    Specifies the block size of source area (numeric 4K-32K).
  • OLDEP=YES/NO
    Specifies whether old entry points are supported.
The PREINIT function does not require you to specify a BLKSIZE or OLDEP value for the IXX area. The BLKSIZE defaults to 4096 while OLDEP defaults to YES.
The specified BLKSIZE and OLDEP value of the PREINIT data set must be the same as the source index area data set for OAM.
Sample DBUTLTY PREINIT Execution
Use the following as a guide to prepare your JCL. The JCL statements are for example only. The lowercase letters in a statement indicate a value that you must supply. Code all statements to your site and installation standards.
//PREINI14 JOB . . . //*-----------------------------------------------------------------** //JOBLIB . . . //*-----------------------------------------------------------------** //* ******************************************** //* ALLOCATE THE TARGET DATA AREA //* ******************************************** //ALLOC EXEC PGM=IEFBR14 //DEM001T DD DSN=DCMQA.QAMUF4.DEM001.ASOF0604,DISP=(NEW,CATLG), // SPACE=(TRK,(0001,01)),UNIT=(WORK) //* //* ******************************************** //* PREINIT THE TARGET DATA AREA //* ******************************************** //PREINIT EXEC PGM=DBUTLTY //DEM001 DD DSN=DCMQA.QAMUF4.DEM001.ASOF0604,DISP=(SHR) //SYSIN DD * PREINIT DBID=001,AREA=DEM,BLKSIZE=4096 /* //* ******************************************** //* ALLOCATE THE TARGET INDEX AREA //* ******************************************** //ALLOC EXEC PGM=IEFBR14 //IXX001T DD DSN=DCMQA.QAMUF4.IXX001.ASOF0606,DISP=(NEW,CATLG), // SPACE=(TRK,(0001,01)),UNIT=(WORK) //* //* ******************************************** //* PREINIT THE TARGET INDEX AREA //* ******************************************** //PREINIT EXEC PGM=DBUTLTY //IXX001 DD DSN=DCMQA.QAMUF4.IXX001.ASOF0606,DISP=(SHR) //SYSIN DD * PREINIT DBID=001,AREA=IXX,IXXAREA=IXX /*
Sample DBUTLTY PREINIT Output - Data Area
Following is a sample report of the DBUTLTY PREINIT output for the data area.
Date: 6/04/2014 ******************************************************************************** Page: 1 * CA Datacom/DB * Time: 23.00.31 * General Utility * Version: 14.0 * COPYRIGHT (C) 1990-2011 CA. ALL RIGHTS RESERVED. * ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 PREINIT DBID=001,AREA=DEM,BLKSIZE=4096 FUNCTION=PREINIT AREA=DEM BLKSIZE=04096 DBID=00001 Date: 6/04/2014 ******************************************************************************** Page: 2 * CA Datacom/DB * Time: 23.00.31 * General Utility * Version: 14.0 * COPYRIGHT (C) 1990-2011 CA. ALL RIGHTS RESERVED. * ******************************************************************************** Directory: QAMUF4 DEM - STATUS INFORMATION DEVICE TYPE - 3390 BLOCK LENGTH - 4,096 BLOCKS/TRACK - 10 BLOCKS IN USE - 1 BLOCKS UNUSED - 9 TOTAL BLOCKS - 10 TOTAL TRACKS - 1 PERCENT FULL - 10
Sample DBUTLTY PREINIT Output - Index Area
Following is a sample report of the DBUTLTY PREINIT output for the index area.
Date: 6/05/2014 ******************************************************************************** Page: 1 * CA Datacom/DB * Time: 17.02.14 * General Utility * Version: 14.0 * COPYRIGHT (C) 1990-2011 CA. ALL RIGHTS RESERVED. * ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 PREINIT DBID=001,AREA=IXX,IXXAREA=IXX FUNCTION=PREINIT AREA=IXX DBID=00001 IXXAREA=IXX Date: 6/05/2014 ******************************************************************************** Page: 2 * CA Datacom/DB * Time: 17.02.15 * General Utility * Version: 14.0 * COPYRIGHT (C) 1990-2011 CA. ALL RIGHTS RESERVED. * ******************************************************************************** Directory: QAMUF4 IXX - STATUS INFORMATION DEVICE TYPE - 3390 BLOCK LENGTH - 4,096 BLOCKS/TRACK - 12 BLOCKS IN USE - 3 BLOCKS UNUSED - 9 TOTAL BLOCKS - 12 TOTAL TRACKS - 1 PERCENT FULL - 16
PREINIT Process Flow pg 2
The following graphic shows the PREINIT process flow.
PREINIT pf _pg2
Additional Considerations
The target data set is ready and the data set information is stored in the PREINIT section of the CXX after you successfully execute the DBUTLTY PREINIT function.
Executing the PREINIT function again for the same area results in a replacement of the PREINIT information in the CXX. No attempt is made to archive or save previous PREINIT information.
If you restore the CXX area from a DBUTLTY CXX backup, the PREINIT information is cleared.
Print CXX PREINIT Section Contents
To generate a report of PREINIT information that is stored in the CXX, use the DBUTLTY REPORT AREA=CXX,TYPE=P function. This function reports on all items in the PREINIT list. If the list is empty, it has nothing to report. The first page of the full CXX report (not TYPE=A) and the same report requested as TYPE=K provides PREINIT AREAS - NO or YES to alert users whether any PREINIT areas exist.
Each area that has had a PREINIT data set initialized but not yet used in the OAM process is listed. Once an OAM begins, the targeted PREINIT data set information is removed from the CXX.
The PREINIT data set information is not listed in any specific order.
The DBUTLTY REPORT AREA=CXX,TYPE=P function:
  • Provides a simple way to list existing PREINIT specifications
  • Executes while the source area is online and available
DBUTLTY Parameters
Function:
Report
Parameters:
AREA=CXX - Request report of CXX information
TYPE=P - Print PREINIT information
Sample DBUTLTY CXX REPORT TYPE=P Execution JCL
Use the following as a guide to prepare your JCL. The JCL statements are for example only. The lowercase letters in a statement indicate a value that you must supply. Code all statements to your site and installation standards.
//PREINI14 JOB . . . //*-----------------------------------------------------------------** //JOBLIB . . . //*-----------------------------------------------------------------** //* ******************************************** //* PRINT THE PREINIT CXX REPORT //* ******************************************** //CXXTYPEP EXEC PGM=DBUTLTY //SYSIN DD * REPORT AREA=CXX,TYPE=P /*
Sample DBUTLTY CXX REPORT TYPE=P Output
Following is a sample report of the DBUTLTY CXX REPORT TYPE=P.
Date: 6/04/2014 ******************************************************************************** Page: 1 * CA Datacom/DB * Time: 23.00.31 * General Utility * Version: 14.0 * COPYRIGHT (C) 1990-2011 CA. ALL RIGHTS RESERVED. * ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 REPORT AREA=CXX,TYPE=P FUNCTION=REPORT AREA=CXX TYPE=P Date: 6/04/2014 ******************************************************************************** Page: 2 * CA Datacom/DB * Time: 23.00.31 * General Utility * Version: 14.0 * COPYRIGHT (C) 1990-2011 CA. ALL RIGHTS RESERVED. * ******************************************************************************** Directory: QAMUF4 DBID AREA TYPE BLKSIZE OLDEP DATETIME TRACKS DSN 1 DEM DATA 1,096 N/A 20140604230031 1 DCMQA.QAMUF4.DEM001.ASOF0604 1 PAY DATA 1,096 N/A 20140604190933 1 DCMQA.QAMUF4.PAY001.ASOF0606 15 MSG DATA 4,096 N/A 20140604190302 1 DCMQA.QAMUF4.MSG015.ASOF0604 1 PER DATA 4,096 N/A 20140604190159 1 DCMQA.QAMUF4.PER001.ASOF0604
CXX TYPE=P Report Process Flow
The following graphic shows the CXX TYPE=P report process flow.
DBUTLTY PREINIT list
Additional Considerations
Usually, the PREINIT definitions are listed in chronological order (newest - oldest). However, if a PREINIT is executed for an area that already has a PREINIT definition, the system updates the new PREINIT information in place using the existing entries “spot” in the list.
Limit the list of PREINIT definitions to a minimum to keep the information fresh and correct.
The PREINIT data sets are not referenced/opened in order to print the PREINIT report.
Delete CXX PREINIT Section Contents
Use the DPREINIT option of the DBUTLTY CXXMAINT function to delete PREINIT information that is stored in the CXX for a specific area. Normally this is done when a PREINIT process has been executed for the area, but for some reason it is determined that the PREINIT definition will not be used for an OAM.
Execute a CXXMAINT OPTION=DPREINIT for area PREINIT information that is not going to be used and needs to be removed from the CXX.
The DBUTLTY CXXMAINT OPTION=DPREINIT function:
  • Provides a simple way to delete PREINIT information from the CXX for a selected area.
  • Executes while the source area is online and available.
  • Generates a “Request complete” message to indicate that the information has been deleted.
After executing the DPREINIT, you can execute a DBUTLTY REPORT AREA=CXX,TYPE=P function to verify deletion from the CXX.
DBUTLTY Parameters
Function:
CXXMAINT
Parameters:
OPTION=DPREINIT - Request delete of PREINIT CXX information
DBID=
nnnnn
- DBID of Source Area (numeric 1- 5000)
AREA=IXX/I
nn
/
aaa
- Area name of source area (three characters)
Sample DBUTLTY CXXMAINT OPTION=DPREINIT execution JCL
Use the following as a guide to prepare your JCL. The JCL statements are for example only. The lowercase letters in a statement indicate a value that you must supply. Code all statements to your site and installation standards.
//PREINI14 JOB . . . //*-----------------------------------------------------------------** //JOBLIB . . . //*-----------------------------------------------------------------** //* ******************************************** //* DELETE THE CXX PREINIT INFORMATION //* ******************************************** //CXXMAINT EXEC PGM=DBUTLTY //CXX DD DISP=SHR,DSN=DCMQA.QAMUF4.CXX //SYSPRINT DD SYSOUT=* //SYSIN DD * CXXMAINT OPTION=DPREINIT,DBID=001,AREA=DEM /*
Sample DBUTLTY CXXMAINT OPTION=DPREINIT Output
Following is a sample report of the DBUTLTY CXXMAINT OPTION=DPREINIT output.
Date: 6/04/2014 ******************************************************************************** Page: 2 * CA Datacom/DB * Time: 19.35.04 * General Utility * Version: 14.0 * COPYRIGHT (C) 1990-2011 CA. ALL RIGHTS RESERVED. * ******************************************************************************** Directory: QAMUF4 * REQUEST COMPLETE
CXXMAINT OPTION=DPREINIT Process FLow
The following graphic shows the DBUTLTY CXXMAINT OPTION=DPREINIT function.
CXXMAINT OPTION_DPREINIT pf
Additional Considerations
When the DBUTLTY utility deletes the PREINIT information in the CXX, the utility does not delete or remove the physical data set that the PREINIT function initialized. To delete the unused data set, use standard z/OS functionality.
Perform an Online Area Move for Index and Data
For more information and the steps to complete the OAM process successfully, see How to Perform an Online Area Move for Index and Data Areas.