Table spaces

A table space is a set of volumes on disks that hold the data sets in which tables are stored. A table space can have one or more tables.

IBM® Security Directory Server uses four DB2® table spaces.

Table space 0: SYSCATSPACE

The SYSCATSPACE table space stores a description of the database and its structure and contents. The disk requirements for this table space do not change with the size of the directory server. The disk space requirements are covered by the default directory server disk requirements.

Table space 1: TEMPSPACE1

The TEMPSPACE1 table space holds temporary data for sorting and collating DB2 results. The disk requirements for this table space grow at run time if a complex search is run against the directory server. The disk space requirement for this table space grows with the usage utilities, such as the bulkload tool.

When the bulkload utility is run, the disk requirement for the table space is approximately 2 GB. The bulkload utility uses the maximum space when millions of entries are loaded into the directory server.

Table space 2: USERSPACE1

USERSPACE1 holds the portion of the database that contains the attribute tables and attribute table indexes of the directory server. These tables are used for optimizing searches on specific attributes.

Table space 3: LDAPSPACE

LDAPSPACE contains the portion of the database that contains the LDAP entry table and LDAP entry table indexes of the directory server. The LDAP entry table contains a few searchable attributes, such as distinguished name (DN), and a full, non-searchable definition of each LDAP entry.

The LDAP entry table returns the attributes for an LDAP search operation.

In IBM Security Directory Server, Version 6.4, the default tablespace for IBM Security Directory Server is automatic storage tablespace. From DB2, Version 10.1 Fix Pack 1 onwards the database managed spaces (DMS) table space type and system managed spaces (SMS) table space type is deprecated for permanent table spaces that are defined by the user.