The defaults in this file configure database-dependent basic mechanisms of the PPM system and describe the interface between PPM server and database server.
General part
Key |
Description |
---|---|
DATABASE_TYPE |
Specifies the type of the RDBMS to be used. Valid values are ORACLE 11, ORACLE_12, DB2_10, SQLSERVER_2016, and SQLSERVER_2016_UNICODE, SQLSERVER_2017, and SQLSERVER_2017_UNICODE. |
URL |
URL of the PPM databases in JDBC notation. Depends on the database system and DATABASE_TYPE used. |
USER |
Database user of the PPM databases |
PASSWD |
Password for the PPM databases. If the password is specified or changed in the CTK client settings it is automatically encrypted. Manual setting of an unencrypted password directly in the database settings, for example for testing purposes, is also supported. |
TRUNCATE_DIMENSION_STRINGS/ TRUNCATE_DIMENSION_MARK |
Behavior with text-based dimension values that exceed the configured maximum length of the dimension. Valid values are TRUE, FALSE (default), or MARK. FALSE: Values and descriptions are truncated to the configured maximum length of the dimension. The measure calculator outputs an error message. TRUE: as FALSE. However, there will be no error message. MARK: Values and descriptions of dimensions exceeding the maximum length are replaced by the text in TRUNCATE_DIMENSION_MARK. The measure calculator outputs a warning. |
For some special cases that might occur during data import, you need to specify default valuesPPM when initializing the system.
Warning
Please note that these values must not be changed in a system that has already been initialized.
Key |
Meaning |
---|---|
PPM_NULL |
Value used for dimensions that have not been specified or maintained. (UTF-encoded string. The value must be changed before the database is initialized). |
ERROR_NODE.STR |
Name of the process type group in the process type which contains all incorrectly calculated/typified instances (UTF-encoded string. The value must be changed before the database is initialized). |
NOT_TYPIFIED.STR |
Name of the process type in the process type, which contains instances that cannot be typified. (UTF-encoded string. The value must be changed before the database is initialized.) |
WRONG_TYPIFIED.STR |
Name of the process type in the process type, which contains instances that were incorrectly typified. (UTF-encoded string. The value must be changed before the database is initialized.) |
Tablespaces/data files used
For performance reasons, it is recommended that you save different data types separately in the database system. The definition depends on the RDBMS used and the installation of the database system. Please refer to the PPM Database systems manual for a more detailed description.
Key |
Meaning |
---|---|
<DATABASE_TYPE>_TBLCONF_STDTABLE/ <DATABASE_TYPE>_TBLCONF_STDINDEX/ <DATABASE_TYPE>_TBLCONF_STDBLOB |
These parameters determine in which tablespaces or data files certain types of data are saved. |
Internal part
The other parameters in the database settings configure the basic mechanisms of the database and PPM. They allow specific adjustments and fine-tuning in special constellations (for example, in case of different RDBMS behavior within a main version or for special import scenarios). The default settings usually cover all usage scenarios optimally and should therefore be changed only if absolutely necessary.
Warning
Changes to internal settings can affect the entire database negatively and might permanently damage correctness, performance, and consistency of the PPM system. Please change them only if you are explicitly requested to do so by PPM product support.