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.