Database

The following table shows the properties for the database component:

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: On some operating 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. 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	N/A	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	N/A	Password for the dbConnectId 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.
dbConnectionWaitTime	10-120000 (1000)	The length of time that the Business Rules Manager waits for a connection to the DBMS.
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 Manager waits to log on to the DBMS.
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.
partnerDbSchema	(FTM)	This property defines the database schema for the Partner Profiles tables within the database. The paydirdb and buildtables commands use it to extract data for bank control and endpoint files.