What to send to the recovery site

You must send to the recovery site the same information as for single-system remote recovery: logs and BSDSs, image copies, and so on.

To prepare the logs for the remote site, you have three options:
  • Use the command ARCHIVE LOG with the MODE (QUIESCE) option to ensure a point of consistency for each of the log data sets. If the quiesce is not successful, the command fails and the logs are not archived.

    At the recovery site (just as for non-data-sharing disaster recovery), the ENDRBA value you use for restarting each member is the end RBA +1 of the latest archive log data set from each member in the data sharing group.

  • Use the command ARCHIVE LOG SCOPE(GROUP). This version of the command does not ensure a point of consistency for all members' logs, but the logs are archived on each of the active members of the data sharing group. You can use the ENDLRSN option of the DSNJU003 (change log inventory) utility on the remote site to truncate all logs to the same point in time.

    To determine the truncation value, look at the print log map output from the latest copies of the archived BSDS.

    Another way to determine the truncation value is to ship the SYSLOG containing message DSNJ003I with your archive log data sets to the recovery site. This message is issued when archive log data sets are created (when you issue the ARCHIVE LOG command). The message contains the starting and ending LRSN and RBA values for the archive log data set. For example, the following messages appear when the command ARCHIVE LOG SCOPE(GROUP) is issued from one of the members at the local site:
    DSNJ003I -DB1A DSNJOFF3 FULL ARCHIVE LOG VOLUME
    DSNAME=DSNC510.ARCHLOG1.A0000003, STARTRBA=000001C68000,
    ENDRBA=000001D4FFFF, STARTLRSN=ADFA208AA36C, ENDLRSN=AE3C45273A77,
    UNIT=SYSDA, COPY1VOL=SCR03, VOLSPAN=00, CATLG=YES                  
    DSNJ003I -DB2A DSNJOFF3 FULL ARCHIVE LOG VOLUME
    DSNAME=DSNC518.ARCHLOG1.A0000001, STARTRBA=000000000000,
    ENDRBA=0000000D6FFF, STARTLRSN=ADFA00BB70FB, ENDLRSN=AE3C45276DD7,
    UNIT=SYSDA, COPY1VOL=SCR03, VOLSPAN=00, CATLG=YES      
    Compare the ending LRSN values for all members' archive logs, and choose the lowest LRSN as the truncation point. For the two members shown previously, the lowest LRSN is AE3C45273A77. To get the last complete log record, you must subtract 1 from that value, so you would enter AE3C45273A76 as the ENDLRSN value in the CRESTART statement of the DSNJU003 utility for each of the members at the remote site. All log records with a higher LRSN value are discarded during the conditional restart.
  • Use the command SET LOG SUSPEND if you are using the IBM® RAMAC Virtual Array (RVA) storage control with the peer-to-peer remote copy (PPRC) function or Enterprise Storage Server® Flashcopy to create point-in-time backups of entire Db2 subsystems for faster recovery at a remote site. Using either of these methods to create a remote copy requires the suspension of logging activity, which prevents database updates. The SUSPEND option of the SET LOG command suspends logging and update activity until a subsequent SET LOG command with the RESUME option is issued.
Important: Make sure that all members of the group are active when you archive the logs. If you have a quiesced member whose logs are necessary for a recovery base at the disaster recovery site, you must start that member with ACCESS(MAINT) to archive its log.

For read-only members, Db2 periodically writes a log record to prevent those members from keeping the LRSN value too far back on the log.