Recommendation for Tools to restore previous backup

Amit Agarwal

Recommendation for Tools to restore previous backup
z/os 1.4 DB2 v7

We would like to consider evaluating a tool that would unload data for all tables in a database from Image copies(in tape) in Production and reload it to a test subsystem. Does such a tool exist? We have BMC Alter, Catalog manager, Unload and Load.

Thanks
Amit

--------------------------------------------------------
The information contained in this message is intended only for the recipient, and may be a confidential attorney-client communication or may otherwise be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, please be aware that any dissemination or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by replying to the message and deleting it from your 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

Robert Tilkes

Re: Recommendation for Tools to restore previous backup
(in response to Mike Bell)
Try using IBM Unload. You can unload from an imagecopy on production and
then run a load on test.

bob



"Agarwal,
Amit"
<amit_agarwal From
@STANDARDANDP "Agarwal, Amit"
OORS.COM> <[login to unmask email]
M>
Sent by: DB2 To
Data Base [login to unmask email]
Discussion cc
List
<[login to unmask email] Subject
2-L.ORG> [DB2-L] Recommendation for Tools
to restore previous backup



12/07/2005
01:26 PM
Please
respond to
DB2 Database
Discussion
list at IDUG
<[login to unmask email]
UGDB2-L.ORG>





z/os 1.4 DB2 v7

We would like to consider evaluating a tool that would unload data for all
tables in a database from Image copies(in tape) in Production and reload it
to a test subsystem. Does such a tool exist? We have BMC Alter, Catalog
manager, Unload and Load.

Thanks
Amit


The information contained in this message is intended only for the
recipient, and may be a confidential attorney-client communication or may
otherwise be privileged and confidential and protected from disclosure. If
the reader of this message is not the intended recipient, or an employee or
agent responsible for delivering this message to the intended recipient,
please be aware that any dissemination or copying of this communication is
strictly prohibited. If you have received this communication in error,
please immediately notify us by replying to the message and deleting it
from your 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

Mike Bell

Re: Recommendation for Tools to restore previous backup
(in response to Amit Agarwal)
Is there some reason you don't want to use DSN1COPY? search the archives for
the REXX that will build the DSN1COPY jcl with OBIDXLAT cards to do a copy.
It will require minor modifications because the last time I looked at it, it
expected both the source and the target to be available in the same sysibm
catalog. It should be simple to extend it to process an entire database.

Another choice would be to build a worklist to unload the data and a
separate worklist to load the data.

The biggest issue is tracking and handleing table changes and new/deleted
tables. unless you generate a new worklist every week, I don't know of a
tool that will handle the changes.

Mike Bell
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Agarwal, Amit
Sent: Wednesday, December 07, 2005 1:27 PM
To: [login to unmask email]
Subject: [DB2-L] Recommendation for Tools to restore previous backup

z/os 1.4 DB2 v7

We would like to consider evaluating a tool that would unload data for all
tables in a database from Image copies(in tape) in Production and reload it
to a test subsystem. Does such a tool exist? We have BMC Alter, Catalog
manager, Unload and Load.

Thanks
Amit

________________________________

The information contained in this message is intended only for the
recipient, and may be a confidential attorney-client communication or may
otherwise be privileged and confidential and protected from disclosure. If
the reader of this message is not the intended recipient, or an employee or
agent responsible for delivering this message to the intended recipient,
please be aware that any dissemination or copying of this communication is
strictly prohibited. If you have received this communication in error,
please immediately notify us by replying to the message and deleting it from
your 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


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


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

HEPP SHERY C

Re: Recommendation for Tools to restore previous backup
(in response to Robert Tilkes)
Check with your bmc rep- I think bmc change manager will generate jcl
for you to use image copies as input for migrating data.



_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Agarwal, Amit
Sent: Wednesday, December 07, 2005 12:27 PM
To: [login to unmask email]
Subject: [DB2-L] Recommendation for Tools to restore previous backup



z/os 1.4 DB2 v7



We would like to consider evaluating a tool that would unload data for
all tables in a database from Image copies(in tape) in Production and
reload it to a test subsystem. Does such a tool exist? We have BMC
Alter, Catalog manager, Unload and Load.



Thanks

Amit



