In the client-specific Database_settings.properties configuration file, you specify which tablespaces are to save which PPM data.
The Database_settings.properties configuration file is stored in the following client-specific directory.
<PPM installation>\server\bin\work\data_ppm\config\<client>\
PPM differentiates between the following types of tablespaces:
Tablespace name |
Description |
---|---|
STDBLOB |
All database tables with binary data are saved in this tablespace, for example, 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.