Controls whether the application is to operate in a remote
or distributed unit of work.
- db2cli.ini keyword syntax:
- ConnectType = 1 | 2
- 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.
DB2 Version 9.7 for Linux, UNIX, and Windows