HADR and LOB replication
This document addresses the question of whether logged or non-logged large object (LOB) data get replicated in a high availability disaster recovery (HADR) environment.
All logged LOB columns in an HADR environment will be replicated to the standby server. Note that BLOBs and CLOBs larger than 1 GB cannot be logged, so they also cannot be replicated.
Non-logged LOB columns will not be replicated to the standby server. However, the space will be allocated for the LOB data on the standby server. The data for the LOB column will be binary zeroes.
More support for:
DB2 for Linux, UNIX and Windows
High Availability - HADR
Software version: 8
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Software edition: DB2 UDB Express, Enterprise, Personal, Workgroup
Reference #: 1205366
Modified date: 02 May 2005
Translate this page: