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 has loaded.

Table 1. Database properties
Property	Values (default)	Description
dbUrl	jdbc:db2://localhost:50000/FTMDB	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.myorg.com[:port]//MYFTMDB where: dbserver.myorg.com is the DNS name of the server where the database exists. Dotted IP notation may 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. Note: On some systems, problems can occur when referencing a local database 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. When resolving connectivity issues, always try to have the latest DB2® fix pack for the database release being used.
dbSchema	FTMDB	Name of the schema under which the FTM database was installed.
dbConnectId		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		Password for the user ID.
dbConnectionExtendedProperties		The name, including the path, of an extended DB2 connection properties file. It is primarily used to configure the DB2 pureScale feature, but may contain other DB2 properties. Validation is not performed on this properties file, so ensure that this file is limited to only the properties that you intend to configure and that they are specified using the correct case. The properties defined in this file override any existing DB2 properties that are defined in the Business Rules Server properties files. A sample extended properties file is located at `install_directory`/shared/v305/pfs/BusinessRules/server/profiles/sampleDbConnectionExtended.properties. For more information about encrypting properties files, see Encrypting configuration files in Payment Feature Services.
dbConnectionIdleTimeout	5000-7200000 (300000)	The timeout, in milliseconds, that the Transaction Server connection monitor waits between connection invocation usage before reporting 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 reporting 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 issued on the connection and any artifacts belonging 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 should 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 log messages issued 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 will output additional logs 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 containing the key store.
dbKeyStoreFormat	JKS KDS PK12 PKCS12 (JKS)	The key store type of the key store file.
dbKeyStorePassword	N/A	The password used to access the key store.
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.
dbTrustStore	N/A	The location of the file containing the trust store.
dbTrustStoreFormat	JKS KDS PK12 PKCS12 (JKS)	The trust store type of the trust store file.
dbTrustStorePassword	N/A	The password used to access the trust store.