Results 1 to 4 of 4
  1. #1
    Join Date
    May 2013
    Posts
    25

    Arrow Unanswered: DB2 HADR and LOB replication

    Hello,

    does anybody know / have personal experience with LOBs and DB2 HADR? I did a search but I find controversial information. Some people say that LOBs are replicated by default, some others that are replicated up to 1GB...

    Can anyone provide some accurate information?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if the lob modif is in the log - it is replicated
    there is a size limit for log entry (I believe 2G)
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    DB2 High Availability Disaster Recovery (HADR) non-replicated operations:

    All logged LOB columns are replicated. Non-logged LOB columns are not replicated. However, the space for them will be allocated on the standby database using binary zeroes as the value for the column.
    Regards,
    Mark.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    There was a 1 GB max on logged LOB columns, but that restriction was lifted in DB2 LUW 9.7 FP1 (not GA FP0 code).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •