Adding a DEDB area online with the DEDB Alter utility

You can add one or more DEDB areas at the end of a DEDB database while the DEDB area remains accessible online. With the ADDAREA function of the DEDB Alter utility (DBFUDA00), you can also replace the DEDB randomizer for the DEDB database to be altered and add a Segment Edit/Compression exit routine for a segment.

You can also use the ADDAREA function to add new fields to existing free space that is in a segment of an existing active DEDB area.

A maximum of 100 areas can be added to the end of a DEDB database per DEDB Alter utility execution.

The DEDB Alter utility's ADDAREA function supports DEDB databases with and without SDEP segments defined.

Procedure

  1. If you are replacing the randomizer or adding a Segment Edit/Compression exit routine, assemble and link edit the randomizer and the Segment Edit/Compression exit routine into the IMS SDFSRESL or one of the libraries of the IMS SDFSRESL STEPLIB concatenation.

    If you are using the DEDB Alter utility to add a Segment Edit/Compression exit routine, the Segment Edit/Compression exit routine must be able to handle mixed compressed and non-compressed data in a DEDB database. If data is non-compressed, on read access, it does not expand the non-compressed data, and on write access, it compresses the data and writes out as compressed data. If data is compressed, on read access, it expands the compressed data, and on write access, it compresses the data and writes out as compressed data.

  2. Add one or more DEDB areas at the end of the online DEDB database that you are altering.
    • If you use the DBDGEN utility, add one or more AREA statements. Each AREA statement can have different SIZE, UOW, and ROOT parameters in the DEDB DBD definitions.
    • If you use DDL, use one or more CREATE TABLESPACE statements. Each CREATE TABLESPACE statement can have different SIZE PRIMARY, UOW, and ROOT parameters in the DEDB DBD definitions.
  3. If you are adding one or more fields to existing free space that is in a segment of an existing active DEDB area, use one of the following methods to add the fields:
    • If you use the DBDGEN utility, add one or more FIELD statements under the SEGM statement of the segment that you are altering.
    • If you use DDL, use the ALTER TABLE statement with the INTERNALNAME parameter.
  4. If you are replacing the randomizer, change the RMNAME parameter in the DEDB DBD definitions.
    • If you use the DBDGEN utility, change the RMNAME parameter on the DBD statement.
    • If you use DDL, change the RMNAME parameter on the ALTER DATABASE statement.
  5. If you are adding a Segment Edit/Compression exit routine, perform one of the following options:
    • If you use the DBDGEN utility, add the COMPRTN parameter on a SEGM statement.
    • If you use DDL, add the EDITPROC parameter on the CREATE TABLE statement.
  6. If you use the IMS generation utilities, run the DBDGEN utility with one or more DEDB AREA statements added at the end of the DEDB DBD definitions.
  7. If you use the IMS generation utilities, run the ACBGEN utility for all PSBs that reference the changed DEDB DBD definitions to the staging ACBLIB.
  8. If ACBMGMT=CATALOG is specified in the DFSDFxxx member of the IMS PROCLIB data set, populate the new DEDB DBD definitions to the IMS catalog by using one of the following methods:
    • By using the staging ACBLIB that you created in step 6 as input, run the IMS Catalog Populate utility (DFS3PU00) and use the MANAGEDACBS statement with the STAGE parameter.
    • Use DDL.
  9. Allocate one or more DEDB area data sets for each DEDB area to be added:
    • Allocate one new DEDB area data set if the DEDB area to be added is defined as a single area data set (SADS).
    • Allocate one to seven new DEDB area data sets if the DEDB area to be added is defined as multiple area data sets (MADS).

    The VSAM control interval size must match the SIZE= parameter on the AREA statement or the SIZE PRIMARY parameter on the CREATE TABLESPACE statement for the DEDB area to be added in the new DEDB DBD definitions.

  10. Register each shadow area for each DEDB area to be added to DBRC by using the DBRC INIT.DBDS command with the SHADOW option.
    INIT.DBDS AREA(name) DBD(name) SHADOW
  11. Register one or more DEDB area data sets for each DEDB area to be added to DBRC by using the DBRC INIT.ADS command.
    The DEDB area data sets are unavailable until you run the DEDB Alter utility to add one or more DEDB areas at the end of a DEDB database online.
    INIT.ADS ADDN(name) ADSN(name) AREA(name) DBD(name)

    The ADDN(name) for the area data set's ddname and the ADSN(name) for the area data set's dsname must be unique for each area data set.

  12. Format one or more DEDB area data sets for each DEDB area to be added at the end of the DEDB database in the staging ACBLIB, by using the DEDB Initialization utility (DBFUMIN0) with the ACTIVE control statement.
    After the DEDB Initialization utility runs, these DEDB area data sets for the shadow area remain inaccessible to IMS online systems. The DEDB area data sets are marked as AVAIL in the RECON.
  13. Run the DEDB Alter utility by using the ADDAREA function to add one or more DEDB areas while the DEDB database remains accessible online.
    The DEDB Alter utility adds one or more DEDB areas at the end of a DEDB database online when the utility is run.

    If you are adding a Segment Edit/Compression exit routine, during DEDB Alter utility execution the new Segment Edit/Compression exit is not invoked for any areas. The Segment Edit/Compression exit routine is not enabled during DEDB Alter processing. Instead, it is enabled for all DEDB areas after successful DEDB Alter utility completion.

If the parameter on the ADDAREA control statement is invalid, or if one ore more of the DEDB areas to be added are not at the end of the DEDB database, the DEDB Alter utility terminates.

If the total number of DEDB areas after the ADDAREA function exceeds 2048 DEDB areas, the DEDB Alter utility terminates.

After the DEDB Alter utility completes successfully, the SHADOW status for the area is reset in the RECON. The area is now active and accessible to IMS online systems.

If you are replacing the randomizer, the new randomizer replaces the old randomizer for all DEDB areas of the DEDB database.

If you are adding a Segment Edit/Compression exit routine, the Segment Edit/Compression exit routine is invoked for all DEDB areas of the DEDB database.

If you are adding fields to existing free space that is in a segment of an existing active DEDB area, the fields are added while the DEDB database remains accessible online.