Transaction Manager Database Name (tm_database)

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
• Satellite database server with local clients

Parameter Type

Configurable

Default [Range]

1ST_CONN [any valid database name]

This parameter identifies the name of the Transaction Manager (TM) database for each DB2 instance. A TM database can be:

• A local DB2 Universal Database database
• A remote DB2 Universal Database database that does not reside on a host or AS/400 system
• A DB2 for OS/390 Version 5 database if accessed via TCP/IP and the Sync Point Manager 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 may set this parameter to 1ST_CONN which will set the TM database to be the first database to which a user connects.

For more information about distributed unit of work, refer to the Administration Guide.

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