ConnectType CLI/ODBC and IBM data server driverconfiguration keyword
Controls whether the application is to operate in a remote or distributed unit of work.
- db2cli.ini keyword syntax:
- ConnectType = 1 | 2
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="ConnectType" value="1 | 2"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- Remote unit of work.
- Equivalent environment or connection attribute:
- SQL_ATTR_CONNECTTYPE
- Usage notes:
- This option allows you to specify the default connect type. The options are:
- 1 = Remote unit of work. Multiple concurrent connections, each with its own commit scope. The concurrent transactions are not coordinated. This is the default.
- 2= Distributed unit of work. Coordinated connections where multiple databases participate under the same distributed unit of work.
The first connection determines the connect type for all other connections that are allocated under the same environment handle.
This keyword takes precedence over the environment or connection attribute.