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:
- 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.
- 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:
- Start the table space in read-only (RO) mode to ensure that no
updates are made during this process.
- Make an image copy of the table space.
- Run the RECOVER utility on the table space.
- Start the table space in read-write (RW) mode.