_____

The information contained in this message is intended only for the
recipient, and may be a confidential attorney-client communication or
may otherwise be privileged and confidential and protected from
disclosure. If the reader of this message is not the intended recipient,
or an employee or agent responsible for delivering this message to the
intended recipient, please be aware that any dissemination or copying of
this communication is strictly prohibited. If you have received this
communication in error, please immediately notify us by replying to the
message and deleting it from your 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

Steen Rasmussen

Re: Recommendation for Tools to restore previous backup
(in response to HEPP SHERY C)
Hello Amit -



Instead of first unloading and then loading - you can use CA Fast
Recover to do a recovery on the target with out without Log Apply even
though the imagecopies were taken for another set if objects. I feel
confident BMC Recover+ can do the same.



Kind regards
Steen Rasmussen
CA
Senior Consultant



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Agarwal, Amit
Sent: Wednesday, December 07, 2005 1:27 PM
To: [login to unmask email]
Subject: [DB2-L] Recommendation for Tools to restore previous backup



z/os 1.4 DB2 v7



We would like to consider evaluating a tool that would unload data for
all tables in a database from Image copies(in tape) in Production and
reload it to a test subsystem. Does such a tool exist? We have BMC
Alter, Catalog manager, Unload and Load.



Thanks

Amit



________________________________

The information contained in this message is intended only for the
recipient, and may be a confidential attorney-client communication or
may otherwise be privileged and confidential and protected from
disclosure. If the reader of this message is not the intended recipient,
or an employee or agent responsible for delivering this message to the
intended recipient, please be aware that any dissemination or copying of
this communication is strictly prohibited. If you have received this
communication in error, please immediately notify us by replying to the
message and deleting it from your 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

Peter L Schouboe

Re: Recommendation for Tools to restore previous backup
(in response to Steen Rasmussen)
Hi Amit



Sure it does. Contact your local CA (former Computer Associates) and
learn more about our Unicenter Database Management Suite. There are a
number of alternativ es supporting just that scenario.



Kind regards / Med venlig hilsen





Peter Schouboe

CA Denmark A/S

Tel: +45 45 47 42 13

mob: +45 22 68 25 67

Fax: +45 45 47 41 10

eMail: [login to unmask email] <mailto:[login to unmask email]>

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Agarwal, Amit
Sent: 07 December 2005 20:27
To: [login to unmask email]
Subject: [DB2-L] Recommendation for Tools to restore previous backup



z/os 1.4 DB2 v7



We would like to consider evaluating a tool that would unload data for
all tables in a database from Image copies(in tape) in Production and
reload it to a test subsystem. Does such a tool exist? We have BMC
Alter, Catalog manager, Unload and Load.



Thanks

Amit



________________________________

The information contained in this message is intended only for the
recipient, and may be a confidential attorney-client communication or
may otherwise be privileged and confidential and protected from
disclosure. If the reader of this message is not the intended recipient,
or an employee or agent responsible for delivering this message to the
intended recipient, please be aware that any dissemination or copying of
this communication is strictly prohibited. If you have received this
communication in error, please immediately notify us by replying to the
message and deleting it from your 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

Dan Lohmeier

Re: Recommendation for Tools to restore previous backup
(in response to Peter L Schouboe)
Amit,

The BMC SOFTWARE product ALTER for DB2 has this functionality.
It will generate the worklist and JCL to accomplish this task.

You can contact BMC Support at 800-537-1813 to discuss in detail.

Best Regards,

Dan

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

Amit Agarwal

Re: Recommendation for Tools to restore previous backup
(in response to Dan Lohmeier)
Thanks to all those who replied. I am looking into the various options.
-Amit

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Dan Lohmeier
Sent: Friday, December 09, 2005 11:52 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Recommendation for Tools to restore previous backup


Amit,

The BMC SOFTWARE product ALTER for DB2 has this functionality.
It will generate the worklist and JCL to accomplish this task.

You can contact BMC Support at 800-537-1813 to discuss in detail.

Best Regards,

Dan

---------------------------------------------------------------------------------
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 contained in this message is intended only for the recipient, and may be a confidential attorney-client communication or may otherwise be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, please be aware that any dissemination or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by replying to the message and deleting it from your 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