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 - High Availability Data Replication (HDR)

Software version:


Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Software edition:

DB2 UDB Express, Enterprise, Personal, Workgroup

Reference #:


Modified date:


Translate my page

Content navigation