Changing Default Index Tablespace for Class

About Changing Default Index Tablespace for Class

When creating a class from a client application, you have the option to put the class indexes in a user specified tablespace. This section describes how the index tablespace is selected for a class.

Database Managed Tablespace

If the primary tablespace specified in the attribute Data Tablespace Name in Classes class is DMS type, the default Class Index Tablespace is CISINDEX_SPACE. However, a different index tablespace can be specified in attribute Index Tablespace Name in Classes class.

The tablespace specified must satisfy these conditions:

  • The tablespace must exist.

  • The tablespace must be a REGULAR DMS tablespace.

  • The DB2 system tablespaces SYSCATSPACE and USERSPACE1 cannot be specified.

System Managed Tablespace

If the primary tablespace specified in the attribute Data Tablespace Name is SMS type, the class indexes are created in the same tablespace as the Data Tablespace Name. The value specified in attribute Index Tablespace Name in Classes class is ignored.

Note: Index Tablespace Name attribute in Class Properties class and Pointer Class Properties class is ignored because of DB2 limitation.