DB2 'BACKUP SYSTEM' Question

Irwin Deutsch

DB2 'BACKUP SYSTEM' Question
Hi,

We're on DB2 for z/OS V9, thinking of using BACKUP SYSTEM and RESTORE
SYSTEM utilities for our DR processing. The utility manual says it links
to HSM. What happens if we don't have HSM? Our migration product (FDR)
doesn't support this.

Any ideas would be much appreciated!


Thanks,

Irwin Deutsch

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Jim Tonchick

Re: DB2 'BACKUP SYSTEM' Question
(in response to Irwin Deutsch)
The BACKUP SYSTEM facility links DB2, SMS & HSM at the software level, plus you must have DASD that supports the IBM Flashcopy API like IBM Shark, STK (Sun)?or EMC.? The hardest requirement to satisfy is that you must use the tapes output by HSM as the input to the recovery process at the DR site and recover HSM first.? In addition, you need to make sure that your DR recovery site has the same or similar hardware as your?home site.?

But most large shops with critical recovery requirements are moving to mirrored offsite DASD, thus making the BACKUP SYSTEM facility less popular of an alternative.? While BACKUP SYSTEM works well for data stored in DB2, it does nothing for critical data files in VSAM or flat files.? Mirrored remote DASD works for all files on the mirrored volumes.

Jim Tonchick
Unitrin Data Services


-----Original Message-----
From: Irwin Deutsch <[login to unmask email]>
To: [login to unmask email]
Sent: Fri, 2 Jan 2009 2:03 pm
Subject: [DB2-L] DB2 'BACKUP SYSTEM' Question



Hi,

We're on DB2 for z/OS V9, thinking of using BACKUP SYSTEM and RESTORE SYSTEM utilities for our DR processing. The utility manual says it links to HSM. What happens if we don't have HSM? Our migration product (FDR) doesn't support this.

Any ideas would be much appreciated!


Thanks,

Irwin Deutsch


IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia
IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.


IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.



______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Isaac Yassin

Re: DB2 'BACKUP SYSTEM' Question
(in response to Jim Tonchick)
Hi,

As long as you remember that the mirror DASD are good for a
DR when your "local" DASD breaks -it's ok.
However, should you get "garbage" into your system - the
mirror will just have it in both DASD farms :-)

You need a backup to recover from that.

Isaac

---- Original message ----
>Date:   Fri, 2 Jan 2009 20:57:45 -0500
>From:   [login to unmask email]
>Subject:   Re: [DB2-L] DB2 'BACKUP SYSTEM' Question
>To:   [login to unmask email]
>
> The BACKUP SYSTEM facility links DB2, SMS & HSM at
> the software level, plus you must have DASD that
> supports the IBM Flashcopy API like IBM Shark, STK
> (Sun) or EMC. The hardest requirement to satisfy is
> that you must use the tapes output by HSM as the
> input to the recovery process at the DR site and
> recover HSM first. In addition, you need to make
> sure that your DR recovery site has the same or
> similar hardware as your home site.
>
> But most large shops with critical recovery
> requirements are moving to mirrored offsite DASD,
> thus making the BACKUP SYSTEM facility less popular
> of an alternative. While BACKUP SYSTEM works well
> for data stored in DB2, it does nothing for critical
> data files in VSAM or flat files. Mirrored remote
> DASD works for all files on the mirrored volumes.
>
> Jim Tonchick
> Unitrin Data Services
>
> -----Original Message-----
> From: Irwin Deutsch <[login to unmask email]>
> To: [login to unmask email]
> Sent: Fri, 2 Jan 2009 2:03 pm
> Subject: [DB2-L] DB2 'BACKUP SYSTEM' Question
>
> Hi,
>
> We're on DB2 for z/OS V9, thinking of using BACKUP
> SYSTEM and RESTORE SYSTEM utilities for our DR
> processing. The utility manual says it links to HSM.
> What happens if we don't have HSM? Our migration
> product (FDR) doesn't support this.
>
> Any ideas would be much appreciated!
>
> Thanks,
>
> Irwin Deutsch
>
> ------------------------------------------------
>
> IDUG 2009 - Australasia * 18-20 March * Melbourne,
> Australia
> IDUG.org was recently updated requiring members to
> use a new password. You should have gotten an e-mail
> with the temporary password assigned to your
> account. Please log in and update your member
> profile. If you are not already an IDUG.org member,
> please register here.
>
> ------------------------------------------------
>
> Get a free MP3 every day with the Spinner.com
> Toolbar. Get it Now.
>
> ------------------------------------------------
>
>IDUG 2009 - North America * May 11-15 * Denver, Colorado,
> USA
>
> IDUG.org was recently updated requiring members to
> use a new password. You should have gotten an e-mail
> with the temporary password assigned to your
> account. Please log in and update your member
> profile. If you are not already an IDUG.org member,
> please register here.


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Irwin Deutsch

