TIBCO Service Performance Manager Configuration: Database Configuration
The following table lists the database configuration details that can be configured using the wizard.
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.
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:
Copyright © 2022. Cloud Software Group, Inc. All Rights Reserved.