[Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery

Raymond Bell

[Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery
Hey Steve,

Your timing is perfect - I spent the first two days this week at one of our
regular DR tests, and mirroring is exactly what we do. The first day was
spent re-proving our backup DR method (using BMC's Recovery Manager) still
works in case PPRC goes AWOL - it does. The 2nd day was basically an hour
or so waiting for the Sysprogs to bring up the LPAR at our snap point, DB2
subsystems included, and having a quick butchers at our subsystems to make
sure they were fine (they were), followed by several hours of sitting around
waiting for someone to notice something that didn't work - they didn't.

DR for us now is a piece of cake. The hard work is done by our DASD and
Sysprog bods. We currently suspend the logs briefly while we take our
snaps, but it's not necessary and we'll stop doing that shortly.

Anyway, it works a treat. Mind you, our DR site is only 30 or so miles away
so we don't experience (I believe) any of the latency Eric mentioned as a
possibility. So, as always, YMMV I believe the short-hand is.

Cheers,


Raymond Bell
Database Administrator
PS. The one hard bit we still face is synching up with all those non-z/OS
worlds - AS/400, NT. Makes me chuckle. Bless 'em; they'll catch up one
day...

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Steve Lamb
Sent: 18 January 2007 13:01
To: [login to unmask email]
Subject: [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery

We need to come up with a proposal to be able to recover a DB2 system at a
second site. The disks would be mirrored - one set in the primary data
centre and the second set in a second centre a couple of hundred miles away.
If the primary data centre goes down, then we will need to IPL a machine at
the second centre and recover the systems within a couple of hours.

Obviously there are quite a few complications in this - the MVS catalogs,
IMS, CICS and DB2 etc. Does anybody do anything similar and what sort of
tools/products do you use to do this?

Steve

----------------------------------------------------------------------------
-----
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


This e-mail (and any attachments) may contain privileged and/or confidential information. If you are not the intended recipient please do not disclose, copy, distribute, disseminate or take any action in reliance on it. If you have received this message in error please reply and tell us and then delete it. Should you wish to communicate with us by e-mail we cannot guarantee the security of any data outside our own computer systems. For the protection of Legal & General's systems and staff, incoming emails will be automatically scanned.

Any information contained in this message may be subject to applicable terms and conditions and must not be construed as giving investment advice within or outside the United Kingdom.

The following companies are subsidiary companies of the Legal & General Group Plc which are authorised and regulated by the Financial Services Authority for advising and arranging the products shown: Legal & General Partnership Services Limited (insurance and mortgages), Legal & General Insurance Limited (insurance), Legal & General Assurance Society Limited
(life assurance, pensions and investments), Legal & General Unit Trust Managers Limited and Legal & General Portfolio Management Services Limited (investments).

They are registered in England under numbers shown.
The registered office is Temple Court, 11 Queen Victoria Street, London EC4N 4TP.

Legal & General Partnership Services Limited: 5045000 Legal & General Assurance Society Limited: 166055 Legal & General (Unit Trust Managers) Limited: 1009418 Legal & General (Portfolio Management Services) Limited: 2457525 Legal & General Insurance Limited: 423930

They are registered with the Financial Services Authority under numbers shown. You can check this at www.fsa.gov.uk/register

Legal & General Partnership Services Limited: 300792 Legal & General Assurance Society Limited: 117659 Legal & General (Unit Trust Managers) Limited: 119273 Legal & General (Portfolio Management Services) Limited: 146786 Legal & General Insurance Limited: 202050

---------------------------------------------------------------------------------
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

Tom Moulder

Re: OS/390 offsite disk mirroring/recovery
(in response to Raymond Bell)
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Pearson, Eric
Sent: Thursday, January 18, 2007 7:29 AM
To: [login to unmask email]
Subject: Re: [DB2-L] OS/390 offsite disk mirroring/recovery

<snip>

6) How to return to 'home site' after crisis passes. I do not
know anybody who has tried this (or even tested!).

<unsnip>

I have worked with several companies that have successfully accomplished
this round trip. When you have worked out all the details it is as routine
as anything I have ever done. It will take you some time to work out the
details for your shop and environment.

Please feel free to call or e-mail off-list and I will help you as much as
possible.

Tom Moulder
TREX Associates, Inc.
9728 Delmonico Dr.
Keller, Tx. 76248-9559
+1 817 741-5549 Office
+1 817 741-5548 Fax
+1 682 558-6527 Mobile
[login to unmask email]
www.t-rex-associates.com

---------------------------------------------------------------------------------
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

Brian Bear

Re: [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery
(in response to Tom Moulder)
Why is suspending the logs briefly while you take your snaps, not
necessary?

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
Sent: Thursday, January 18, 2007 9:15 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [Maybe Spam] [DB2-L] OS/390 offsite disk
mirroring/recovery






Hey Steve,

Your timing is perfect - I spent the first two days this week at one of
our regular DR tests, and mirroring is exactly what we do. The first
day was spent re-proving our backup DR method (using BMC's Recovery
Manager) still works in case PPRC goes AWOL - it does. The 2nd day was
basically an hour or so waiting for the Sysprogs to bring up the LPAR at
our snap point, DB2 subsystems included, and having a quick butchers at
our subsystems to make sure they were fine (they were), followed by
several hours of sitting around waiting for someone to notice something
that didn't work - they didn't.

DR for us now is a piece of cake. The hard work is done by our DASD and
Sysprog bods. We currently suspend the logs briefly while we take our
snaps, but it's not necessary and we'll stop doing that shortly.

Anyway, it works a treat. Mind you, our DR site is only 30 or so miles
away so we don't experience (I believe) any of the latency Eric
mentioned as a possibility. So, as always, YMMV I believe the
short-hand is.

Cheers,


Raymond Bell
Database Administrator
PS. The one hard bit we still face is synching up with all those
non-z/OS worlds - AS/400, NT. Makes me chuckle. Bless 'em; they'll
catch up one day...

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Steve Lamb
Sent: 18 January 2007 13:01
To: [login to unmask email]
Subject: [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery

We need to come up with a proposal to be able to recover a DB2 system at
a second site. The disks would be mirrored - one set in the primary data
centre and the second set in a second centre a couple of hundred miles
away.
If the primary data centre goes down, then we will need to IPL a machine
at the second centre and recover the systems within a couple of hours.

Obviously there are quite a few complications in this - the MVS
catalogs, IMS, CICS and DB2 etc. Does anybody do anything similar and
what sort of tools/products do you use to do this?

Steve

------------------------------------------------------------------------
----

-----
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


This e-mail (and any attachments) may contain privileged and/or
confidential information. If you are not the intended recipient please
do not disclose, copy, distribute, disseminate or take any action in
reliance on it. If you have received this message in error please reply
and tell us and then delete it. Should you wish to communicate with us
by e-mail we cannot guarantee the security of any data outside our own
computer systems.
For the protection of Legal & General's systems and staff, incoming
emails will be automatically scanned.

Any information contained in this message may be subject to applicable
terms and conditions and must not be construed as giving investment
advice within or outside the United Kingdom.

The following companies are subsidiary companies of the Legal & General
Group Plc which are authorised and regulated by the Financial Services
Authority for advising and arranging the products shown: Legal & General
Partnership Services Limited (insurance and mortgages), Legal & General
Insurance Limited (insurance), Legal & General Assurance Society Limited
(life assurance, pensions and investments), Legal & General Unit Trust
Managers Limited and Legal & General Portfolio Management Services
Limited (investments).

They are registered in England under numbers shown.
The registered office is Temple Court, 11 Queen Victoria Street, London
EC4N 4TP.

Legal & General Partnership Services Limited: 5045000 Legal & General
Assurance Society Limited: 166055 Legal & General (Unit Trust Managers)
Limited: 1009418 Legal & General (Portfolio Management Services)
Limited:
2457525 Legal & General Insurance Limited: 423930

They are registered with the Financial Services Authority under numbers
shown. You can check this at www.fsa.gov.uk/register

Legal & General Partnership Services Limited: 300792 Legal & General
Assurance Society Limited: 117659 Legal & General (Unit Trust Managers)
Limited: 119273 Legal & General (Portfolio Management Services) Limited:
146786 Legal & General Insurance Limited: 202050

------------------------------------------------------------------------
---------

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

*****************************************************************************
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this message in error, please contact the sender and delete
the material from any computer.
*****************************************************************************

---------------------------------------------------------------------------------
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

Raymond Bell

Re: [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/re covery
(in response to Brian Bear)
Brian,

Basically because the snapping isn't used for our DB2 recoveries, but for
everything (i.e. non-DB2) else.

Our normal DR recovery process is to make use of the hot DASD at the DR site
via PPRC, so all we do is start 'er up and off we go. If we have to fall
back to our 'recover everything' process, we go back to our last archive log
point. We effectively do a conditional restart to the point of the last
archive - which for us will be immediately prior to the snap, because we've
manually -ARCHIVEd the log at that point - and recover everything 'to
current'. BMC's Recovery Manager has already built all the jobs for us so
it's quite straightforward.

So the snaps aren't for us, nor are they used by us. They're hangovers from
a previous DR strategy we used to have, involving stopping the subsystems
(you can stop laughing now), and should be removed. However if you're using
the snap copies for your DR then yes, it might be a good idea to suspend the
log while you snap.

Cheers,


Raymond Bell
Database Administrator


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Bear, Brian
Sent: 18 January 2007 22:48
To: [login to unmask email]
Subject: Re: [DB2-L] [Maybe Spam] [DB2-L] OS/390 offsite disk
mirroring/recovery

Why is suspending the logs briefly while you take your snaps, not necessary?


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
Sent: Thursday, January 18, 2007 9:15 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [Maybe Spam] [DB2-L] OS/390 offsite disk
mirroring/recovery






Hey Steve,

Your timing is perfect - I spent the first two days this week at one of
our regular DR tests, and mirroring is exactly what we do. The first
day was spent re-proving our backup DR method (using BMC's Recovery
Manager) still works in case PPRC goes AWOL - it does. The 2nd day was
basically an hour or so waiting for the Sysprogs to bring up the LPAR at
our snap point, DB2 subsystems included, and having a quick butchers at
our subsystems to make sure they were fine (they were), followed by
several hours of sitting around waiting for someone to notice something
that didn't work - they didn't.

DR for us now is a piece of cake. The hard work is done by our DASD and
Sysprog bods. We currently suspend the logs briefly while we take our
snaps, but it's not necessary and we'll stop doing that shortly.

Anyway, it works a treat. Mind you, our DR site is only 30 or so miles
away so we don't experience (I believe) any of the latency Eric
mentioned as a possibility. So, as always, YMMV I believe the
short-hand is.

Cheers,


Raymond Bell
Database Administrator
PS. The one hard bit we still face is synching up with all those
non-z/OS worlds - AS/400, NT. Makes me chuckle. Bless 'em; they'll
catch up one day...

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Steve Lamb
Sent: 18 January 2007 13:01
To: [login to unmask email]
Subject: [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery

We need to come up with a proposal to be able to recover a DB2 system at
a second site. The disks would be mirrored - one set in the primary data
centre and the second set in a second centre a couple of hundred miles
away.
If the primary data centre goes down, then we will need to IPL a machine
at the second centre and recover the systems within a couple of hours.

Obviously there are quite a few complications in this - the MVS
catalogs, IMS, CICS and DB2 etc. Does anybody do anything similar and
what sort of tools/products do you use to do this?

Steve

------------------------------------------------------------------------
----

-----
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


This e-mail (and any attachments) may contain privileged and/or
confidential information. If you are not the intended recipient please
do not disclose, copy, distribute, disseminate or take any action in
reliance on it. If you have received this message in error please reply
and tell us and then delete it. Should you wish to communicate with us
by e-mail we cannot guarantee the security of any data outside our own
computer systems.
For the protection of Legal & General's systems and staff, incoming
emails will be automatically scanned.

Any information contained in this message may be subject to applicable
terms and conditions and must not be construed as giving investment
advice within or outside the United Kingdom.

The following companies are subsidiary companies of the Legal & General
Group Plc which are authorised and regulated by the Financial Services
Authority for advising and arranging the products shown: Legal & General
Partnership Services Limited (insurance and mortgages), Legal & General
Insurance Limited (insurance), Legal & General Assurance Society Limited
(life assurance, pensions and investments), Legal & General Unit Trust
Managers Limited and Legal & General Portfolio Management Services
Limited (investments).

They are registered in England under numbers shown.
The registered office is Temple Court, 11 Queen Victoria Street, London
EC4N 4TP.

Legal & General Partnership Services Limited: 5045000 Legal & General
Assurance Society Limited: 166055 Legal & General (Unit Trust Managers)
Limited: 1009418 Legal & General (Portfolio Management Services)
Limited:
2457525 Legal & General Insurance Limited: 423930

They are registered with the Financial Services Authority under numbers
shown. You can check this at www.fsa.gov.uk/register

Legal & General Partnership Services Limited: 300792 Legal & General
Assurance Society Limited: 117659 Legal & General (Unit Trust Managers)
Limited: 119273 Legal & General (Portfolio Management Services) Limited:
146786 Legal & General Insurance Limited: 202050

------------------------------------------------------------------------
---------

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

****************************************************************************
*
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this message in error, please contact the sender and delete
the material from any computer.
****************************************************************************
*

----------------------------------------------------------------------------
-----
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

---------------------------------------------------------------------------------
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

Steven Lamb

Re: [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery
(in response to Raymond Bell)
Ray,

Thanks for that. How "current" are you at the second site when you invoke
DR?
It now looks like they want to go for an asynch link to the second site,
with sorting out DB2 and IMS recovery "manually", rather than having PPRC
POC's or whatever .

Steve

---------------------------------------------------------------------------------
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

Avram Friedman

Re: OS/390 offsite disk mirroring/recovery
(in response to Steven Lamb)
Few got-you's I have experienced with this sort of recovery are:

Lots of pages in the LPL at the remote site.
Remember do the recovery test at quite times the first few tests
to stablize procedures
Then at peek time ... disasters ALWAYS happen at the worst possible time


CF / SYSPLEX management
Its more than just an IPL of the base system

User / Network confusion durring the test


One shop that used the mirror style recovery that I supported would test
the process at least weekly,
Split the mirroring
IPL a remote image under VM
Copy everything for vaulting
Re-consitute the mirror

They would also bring up the recovery system a few times a week to get the
kinks out of any planed weekend change.

Don't think going back to the home site at the end of any real disaster is
much of a problem ... instead of reconsituteing the Mirror home to remote
its done the other way around.

Avram Friedman
877-311-0480

---------------------------------------------------------------------------------
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