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.
- 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.
- Edit the autocommit parameter setting in the
db2cli.ini file in
<HOME>\sqllib\cfg.