Online Area Move

The Online Area Move functionality provides support for 24x7 businesses. With Online Area Move, you can move index and data areas from one physical data set to another by using the Multi-User Facility (MUF) without interrupting user access to the data rows and indexes that are stored in those areas.
datacom150
The Online Area Move functionality provides support for 24x7 businesses. With Online Area Move, you can move index and data areas from one physical data set to another by using the Multi-User Facility (MUF) without interrupting user access to the data rows and indexes that are stored in those areas.
For information about how a database administrator (DBA) or a system programmer uses Online Area Move, while the tables are open for user processing, to move index and data areas (data sets) from one physical 3390 data set to another 3390 data set , see the Online Area Move scenarios.
Contents
How to Use the Online Area Move
When you are ready to do an Online Area Move, issue a command to the MUF In one of the following ways:
  • Console Command for Online Area Move
  • DBUTLTY COMM CONSOLE Function
  • SQL INSERT Statement
There is also a DPREINIT option to the DBUTLTY CXXMAINT function and a PREINIT List Report that you can generate using REPORT AREA=CXX,TYPE=P.
Console Command for Online Area Move
Syntax
►─ ONLINE_AREA_MOVE 
dbid,area-name
 ──┬───────────┬──────────►◄                                      └─ ,DELETE ─┘
Parameters:
  • ONLINE_AREA_MOVE
    Requests an Online Area Move.
  • dbid
    Specifies the 4-character database ID (
    dbid
    ) of the area to move (valid values for
    dbid
    : 1- 5000).
  • ,
    area-name
    The
    area-name
    of the area to move (3 characters, either IXX or a valid 3-character area name).
  • ,DELETE
    (
    optional
    ) Tells the Online Area Move the original source data set’s disposition.
Examples
 
/F MYMUF14, ONLINE_AREA_MOVE dbid,area-name /F MYMUF14, ONLINE_AREA_MOVE dbid,area-name,DELETE  
DBUTLTY COMM CONSOLE Function for Online Area Move
Syntax
► COMM OPTION=CONSOLE,OPTION2=’ONLINE_AREA_MOVE 
dbid,area-name
 ┬─────────┬’─►◄                                                                └ ,DELETE ┘
Parameters:
  • COMM OPTION=CONSOLE
    The DBUTLTY function.
  • OPTION2=’ONLINE_AREA_MOVE
    Requests an Online Area Move.
  • dbid
    Specifies the 4-character database ID (
    dbid
    ) of the area to move (valid values for
    dbid:
    1- 5000).
  • ,
    area-name
    The
    area-name
    of the area to move (3 characters, either IXX or a valid 3-character area name).
    If DELETE is used, the single quote mark (‘) comes after DELETE, instead of after the area-name.
  • ,DELETE’
    (optional) Tells the Online Area Move the original source data set’s disposition.
Examples
COMM OPTION=CONSOLE,OPTION2=’ONLINE_AREA_MOVE dbid,area-name’
COMM OPTION=CONSOLE,OPTION2=’ONLINE_AREA_MOVE dbid,area-name,DELETE’
SQL INSERT Statement for Online Area Move
Syntax
►─ INSERT INTO SYSADM.SQL_CONSOLE (MUF_NAME, CONSOLE_COMMAND) ────────────► ►─ VALUES (‘
muf-name
’, ‘ONLINE_AREA_MOVE 
dbid,area-name
 ─┬───────────┬ ’ ─►◄                                                          └─ ,DELETE ─┘
Parameters:
  • INSERT INTO SYSADM.SQL_CONSOLE (MUF_NAME, CONSOLE_COMMAND)
    The SQL statement to insert a new row.
  • VALUES
    Specify the values to use for the statement with the following parameters.
  • 'muf-name
    The name of the Multi-User Facility being used.
  • dbid
    Specifies the 4-character database ID (
    dbid
    ) of the area to move (valid values for
    dbid
    : 1- 5000).
  • area-name
    The
    area-name
    of the source area (3 characters, either IXX or a valid 3-character area name).
  • ,DELETE’
    (optional) Tells the Online Area Move the original source data set’s disposition.
Examples
  INSERT INTO SYSADM.SQL_CONSOLE (MUF_NAME, CONSOLE_COMMAND)         VALUES (‘
muf-name
’, ‘ONLINE_AREA_MOVE 
dbid,area-name
’ INSERT INTO SYSADM.SQL_CONSOLE (MUF_NAME, CONSOLE_COMMAND)         VALUES (‘
muf-name
’, ‘ONLINE_AREA_MOVE 
dbid,area-name
,DELETE’
DBUTLTY CXXMAINT OPTION=DPREINIT Function
Syntax
►─ CXXMAINT OPTION=DPREINIT,DBID=
dbid
,AREA=
area-name
──────────────►◄
Parameters:
  • CXXMAINT
    The DBUTLTY function.
  • OPTION=DPREINIT
    Requests a delete of the specified PREINIT item on the PREINIT list.
  • DBID=
    dbid
    The
    dbid
    specifies the database ID of the Source Area (valid values for
    dbid
    : 1- 5000).
  • AREA=
    area-name
    The
    area-name
    of the source area (3 characters, either IXX or a valid 3-character area name).
Sample DBUTLTY CXXMAINT OPTION=DPPREINIT execution JCL
  //PREINI14 JOB . . .  //*-----------------------------------------------------------------**   //JOBLIB  . . .  //*-----------------------------------------------------------------**    //* ********************************************    //* DELETE THE CXX PREINIT INFORMATION FROM THE PREINIT LIST //* ********************************************    //CXXMAINT EXEC PGM=DBUTLTY                         //CXX      DD DISP=SHR,DSN=DCMQA.QAMUF4.CXX         //SYSPRINT DD SYSOUT=*                              //SYSIN    DD  *                                       CXXMAINT OPTION=DPREINIT,DBID=001,AREA=DEM         /*