DB2 z/OS DB2 8 RECOVERY QUESTION

Steve Neff

DB2 z/OS DB2 8 RECOVERY QUESTION
Hello, We have deleted from the syscopy an image copy that we would now
like to use to recover with. My question is if the image copy no longer
exist in the syscopy can you use the IBM RECOVER utility? I saw where
you can preallocate copy data set in the documentation but have not
found an example of this. Even if you do so will the RECOVER utility
work?


thanks

Steve Neff

______________________________________________________________________

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



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Philip Sevetson

Re: DB2 z/OS DB2 8 RECOVERY QUESTION
(in response to Steve Neff)
I take it that when you say "the image copy no longer exists in the
SYSCOPY table", you mean that you have run MODIFY RECOVERY and
eliminated history that includes your desired image copy.



If it's an image copy taken with SHRLEVEL NONE or SHRLEVEL REFERENCE,
you can use it as the source for an UNLOAD, then LOAD the target data.
Alternately, if it's a copy of a single dataset, you can use DSN1COPY to
overlay the tablespace with the old copy, then do an immediate REORG
(this last is risky if you've ALTERed the table since the image copy was
taken).



But just a RECOVER won't work for you, because DB2 relies on information
in the SYSCOPY and SYSLGRNX tables to do a RECOVER, and you've deleted
that information.



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Neff Stephen R
Sent: Thursday, December 11, 2008 10:00 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS DB2 8 RECOVERY QUESTION



Hello, We have deleted from the syscopy an image copy that we would now
like to use to recover with. My question is if the image copy no longer
exist in the syscopy can you use the IBM RECOVER utility? I saw where
you can preallocate copy data set in the documentation but have not
found an example of this. Even if you do so will the RECOVER utility
work?





thanks



Steve Neff


________________________________

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

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >



=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========



______________________________________________________________________

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



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Raymond Bell

Re: DB2 z/OS DB2 8 RECOVERY QUESTION
(in response to Philip Sevetson)
Or, if you have the right tools, you could insert an entry into Syscopy
with the details of the missing image copy and then IBM Recover would be
happy. Or you could use a clever Recover utility to specify an input
image copy dataset that's not registered in Syscopy. So, depending on
what tools you've got, you might still be able to use the IC.



Cheers,





Raymond



From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Sevetson, Phil
Sent: 11 December 2008 15:48
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS DB2 8 RECOVERY QUESTION



I take it that when you say "the image copy no longer exists in the
SYSCOPY table", you mean that you have run MODIFY RECOVERY and
eliminated history that includes your desired image copy.



If it's an image copy taken with SHRLEVEL NONE or SHRLEVEL REFERENCE,
you can use it as the source for an UNLOAD, then LOAD the target data.
Alternately, if it's a copy of a single dataset, you can use DSN1COPY to
overlay the tablespace with the old copy, then do an immediate REORG
(this last is risky if you've ALTERed the table since the image copy was
taken).



But just a RECOVER won't work for you, because DB2 relies on information
in the SYSCOPY and SYSLGRNX tables to do a RECOVER, and you've deleted
that information.



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Neff Stephen R
Sent: Thursday, December 11, 2008 10:00 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS DB2 8 RECOVERY QUESTION



Hello, We have deleted from the syscopy an image copy that we would now
like to use to recover with. My question is if the image copy no longer
exist in the syscopy can you use the IBM RECOVER utility? I saw where
you can preallocate copy data set in the documentation but have not
found an example of this. Even if you do so will the RECOVER utility
work?





thanks



Steve Neff

________________________________

=========
Confidentiality Notice: This e-mail communication, and any attachments,
contains confidential and privileged information for the exclusive use
of the recipient(s) named above. If you are not an intended recipient,
or the employee or agent responsible to deliver it to an intended
recipient, you are hereby notified that you have received this
communication in error and that any review, disclosure, dissemination,
distribution or copying of it or its contents is prohibited. If you have
received this communication in error, please notify me immediately by
replying to this message and delete this communication from your
computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the
author and do not necessarily represent the opinions of the agency or
the City.
=========



________________________________

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

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >



________________________________

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

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >


______________________________________________________________________

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



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Phil Grainger

Re: DB2 z/OS DB2 8 RECOVERY QUESTION
(in response to Raymond Bell)
There are ways to reinsert accidentally deleted rows back into SYSCOPY
(CA Merge/Modify being one, I think BMC also have a similar solution)



Without that though, you are stuck with either DSN1COPY or Unload - IBM
Recover will not use ANY image copy that is not registered in SYSCOPY



Phil Grainger

CA

Senior Principal Product Manager

Phone: +44 (0)1753 577 733

Mobile: +44 (0)7970 125 752

eMail: [login to unmask email]



Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL



CA plc a company registered in England and Wales under company
registration number 1282495 with its registered office at the address
set out above. VAT number 697904179.



From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Sevetson, Phil
Sent: 11 December 2008 15:48
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS DB2 8 RECOVERY QUESTION



I take it that when you say "the image copy no longer exists in the
SYSCOPY table", you mean that you have run MODIFY RECOVERY and
eliminated history that includes your desired image copy.



If it's an image copy taken with SHRLEVEL NONE or SHRLEVEL REFERENCE,
you can use it as the source for an UNLOAD, then LOAD the target data.
Alternately, if it's a copy of a single dataset, you can use DSN1COPY to
overlay the tablespace with the old copy, then do an immediate REORG
(this last is risky if you've ALTERed the table since the image copy was
taken).



But just a RECOVER won't work for you, because DB2 relies on information
in the SYSCOPY and SYSLGRNX tables to do a RECOVER, and you've deleted
that information.



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Neff Stephen R
Sent: Thursday, December 11, 2008 10:00 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS DB2 8 RECOVERY QUESTION



Hello, We have deleted from the syscopy an image copy that we would now
like to use to recover with. My question is if the image copy no longer
exist in the syscopy can you use the IBM RECOVER utility? I saw where
you can preallocate copy data set in the documentation but have not
found an example of this. Even if you do so will the RECOVER utility
work?





thanks



Steve Neff

________________________________

=========
Confidentiality Notice: This e-mail communication, and any attachments,
contains confidential and privileged information for the exclusive use
of the recipient(s) named above. If you are not an intended recipient,
or the employee or agent responsible to deliver it to an intended
recipient, you are hereby notified that you have received this
communication in error and that any review, disclosure, dissemination,
distribution or copying of it or its contents is prohibited. If you have
received this communication in error, please notify me immediately by
replying to this message and delete this communication from your
computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the
author and do not necessarily represent the opinions of the agency or
the City.
=========



________________________________

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

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >



________________________________

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

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >


______________________________________________________________________

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



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Michael Bruzdzinski

Re: DB2 z/OS DB2 8 RECOVERY QUESTION
(in response to Phil Grainger)
I think you best bet would be to use DSN1COPY at this point.


Michael Bruzdzinski

Social Security Administration

DCS/OESAE/DDBS/DBSB

410-966-7185




________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Neff Stephen R
Sent: Thursday, December 11, 2008 10:00 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS DB2 8 RECOVERY QUESTION


Hello, We have deleted from the syscopy an image copy that we
would now like to use to recover with. My question is if the image copy
no longer exist in the syscopy can you use the IBM RECOVER utility? I
saw where you can preallocate copy data set in the documentation but
have not found an example of this. Even if you do so will the RECOVER
utility work?


thanks

Steve Neff

________________________________


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

The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >


______________________________________________________________________

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



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms