DB2 UDB Replicate Database Permissions and Limitations

Replication Server requires a maintenance user ID that you specify using the Replication Server create connection command to apply transactions in a replicate database.

The maintenance user ID must be defined at the DB2 UDB server and granted authority to apply transactions in the replicate database. The maintenance user ID must have permissions in the DB2 UDB replicate database:

CREATE TABLE authority to create tables used for Replication Server processing
UPDATE authority on all replicate tables

Replication of large object (LOB) datatypes (BLOB, CLOB, DBCLOB, LONG VARGRAPHIC, and LONG VARCHAR) is not supported directly from Replication Server to the ECDA Option for ODBC.