DBMS connectivity properties

The Transaction Server uses a database management system (DBMS) for data management. The following table shows the properties that are used to configure connectivity to the DBMS.
Table 1. Database management system connectivity properties
Property Default value Range Description
dbName jdbc:db2://%DBHOST%:%DBPORT%/%DBNAME% N/A FTM database name. Use a database that is available on the Transaction Server, such as, MYFTMDB, or refer 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% N/A Name of the schema under which the FTM database was installed.
dbConnectId %DBUSER% N/A User ID that is 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 signed-on user ID and password are used.
dbConnectPwd %DBPASS% N/A Password for the dbConnectId user ID.
dbConnectionIdleTimeout 300000 5000-7200000 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 60000 1000-1800000 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 N/A 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).
verbose
Adds log-level tracing for all calls that are made on the connection and any artifacts that belong to the connection.
monitored
Same as verbose, 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.
debug
With debug mode enabled, logs are only written if database artifacts are not committed or released when a database connection is returned to the pool. This option is suitable for use in production to check for database resource leaks.
dbConnectionRefreshTimer 2 hours N/A When a database connection is idle for this amount of time, the Transaction Server tests to see whether it must be refreshed. Refreshing might be necessary if the connection is closed or if its remote connection was ended by a system timeout. In this situation, the connection is referred to as stale. Refreshing involves discarding the old database connection and replacing it with a new one. The connection is only refreshed if Transaction Server determines it is stale.
dbConnectionTracing false true/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 1000 10-120000 The length of time that the Transaction Server waits for a connection to the DBMS.
dbExceptionMonitoring false true/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 16 4-1024 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.
dbLoginTimeout 1000 10-120000 The length of time that the Transaction Server waits to log on to the DBMS.
enableSQLCheckData false true/false Enables detailed SQL tracing for Transaction Server.