Setting the IBM DB2 Universal Database Connectivity Autocommit Parameter

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

The autocommit parameter is specified in the DB2 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 IBM DB2 Universal Database instance owner (UNIX or Linux) or the IBM DB2 Universal Database client or server installation directory (Windows).