IBM Support

HADR and LOB replication

Technote (FAQ)


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.

Related information

High availability disaster recovery overview

Document information

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: