Index Tablespace Name Attribute of the Class Properties

About Index Tablespace Name Attribute of the Class Properties

This section provides information about the Index Tablespace Name attribute of the Class
Properties class. The topics covered are:

System Managed Tablespace

If the primary tablespace is SMS, by default indexes are created in the same tablespace where the class is present.

Database Managed Tablespace

If the primary tablespace type is DMS, a different tablespace can be specified for the
indexes. To determine the Index Tablespace Name, the Index Tablespace Name attribute of the Class Properties class is used with these rules:
  • The property with the lowest Display Order is used.
  • If more than one property is defined with the lowest Display Order, then the
    property with the lowest Class Property Label sort order is used.

The default tablespace CISINDEX_SPACE will be used if any of the following
conditions are true:

  • An invalid tablespace is specified.
  • The tablespace specified is one of the DB2 system Tablespace: SYSCATSPACE,
    TEMPSPACE1 or USERSPACE1.
  • A temporary tablespace is specified.

Note: You can specify an index for any tablespace, irrespective of the table location.