Re: DB2 'BACKUP SYSTEM' Question
(in response to Isaac Yassin)
Sorry, I was incorrect in stating that we wanted to use BACKUP SYSTEM for
DR. We want it for normal backups. It sounds like a normal, desirable
request - to get 'instantaneous' copies without all those COPY statements.


Anyway, I think it's too bad that it's so dependent on an optional product
like HSM. Perhaps there should be a minimalist version of HSM provided in
SMS for this purpose.

Any comments on this or third-party options would be most welcomed!


Thanks,

Irwin

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Raymond Bell

Re: DB2 'BACKUP SYSTEM' Question
(in response to Irwin Deutsch)
Hi Irwin,

Someone at BMC (step forward, Mr. Weaver) has recorded a Webinar on DB2 9 and backup and recovery features. I listened to it the other day and it has a good discussion on IBM's Backup System and Recover utilities. It also mentions some of the restrictions. When I get back to the office tomorrow I'll forward you a link to the Webinar so you can have a listen if you're interested.

I tried to find some details to confirm or deny my belief that, although Recover can use a system backup to recover an individual TS, it must still be on the original DASD volume that contained the TS at the time the backup was taken. Unfortunately I was unable to. More digging required on my part. So if you reorg or otherwise move the TS to another volume you might not be able to use the Backup System backup as a basis for recovery. As I say, I tried to verify this but gave up before succeeding.

Hope this helps,


Raymond

________________________________

From: DB2 Data Base Discussion List on behalf of Irwin Deutsch
Sent: Wed 1/7/2009 6:31 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 'BACKUP SYSTEM' Question



Sorry, I was incorrect in stating that we wanted to use BACKUP SYSTEM for DR. We want it for normal backups. It sounds like a normal, desirable request - to get 'instantaneous' copies without all those COPY statements.

Anyway, I think it's too bad that it's so dependent on an optional product like HSM. Perhaps there should be a minimalist version of HSM provided in SMS for this purpose.

Any comments on this or third-party options would be most welcomed!


Thanks,

Irwin

________________________________


IDUG 2009 - North America * May 11-15 * Denver, Colorado, USA < http://idug.org/lsna >

IDUG.org <http://www.idug.org/> was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here. < http://www.idug.org/component/juser/register.html >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Irwin Deutsch

Re: DB2 'BACKUP SYSTEM' Question
(in response to Raymond Bell)
Thanks for your response, Raymond. Any help such as Webinar would be
greatly appreciated. I don't think there should be a problem for location
of tablespace for the Recover as the Backup System works on SMS pool, so
as long as TS is still in pool ...

I could be wrong there, but we probably can't use this anyway as we're not
planning to get HSM.


Thanks,

Irwin

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Rick Weaver

Re: DB2 'BACKUP SYSTEM' Question
(in response to Irwin Deutsch)
You asked for third-party options ... I have a whitepaper at
http://documents.bmc.com/products/documents/56/38/85638/85638.pdf that
outlines a couple of techniques from BMC Software that can eliminate
downtime for copy, reduce CPU for copy, and reduce downtime and CPU for
recovery.

Please let me know off list if you would like more information.

Regards,

Rick Weaver
Product Manager
DB2 z/OS Solutions
BMC Software



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Irwin Deutsch
Sent: Wednesday, January 07, 2009 12:32 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 'BACKUP SYSTEM' Question



Sorry, I was incorrect in stating that we wanted to use BACKUP SYSTEM
for DR. We want it for normal backups. It sounds like a normal,
desirable request - to get 'instantaneous' copies without all those COPY
statements.

Anyway, I think it's too bad that it's so dependent on an optional
product like HSM. Perhaps there should be a minimalist version of HSM
provided in SMS for this purpose.

Any comments on this or third-party options would be most welcomed!


Thanks,

Irwin

________________________________


IDUG 2009 - North America * May 11-15 * Denver, Colorado, USA
< http://idug.org/lsna >

IDUG.org < http://www.idug.org > was recently updated requiring members
to use a new password. You should have gotten an e-mail with the
temporary password assigned to your account. Please log in and update
your member profile. If you are not already an IDUG.org member, please
register here. < http://www.idug.org/component/juser/register.html >


______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html