[z/OS 1.9 DB2 v8 NFM] SYSTEM BACKUP utility

Mark Vickers

[z/OS 1.9 DB2 v8 NFM] SYSTEM BACKUP utility
I would like to test this utility and have a few questions:

The requirements states that two SMS copy pools are required -
does this mean I need two matching pools for the subsystem ?

Anyone using this for DR or reasons why you would not ?

Any other comments/experiences greatly appreciated.

Thanks,
Mark Vickers



This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.




______________________________________________________________________

* 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: [z/OS 1.9 DB2 v8 NFM] SYSTEM BACKUP utility
(in response to Mark Vickers)
Mark, as we've considered using it here in my shop, I found out that you
absolutely need HSM, which we don't have, as we got another product which
does our migrations and recalls, but not this Fast Replication process.
Also your BACKUP can be for data only or for data and logs to separate SMS
pools. I believe the RESTORE utility is only for the data.

One last thing: In V9 you can do RESTORE for individual tablespaces , but
not in V8.


HTH,

Irwin


______________________________________________________________________

* 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

Mark Vickers

Re: [z/OS 1.9 DB2 v8 NFM] SYSTEM BACKUP utility
(in response to Irwin Deutsch)
Irwin - we do have HSM, so I am happy about that !
I will have to look up the RESTORE as it seems pointless if it cannot
restore the logs as well ?
Thanks , Mark.



Irwin Deutsch <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/21/2009 12:35 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] [z/OS 1.9 DB2 v8 NFM] SYSTEM BACKUP utility







Mark, as we've considered using it here in my shop, I found out that you
absolutely need HSM, which we don't have, as we got another product which
does our migrations and recalls, but not this Fast Replication process.
Also your BACKUP can be for data only or for data and logs to separate SMS
pools. I believe the RESTORE utility is only for the data.

One last thing: In V9 you can do RESTORE for individual tablespaces , but
not in V8.


HTH,

Irwin

IDUG 2009 - Europe * 5-9 October * Rome, Italy
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.




This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.




______________________________________________________________________

* 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

Mark Labby

Re: [z/OS 1.9 DB2 v8 NFM] SYSTEM BACKUP utility
(in response to Mark Vickers)

Hi Mark,

I'm starting to look into this too, but haven';t been able to use it yet.  I do know the RESTORE definitely does logs.  The default is to do data and logs, but you can specify LOGONLY if the data was restored outside DB2.

I'd be very interested in people's experiences using this - both good and bad.

Mark Labby

Senior Database Administrator
American Education Services/PHEAA
717-720-2731 -- [login to unmask email]
IBM Certified Database Administrator, DB2 UDB v8.1 for z/OS

IDUG Web Committee Chair 2008-2009
www.IDUG.org



"Mark Vickers" <[login to unmask email]>
Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>

01/21/2009 02:12 PM

Please respond to
"DB2 Database Discussion list at IDUG" <[login to unmask email]>

To
[login to unmask email]
cc
Subject
Re: [z/OS 1.9 DB2 v8 NFM] SYSTEM BACKUP utility






Irwin - we do have HSM, so I am happy about that !
I will have to look up the RESTORE as it seems pointless if it cannot restore the logs as well ?
Thanks , Mark.

Irwin Deutsch <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

01/21/2009 12:35 PM

Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>
To
[login to unmask email]
cc
Subject
Re: [DB2-L] [z/OS 1.9 DB2 v8 NFM] SYSTEM BACKUP utility








Mark, as we've considered using it here in my shop, I found out that you absolutely need HSM, which we don't have, as we got another product which does our migrations and recalls, but not this Fast Replication process. Also your BACKUP can be for data only or for data and logs to separate SMS pools. I believe the RESTORE utility is only for the data.

One last thing: In V9 you can do RESTORE for individual tablespaces , but not in V8.


HTH,

Irwin

===== This message contains privileged and confidential information intended for the above addressees only. If you receive this message in error please delete or destroy this message and/or attachments. The sender of this message will fully cooperate in the civil and criminal prosecution of any individual engaging in the unauthorized use of this message. =====


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.

Irwin Deutsch

Re: [z/OS 1.9 DB2 v8 NFM] SYSTEM BACKUP utility
(in response to Mark Labby)
Hi Marks,

This is a quote from the V9 Utility guide.

Restriction: RESTORE SYSTEM does not restore logs; the utility only
applies the logs. If you specified BACKUP SYSTEM FULL to create copies of
both the data and the logs, you can restore the logs by another method.


Remember, perhaps a big reason to go to V9 (if you haven't) is that you
can restore a single tablespace from these backups only in V9, not in V8.


Regards,

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