Tablespace types

In the client-specific Database_settings.properties configuration file, you specify which tablespaces are to save which PPM data.

PPM differentiates between the following types of tablespaces:

Tablespace name

Description

STDBLOB

All database tables with binary data are saved in this tablespace, e.g., the table of calculated process instances.

STDTABLE

Standard tablespace.

In this tablespace, all data is saved that uses default data types of the database system.

STDINDEX

In MS SQL Server and Oracle systems, this tablespace is used for storing primary keys and index information.

Tablespace memory requirements strongly depend on the configuration and imported data of the PPM client.

If you do not change the default configuration after creating a client, all data of the PPM client is saved in the default tablespace. The default tablespace is specified upon creation of the database user. This configuration is highly unsuitable for a productive system.