DB2 10.5 for Linux, UNIX, and Windows

tm_database - Transaction manager database name configuration parameter

This parameter identifies the name of the transaction manager (TM) database for each DB2® instance.

Configuration type

Database manager

Applies to

Database server with local and remote clients
Client
Database server with local clients
Partitioned database server with local and remote clients

Parameter type

Configurable

Default [range]

1ST_CONN [any valid database name]

A TM database can be:

A local DB2 database
A remote DB2 database that does not reside on a host or Power® System Server
A DB2 for OS/390® Version 5 database if accessed via TCP/IP and the sync point manager (SPM) is not used.

The TM database is a database that is used as a logger and coordinator, and is used to perform recovery for indoubt transactions.

You can set this parameter to 1ST_CONN, which will set the TM database to be the first database to which a user connects.

Recommendation: For simplified administration and operation, you might want to create a few databases over a number of instances and use these databases exclusively as TM databases.