Previous Topic: How to Capture an Image-CopyNext Topic: Process Recommendations

Maintaining the Host Encyclopedia › How to Expand Tablespaces and Indexes

How to Expand Tablespaces and Indexes

You may need to expand a tablespace or index to accommodate a growing model. If you are receiving the following errors, the system is telling you to expand tablespaces and indexes:

DB2 error - 904, reason code X'00D70027

The job CEUXPND expands tablespaces and indexes. When you run CEUXPND, it does the following:

Follow these steps:

  1. Stops the tablespace/indexspace to be expanded.
  2. Deletes any existing temporary backup image-copy dataset.
  3. Creates a temporary DSN1COPY of table/indexspace.
  4. Deletes the VSAM cluster for the table/indexspace.
  5. Reallocates the table/indexspace.
  6. Restores table/indexspace from temporary DSN1COPy copy.
  7. Restarts the table/indexspace.

CEUXPND assumes that Storage Groups are not in use. If Storage groups are in use, use a DB2 ALTER command and a REORG to resize.