Recovery topic

Wayne Lam

Recovery topic
I need to restore a set of DB2 tables in our Test DB2 region with the FULL image copies from BMC COPY+, but the entries in the SYSCOPY were removed by the MODIFY RECOVERY utility. Is there any way that I can re-register the image copy datasets into SYSCOPY? If not, I have to use DSN1COPY to restore them, then do I need to use the RESET option?

Thanks,

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Steen Rasmussen

Re: Recovery topic
(in response to Wayne Lam)
I am sure BMC has a utility (MODIFY+ perhaps) like CA has which can insert into SYSCOPY - as long as you have the image copy dataset name handy - or you can use a log tool to see what the name was doing UNDO analysis. If you have their UNLOAD+, I believe you also can unload.

Sorry BMC if I missed some of your features :-)

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified database Administrator - DB2 9 DBA for z/OS



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Wayne Lam
Sent: Tuesday, February 08, 2011 6:52 PM
To: [login to unmask email]
Subject: [DB2-L] Recovery topic

I need to restore a set of DB2 tables in our Test DB2 region with the FULL image copies from BMC COPY+, but the entries in the SYSCOPY were removed by the MODIFY RECOVERY utility. Is there any way that I can re-register the image copy datasets into SYSCOPY? If not, I have to use DSN1COPY to restore them, then do I need to use the RESET option?

Thanks,

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Ken McDonald

Re: Recovery topic
(in response to Steen Rasmussen)
Wayne, the utility is C+\Modify. Call BMC Support... they're on call to help for these type situations too, not just for product problems.

Ken

p.s. Steen, come on over to the dark side!

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Rasmussen, Steen
Sent: Tuesday, February 08, 2011 7:06 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Recovery topic

I am sure BMC has a utility (MODIFY+ perhaps) like CA has which can insert into SYSCOPY - as long as you have the image copy dataset name handy - or you can use a log tool to see what the name was doing UNDO analysis. If you have their UNLOAD+, I believe you also can unload.

Sorry BMC if I missed some of your features :-)

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified database Administrator - DB2 9 DBA for z/OS



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Wayne Lam
Sent: Tuesday, February 08, 2011 6:52 PM
To: [login to unmask email]
Subject: [DB2-L] Recovery topic

I need to restore a set of DB2 tables in our Test DB2 region with the FULL image copies from BMC COPY+, but the entries in the SYSCOPY were removed by the MODIFY RECOVERY utility. Is there any way that I can re-register the image copy datasets into SYSCOPY? If not, I have to use DSN1COPY to restore them, then do I need to use the RESET option?

Thanks,

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Steen Rasmussen

Re: Recovery topic
(in response to Ken McDonald)
Good evening Ken ,
I don't see that side being "dark" - you know, money talks :-)

Do not forget - it's Friday in a couple of hours.

Steen Rasmussen
CA technologies


________________________________

From: IDUG DB2-L on behalf of McDonald, Ken
Sent: Tue 2/8/2011 9:12 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Recovery topic



Wayne, the utility is C+\Modify. Call BMC Support... they're on call to help for these type situations too, not just for product problems.

Ken

p.s. Steen, come on over to the dark side!

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Rasmussen, Steen
Sent: Tuesday, February 08, 2011 7:06 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Recovery topic

I am sure BMC has a utility (MODIFY+ perhaps) like CA has which can insert into SYSCOPY - as long as you have the image copy dataset name handy - or you can use a log tool to see what the name was doing UNDO analysis. If you have their UNLOAD+, I believe you also can unload.

Sorry BMC if I missed some of your features :-)

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified database Administrator - DB2 9 DBA for z/OS



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Wayne Lam
Sent: Tuesday, February 08, 2011 6:52 PM
To: [login to unmask email]
Subject: [DB2-L] Recovery topic

I need to restore a set of DB2 tables in our Test DB2 region with the FULL image copies from BMC COPY+, but the entries in the SYSCOPY were removed by the MODIFY RECOVERY utility. Is there any way that I can re-register the image copy datasets into SYSCOPY? If not, I have to use DSN1COPY to restore them, then do I need to use the RESET option?

Thanks,

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv



_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Wayne Lam

Re: Recovery topic
(in response to Steen Rasmussen)
Thanks, Ken. I got it.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv