Enlarging a fully extended Db2-managed data set

If a Db2-managed data set reaches the maximum number of VSAM extents, you can enlarge the data set.

Procedure

To enlarge a Db2-managed data set:

  1. Use the SQL statement ALTER TABLESPACE or ALTER INDEX with a USING clause.
    (You do not need to stop the table space before you use ALTER TABLESPACE.) You can give new values of PRIQTY and SECQTY in either the same or a new Db2 storage group.
  2. Use one of the following procedures.
    No movement of data occurs until this step is completed.
    • For indexes: If you have taken full image copies of the index, run the RECOVER INDEX utility. Otherwise, run the REBUILD INDEX utility.
    • For table spaces other than LOB table spaces: Run one of the following utilities on the table space: REORG, RECOVER, or LOAD REPLACE.
    • For LOB table spaces that are defined with LOG YES: Run the RECOVER utility on the table space.
    • For LOB table spaces that are defined with LOG NO:
      1. Start the table space in read-only (RO) mode to ensure that no updates are made during this process.
      2. Make an image copy of the table space.
      3. Run the RECOVER utility on the table space.
      4. Start the table space in read-write (RW) mode.