DB2 V7 z/os - DR via FDR Incremental

Brian Bear

DB2 V7 z/os - DR via FDR Incremental
We're heading into a DR test early Jan. The plan to restore DB2 is to
use FDR incremental copies of DB2 datasets. A -SET LOG SUSPEND is
issued before the FDR FULL and Incremental backups.



The plan is to restore to a Tuesday incremental. The Full backup is
done on a Saturday. I am told that the FDR product will know how to do
this so the latest and greatest files are restored.



Does anyone have any direct experience restoring DB2 this way (i.e. via
incrementals)? Should I be concerned with LEVEL ID?



Any tips for validating the restore once DB2 comes up? I am planning to
review the MSTR log, run -DIS UTIL(*) and some basic SELECTs against
important tables.



Thanks in advance.



Brian.

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on November
30th. Details at http://www.idug.org

------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ben Alford

DB2 V7 z/os - DR via FDR Incremental
(in response to Brian Bear)
We use Innovation's ABR product for full and incremental backups and
their FDRDRP product for DR restores. We currently simply retore to
the newest cycle available at the time of the DR test so we don't
specify specific cycles.

See the Innovation doc for Dataset Selection and "Rarely Closed
Datasets" (section 50.02 in my 5.4 level 50 doc) for the discussion
about insuring that the increments back up rarely closed datasets.
Otherwise, you will likely be missing your DB2 files from your
newest incrementals when doing the incrementals with LOG=SUSPEND.

Please let me know if DB2 closes and reopens EVERYTHING during the
LOG=SUSPEND. We still stop our DB2's during our backups.

Ben Alford Enterprise Systems Programming
University of Tennessee

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Phil Grainger

Re: DB2 V7 z/os - DR via FDR Incremental
(in response to Mike Bell)
Hi Ben

Short answer - no it doesn't

Set Log Suspend externalises log buffers ONLY (it doesn't externalise updated pages in it's deferred write queues, for example) and certainly doesn't close (or open) ANY datasets

Sorry to be the bearer of (possibly) bad news

Phil Grainger
Product Management Director, CA

________________________________

From: DB2 Data Base Discussion List on behalf of Ben Alford
Sent: Wed 05/12/2007 21:23
To: [login to unmask email]
Subject: [DB2-L] DB2 V7 z/os - DR via FDR Incremental



We use Innovation's ABR product for full and incremental backups and
their FDRDRP product for DR restores. We currently simply retore to
the newest cycle available at the time of the DR test so we don't
specify specific cycles.

See the Innovation doc for Dataset Selection and "Rarely Closed
Datasets" (section 50.02 in my 5.4 level 50 doc) for the discussion
about insuring that the increments back up rarely closed datasets.
Otherwise, you will likely be missing your DB2 files from your
newest incrementals when doing the incrementals with LOG=SUSPEND.

Please let me know if DB2 closes and reopens EVERYTHING during the
LOG=SUSPEND. We still stop our DB2's during our backups.

Ben Alford Enterprise Systems Programming
University of Tennessee

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org < http://www.idug.org/ >

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org < http://www.idugdb2-l.org/ > . The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Bell

Re: DB2 V7 z/os - DR via FDR Incremental
(in response to Ben Alford)
DB2 does NOT close datasets during LOG=SUSPEND.
The only way I know to close the datasets is -STOP DATABASE - and you really
don't want to stop DSNDB01 and DSNDB06. The only userid that can start them
again is the INSTALL SYSADM.

Mike
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Ben Alford
Sent: Wednesday, December 05, 2007 3:23 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 V7 z/os - DR via FDR Incremental

We use Innovation's ABR product for full and incremental backups and
their FDRDRP product for DR restores. We currently simply retore to
the newest cycle available at the time of the DR test so we don't
specify specific cycles.

See the Innovation doc for Dataset Selection and "Rarely Closed
Datasets" (section 50.02 in my 5.4 level 50 doc) for the discussion
about insuring that the increments back up rarely closed datasets.
Otherwise, you will likely be missing your DB2 files from your
newest incrementals when doing the incrementals with LOG=SUSPEND.

Please let me know if DB2 closes and reopens EVERYTHING during the
LOG=SUSPEND. We still stop our DB2's during our backups.

Ben Alford Enterprise Systems Programming
University of Tennessee

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the overall
user experience of DB2-L. These changes are coming on November 30th.
Details at http://www.idug.org

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.16.14/1172 - Release Date: 12/5/2007
8:41 AM


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.16.14/1172 - Release Date: 12/5/2007
8:41 AM


IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ben Alford

DB2 V7 z/os - DR via FDR Incremental
(in response to Phil Grainger)
Thanks for the confirmation about DB2 leaving its datasets open during
LOG=SUSPEND. Its not a surprise to me since we take our DB2's down
during all backups. That way we don't have any fuzzy backups. It could
be a surprise for folks taking incremental backups while DB2 is up.

Ben Alford Enterprise Systems Programming
University of Tennessee

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on December 7th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm