Setting the DB2 UDB Connectivity Autocommit Parameter

Replication Agent requires that the DB2 UDB connectivity autocommit parameter be turned on (autocommit=1).

The autocommit parameter is specified in the DB2 UDB call-level interface (CLI) configuration file for the primary database. If the autocommit parameter is not turned on, a deadlock problem may occur.

To set the autocommit parameter, edit the db2cli.ini file. It is located in <HOME>\sqllib, where <HOME> is the home directory of the DB2 UDB instance owner (UNIX or Linux) or the DB2 UDB client or server installation directory (Windows).