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, and the LOB column must have replication enabled.
If the value of the pdb_dflt_column_repl parameter is set to true, all LOB columns in a table have replication enabled automatically when you mark the table (by invoking the pdb_setreptable command). If the value of the pdb_dflt_column_repl parameter is set to false, you must enable replication separately for each LOB column before replication can take place.
The default value of the pdb_dflt_column_repl parameter
is false.
To enable replication for a LOB column in the
primary database
Log in to the Replication Agent administration port using the following command:
isql -Uusername -Ppassword -Sinst_name
where username is the Replication Agent administrative user login name, password is the corresponding password, and inst_name is the name of the Replication Agent instance you want to mark a primary table for.
Use the pdb_setrepcol command to determine if replication is already enabled for the LOB column you want to enable replication for in the primary database.
pdb_setrepcol tablename, pdb_col
where tablename is the name of the table that contains the LOB column and pdb_col is the name of the LOB column in the primary database.
If the pdb_setrepcol command returns information that replication is enabled for the specified column, you need not continue this procedure.
If the pdb_setrepcol command returns information that replication is not enabled for the specified column, continue this procedure to enable replication for the column.
Use the pdb_setrepcol command to enable replication for the LOB column.
pdb_setrepcol tablename, pdb_col, enable
where tablename is the name of the table that contains the LOB column and pdb_col is the name of the LOB column in the primary database for which you want to enable replication.
After replication is enabled for the LOB column, you can begin replicating transactions that affect data in that column.
