|
| 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
|
|
|
|
|
|
|
|
|
|