 |
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. |