HADR and LOB replication

Technote (FAQ)


Question

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.

Answer

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

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows
High Availability - High Availability Data Replication (HDR)

Software version:

8

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Software edition:

DB2 UDB Express, Enterprise, Personal, Workgroup

Reference #:

1205366

Modified date:

2005-05-02

Translate my page

Machine Translation

Content navigation