Altering IMS table spaces

To make changes to a table space, you can issue an ALTER TABLESPACE statement.

The supported changes include, but are not limited to, changing the output ddname, size changes, blocking factor values. Depending on the database access types, some attributes do not apply so changes for them are not allowed. For a list of supported keyword attributes based on database access type, see the ALTER TABLESPACE syntax diagrams.

The ALTER TABLESPACE statement cannot be specified for HALDB databases at this time. You may specify the DSGROUP keyword on a CREATE TABLE or ALTER TABLE statement to identify which table space or data set group a table belongs to.

Alternately, you can drop an existing table space and re-create it. To do so, follow these steps.

Procedure

  1. Issue an ALTER DATABASE statement to identify the database in which you plan to modify.
  2. Issue a DROP TABLESPACE statement for the table space you plan to change.
  3. Issue a CREATE TABLESPACE statement to recreate the table space with the desired attributes.
  4. Issue a COMMIT DDL statement.