Database

The following table shows the properties for the database. The server uses the database to keep statistics on the time it takes to run workflows and nodes. It also updates tables so the administrator console can display which workflows, nodes, tasks, and tables the Business Rules Server loaded.
Table 1. Database properties
Property Values (default) Description
dbUrl jdbc:db2://%DBHOST%:%DBPORT%/%DBNAME% FTM database name. Refer to a local database by name, such as MYFTMDB, or to a database on another server by using the full URL. A full URL is specified as jdbc:db2://dbserver.example.com[:port]//MYFTMDB where:
dbserver.example.com
Is the DNS name of the server where the database exists. Dotted IP notation can also be used.
port
Is an optional port number for the database configuration on that server. It normally defaults to 50,000.
MYFTMDB
Is the database name.
Notes:
  1. On some systems, problems can occur when a local database is referenced by only the name. If problems occur, specify the database server as a full URL. Use localhost, 127.0.0.1, or the actual URL or DNS name in the specification.
  2. When you are trying to resolve connectivity issues, always try to have the newest Db2® fix pack for the database release that is being used.
dbSchema %DBSCHEMA% Name of the schema under which the FTM database was installed.
dbConnectId %DBUSER% User ID used for all database connectivity. This user ID requires connect access to the database and insert, delete, update, and select access to all FTM database tables. If not specified, the current user ID and password are used.
dbConnectPwd %DBPASS% Password for the user ID.
dbConnectionIdleTimeout 5000-7200000 (300000) The timeout, in milliseconds, that the Transaction Server connection monitor waits between connection invocation usage before it is reported as an abandoned connection. This value is ignored if dbConnectionMode is set to standard.
dbConnectionInUseTimeout 1000-1800000 (60000) The timeout, in milliseconds, that the Transaction Server connection monitor waits during a connection invocation before it is reported as a deadlock connection. This value is ignored if dbConnectionMode is set to standard.
dbConnectionMode standard, debug, monitored (standard) Configures the Transaction Server to use a specific type of database connection. The following database connection types are available:
standard
Uses a standard JDBC connection (the default).
debug
Adds log-level tracing for all calls that are made on the connection and any artifacts that belong to the connection.
monitored
Same as debug, but with added capacity to detect and trace connections that are abandoned or in deadlock. Normally, this setting needs to be left as standard unless directed by IBM® Support. Using a level other than standard can degrade Transaction Server performance in a normal operating environment.
dbConnectionTracing true, false (false) Turns on verbose mode in the database connection debug mode. This option increases the number of messages that are logged during database debugging, showing all created statements and more. This option is ignored if dbConnectionMode is set to standard.
dbEnableSSL true, false (false) Use an SSL connection to the FTM database.
dbExceptionMonitoring true, false (false) Turns on database exception monitoring. When specified as true, debug connections output extra logs that are related to certain database exceptions to aid in debugging. This value is ignored if dbConnectionMode is set to standard.
dbExecutionStackSize 4-1024 (16) Specifies the number of SQL statement executions that are retained for exception monitoring. This option is useful when debugging database deadlock and read timeout exceptions. This value is ignored if dbConnectionMode is set to standard or dbExceptionMonitoring is set to false.
dbKeyStore N/A The location of the file that contains the keystore.
dbKeyStoreFormat
  • JKS
  • KDS
  • PK12
  • PKCS12
(JKS)		 The keystore type of the keystore file.
dbKeyStorePassword N/A The password used to access the keystore.
dbLogging true, false (true) Enables or disables database enterprise logging.
dbLoginTimeout 10 - 120000 (1000) The length of time that the Business Rules Server waits to connect to a database.
dbConnectionCount 10 - 200 (10) The number of database connections to allocate for Business Rules Server to use.

When the Gateway engine Number of Business Rules Server threads per batch property is changed, consider updating this property too. First, update the Gateway engine work manager Maximum Number Of Threads property and then update this property by using the following calculation:

Maximum Number Of Threads + (2 * Number of listeners for the Gateway engine)

If you change this property, restart Business Rules Server to use the new value.
dbTrustStore N/A The location of the file that contains the truststore.
dbTrustStoreFormat
  • JKS
  • KDS
  • PK12
  • PKCS12
(JKS)		 The truststore type of the truststore file.
dbTrustStorePassword N/A The password used to access the truststore.