Enabling Replication for a LOB Column in the Primary Database

For transactions that affect a LOB column to be replicated, the table that contains the LOB column must be marked for replication and have replication enabled.

Prerequisites

If pdb_dflt_column_repl is true (the default), all LOB columns in a table have replication enabled automatically when you mark the table (by invoking pdb_setreptable). If pdb_dflt_column_repl is false, you must enable replication separately for each LOB column before replication can take place.

Task

Log in to the Replication Agent instance with the administrator login.
Determine if replication is enabled for the LOB column:
```
pdb_setrepcol pdb_table, pdb_col
```
where:
- where pdb_table is the marked table that contains the LOB column.
- where pdb_col is the LOB column in the primary database.
  
  Note: For Replication Agent for UDB, if pdb_setrepcol is invoked with a table containing a “DATE” column, the primary key in the primary table cannot include the “DATE” column.
If pdb_setrepcol returns information that the LOB column has replication enabled, you need not continue this procedure.

If pdb_setrepcol returns information that the LOB column does not have replication enabled, continue this procedure to enable replication for the column.
Enable replication for the LOB column:

pdb_setrepcol pdb_table, pdb_col, enable

After replication is enabled for the LOB column, you can begin replicating transactions that affect data in that column.