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 z/OS® 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.