Activating database changes by using the online change function
In IMS systems that use DBD, PSB and ACB libraries, you can use the online change function to apply database changes, including changes to full-function databases, full-function HALDB master databases, and Fast Path DEDB databases, to online IMS systems without stopping them.
In IMS systems that manage ACBs, database changes are made in the online IMS system by submitting the changes to the IMS catalog. Changes are submitted to the IMS catalog by using SQL DDL statements or by one of the population utilities for the IMS catalog. Some changes that are submitted by DDL are activated in the online system automatically. All other changes are activated by issuing the IMPORT DEFN SOURCE(CATALOG) command.
MSDBs do not support the online change function.
The online change
function for DEDBs allows both database-level and area-level changes.
A database-level change affects the structure of the DEDB and includes
such changes as adding or deleting an area, adding a segment type,
or changing the randomizing routines. An area-level change involves
increasing or decreasing the size of an area (IOVF, DOVF, CI). An
area-level change requires the user to stop only that area with the /DBRECOVERY
command;
a database-level change requires the user to stop all areas of the
DEDB.
Unlike standard randomizers that distribute database records across the entire DEDB, two-stage randomizers distribute database records within an area. By using a two-stage randomizer, changes to an individual area's root addressable allocation are area-level changes, and only the areas that are affected need to be stopped.
To use online change with full-function databases, HALDB master databases, and DEDB databases, perform the following steps:
Procedure
If a database in a z/OS environment
needs to be reorganized because of changes to the active ACBLIB data
set, /DBR
must be issued to deallocate the database before
the /MODIFY COMMIT
command that introduces the ACBGEN changes.
The commands /DBR
, /DBD
, or /STA
DATABASE ACCESS=
must be completed to take the areas of the
database to be changed or deleted offline before issuing the /MODIFY
COMMIT
command.