Groups > DB2 > DB2 UDB > Replicating LOBs




Replicating LOBs

Replicating LOBs
Fri, 17 Aug 2007 16:01:29 EDT
Hi.  

I'm trying to replicate some tables that contain LOBs (three have BLOBs and one
has a CLOB) between two DB2 servers.  Both servers are running AIX 5.3, but one
has DB2 v8.1 FP12 and the other has DB2 v8.1 FP11.  One of the LOB-holding
tables replicates just fine (a BLOB), but the other three fail with the
following errors being posted in the replication load log.

SQL3168W  The PC/IXF column specified to be loaded into database column
"3" is
not compatible with the database column.  Nulls will be inserted.

SQL3088N  The source column specified to be loaded into database column
"4" is
not compatible with the database column, but the database column is not
nullable.

SQL3088N  The source column specified to be loaded into database column
"4" is
not compatible with the database column, but the database column is not
nullable.

I have specified that the LOB(s) must be replicated (in DB2RC) and mapped it to
the appropriate target attribute(s).  I am puzzled that one works, where the
other three fail.  

Post Reply
about | contact