TIBCO Service Performance Manager Configuration: Database Configuration

The following table lists the database configuration details that can be configured using the wizard.

Database Configuration Properties
Field Name Property in spm-config. properties Mandatory Default Value Description
Database Driver rta.jdbc.driver Yes org.postgresql.Driver Name of the JDBC Driver.

Supported values are oracle.jdbc.driver.OracleDriver, com.microsoft.sqlserver.jdbc, SQLServerDriver, and com.ibm.db2.jcc.DB2Driver.

Database URL rta.jdbc.url Yes jdbc:postgresql:// localhost:5432/<database> Location of the database server.

See the documentation specific to your JDBC driver for more information.

Username rta.jdbc.user Yes spm_user Username that the Service Performance Manager server uses to access the database.

This user must have read and write permissions to the database.

Password rta.jdbc.password Yes   Password that the server uses, in conjunction with the username provided in dbstore_driver_username, to access the database.
Select Advanced Options to configure advanced database options.
Note: If you do not select Advanced Options, the advanced properties take default values. However, if you use Advanced Options, the properties take the last configured values.
Database Configuration Advanced Properties
Field Name Property in spm-config.properties Mandat

ory

Default Value Description
Initial Connections rta.jdbc.initial.connection.size No 10 Number of connections allowed at initialization.
Max Connections rta.jdbc.max.connection.size No 100 Maximum number of simultaneous client connections to the database.
Transaction Batch Size rta.jdbc.batch.size No 1000 Database batch size.
JDBC Key rta.jdbc.key No "" Database connection pool internal identifier.

To test the validity of the database connection:

  1. For the database that you choose, make the jar files of the drivers available and specify the complete path of the jar file in the JDBC Driver Path field.
  2. Click Test Connection.