This chapter describes the administrative differences between the various database systems supported by PPM.
PPM supports the following database systems:
All versions in UNICODE as well, if data is to be saved in a multi-byte character set, such as Japanese.
When creating a client, specify the database system to be used. The database system-specific settings are specified in the subsequent configuration dialogs: Host name, port number of the database service, name of the database, and for the PPM client the name of the database user to be used, and the database user password.
The database systems supported by PPM use the term "database" with different semantics:
Oracle
Oracle links runtime processes and the database in one database instance. In their daily language use, they mostly use the term "database".
IBM DB2 and Microsoft SQL Server
With these database systems, the runtime processes of the database instance can manage any number of databases. At least the system database must exist. Microsoft calls the system database of its SQL Server products master database.
For IBM DB and Microsoft SQL Server database systems, we recommend that you supply each PPM client with its own database. This applies particularly to the database users required in a scaled PPM system.