Replication Agent requires the DB2 UDB connectivity autocommit parameter to be on.
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.
- Make a copy of the sample db2cli.ini file located in
<HOME>\db2_software\cfg,
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). Place this copy in
<HOME>\sqllib\cfg.
- In the db2cli.ini file in
<HOME>\sqllib\cfg, set
autocommit=1.