DB2 RECOVERY SCENARIO - ZOS DB2 V7

Steve Neff

DB2 RECOVERY SCENARIO - ZOS DB2 V7
Hello,

I have two zcenarios that I am trying to understand for recovering a
table in a tablespace.

Scenario I

Load replace of table in tablespace - one table in tablespace.
IMAGE COPY after LOAD
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a recover to rba or larsn?

SCENARIO II

Load replace of table in tablespace - one table in tablespace.
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a log apply recover to rba
or larsn?


Thank you

Steve

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

William Proctor

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Steve Neff)
If your wanting to undo what was done in the batch process then you need
to put the Quiesce before the start of the batch job and then you can
recover to the quiesce RBA point and undo the batch processing.



Bill Proctor

Database Administrator (Adabas/DB2)

DB2 UDB V7.1 Database Administration for OS/390

Texas Guaranteed Student Loan Corp.

Austin, Texas

Phone: 512-219-4847





-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Neff Stephen R
Sent: Monday, January 09, 2006 9:30 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7



Hello,

I have two zcenarios that I am trying to understand for
recovering a table in a tablespace.

Scenario I

Load replace of table in tablespace - one table in tablespace.
IMAGE COPY after LOAD
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a recover to rba or
larsn?

SCENARIO II

Load replace of table in tablespace - one table in tablespace.
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a log apply recover to
rba or larsn?



Thank you

Steve

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

Phil Grainger

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to William Proctor)
Steve

The terms RBA and LRSN are designed to confuse as they (nearly) mean the
same thing!

If you are NOT running DB2 datasharing, then you will only ever have to
worry about RBAs (a log RBA is an ever ascending number that defines a
point in a serial log dataset)

If you ARE running datasharing, then you only have to worry about LRSNs.
An LRSN is an ever ascending number indicating a point in a SET of log
datasets that all span the same period of time (such as in a data
sharing group).

So, to answer BOTH your questions :

To recover back to your quiesce points (both of them) you will do EITHER
a RECOVER TORBA or RECOVER TOLRSN (depending on whether you are
datasharing or not)

Hope this helps


Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Neff Stephen R
Sent: 09 January 2006 15:30
To: [login to unmask email]
Subject: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7



Hello,

I have two zcenarios that I am trying to understand for
recovering a table in a tablespace.

Scenario I

Load replace of table in tablespace - one table in tablespace.
IMAGE COPY after LOAD
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a recover to rba or
larsn?

SCENARIO II

Load replace of table in tablespace - one table in tablespace.
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a log apply recover to
rba or larsn?


Thank you

Steve

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

Steve Neff

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Phil Grainger)
Thank You, But I do not want to undo what was done. I would like to recover
to what has been done up to the Quiesce
The second replace of the table was not suppose to happen.

thanks

Steve

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Proctor, William
Sent: Monday, January 09, 2006 10:33 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7



If your wanting to undo what was done in the batch process then you need to
put the Quiesce before the start of the batch job and then you can recover
to the quiesce RBA point and undo the batch processing.



Bill Proctor

Database Administrator (Adabas/DB2)

DB2 UDB V7.1 Database Administration for OS/390

Texas Guaranteed Student Loan Corp.

Austin, Texas

Phone: 512-219-4847





-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Neff Stephen R
Sent: Monday, January 09, 2006 9:30 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7



Hello,

I have two zcenarios that I am trying to understand for recovering a
table in a tablespace.

Scenario I

Load replace of table in tablespace - one table in tablespace.
IMAGE COPY after LOAD
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a recover to rba or larsn?


SCENARIO II

Load replace of table in tablespace - one table in tablespace.
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a log apply recover to rba
or larsn?



Thank you

Steve

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


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

Steven Lamb

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Steve Neff)
Steve,

For the Load Replace in scenario 2, would you be specifying NOCOPYPEND in
the Load job, or would you be having a copy after the Load has finished to
reset the Copy Pending flag?

STeve

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

Steve Neff

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Steve Neff)
? On SCENARION II. If no image copy exist how does DB2 no where to start? If
DB2 applies log changes only and encounters a load replace does it continue
to apply log changes after the load replace?

thank you

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Grainger, Phil
Sent: Monday, January 09, 2006 10:50 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7


Steve

The terms RBA and LRSN are designed to confuse as they (nearly) mean the
same thing!

If you are NOT running DB2 datasharing, then you will only ever have to
worry about RBAs (a log RBA is an ever ascending number that defines a point
in a serial log dataset)

If you ARE running datasharing, then you only have to worry about LRSNs. An
LRSN is an ever ascending number indicating a point in a SET of log datasets
that all span the same period of time (such as in a data sharing group).

So, to answer BOTH your questions :

To recover back to your quiesce points (both of them) you will do EITHER a
RECOVER TORBA or RECOVER TOLRSN (depending on whether you are datasharing or
not)

Hope this helps


Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Neff Stephen R
Sent: 09 January 2006 15:30
To: [login to unmask email]
Subject: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7



Hello,

I have two zcenarios that I am trying to understand for recovering a
table in a tablespace.

Scenario I

Load replace of table in tablespace - one table in tablespace.
IMAGE COPY after LOAD
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a recover to rba or larsn?


SCENARIO II

Load replace of table in tablespace - one table in tablespace.
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a log apply recover to rba
or larsn?


Thank you

Steve

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


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

Moschelli Mauro

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Steven Lamb)
Hi
Scenario II is not recoverable because no image copy exists.
But after first LOAD tablespace become COPY PENDING so no updates are allowed until an image copy is taken.
Unless you run REPAIR TABLESPACE ... NOCOPYPEND, in which case you can update but tablespace is STILL NOT RECOVERABLE.

HTH



Mauro Moschelli
SanPaoloIMI S.p.A.

Direzione Macchina Operativa Integrata
Sistemi Centrali - Database
C.so Savona 58 - 10024 Moncalieri (TO)

Phone : +39 011 555.5809
E-mail : [login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Neff Stephen R
Sent: Monday, January 09, 2006 4:57 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7


? On SCENARION II. If no image copy exist how does DB2 no where to start? If DB2 applies log changes only and encounters a load replace does it continue to apply log changes after the load replace?

thank you

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Grainger, Phil
Sent: Monday, January 09, 2006 10:50 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7


Steve

The terms RBA and LRSN are designed to confuse as they (nearly) mean the same thing!

If you are NOT running DB2 datasharing, then you will only ever have to worry about RBAs (a log RBA is an ever ascending number that defines a point in a serial log dataset)

If you ARE running datasharing, then you only have to worry about LRSNs. An LRSN is an ever ascending number indicating a point in a SET of log datasets that all span the same period of time (such as in a data sharing group).

So, to answer BOTH your questions :

To recover back to your quiesce points (both of them) you will do EITHER a RECOVER TORBA or RECOVER TOLRSN (depending on whether you are datasharing or not)

Hope this helps


Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Neff Stephen R
Sent: 09 January 2006 15:30
To: [login to unmask email]
Subject: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7



Hello,

I have two zcenarios that I am trying to understand for recovering a table in a tablespace.

Scenario I

Load replace of table in tablespace - one table in tablespace.
IMAGE COPY after LOAD
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a recover to rba or larsn?

SCENARIO II

Load replace of table in tablespace - one table in tablespace.
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a log apply recover to rba or larsn?


Thank you

Steve

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

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

Il contenuto e gli allegati di questo messaggio sono strettamente
confidenziali, e ne sono vietati la diffusione e l'uso non autorizzato.

Le opinioni ivi eventualmente espresse sono quelle dell'autore: di
conseguenza il messaggio non costituisce impegno contrattuale tra
il Gruppo Sanpaolo ed il destinatario, e la banca non assume alcuna
responsabilita' riguardo ai contenuti del testo e dei relativi allegati,
ne' per eventuali intercettazioni, modifiche o danneggiamenti.

Qualora il presente messaggio Le fosse pervenuto per errore, Le saremmo
grati se lo distruggesse e, via e-mail, ce ne comunicasse l' errata
ricezione all'indirizzo [login to unmask email]


This e-mail (and any attachment(s)) is strictly confidential and for use
only by intended recipient(s). Any opinions therein expressed are those
of the author. Therefore its content doesn't represent any commitment
between Sanpaolo Group and the recipient(s) and no liability or
responsibility is accepted by Sanpaolo Group for the above mentioned
content.

Sanpaolo IMI S.p.A. is a Bank authorised by Banca d'Italia; Sanpaolo IMI
S.p.A., London Branch, is regulated by the Financial Services Authority
for the conduct of investment business in the UK.

If you are not an intended recipient(s), please notify
[login to unmask email] promptly and destroy this message.

Avram Friedman

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Moschelli Mauro)
You can ofcourse recover the tape to any PIT you choose.
Things are usually not this simple however.

Is there any DB2 RI?
Is there any application enforced RI (actually far more difficult to deal with than DB2 RI)?
How are you going to restrict acess to the table after the load to just your test case?

Neff Stephen R <[login to unmask email]> wrote:
Hello,
I have two zcenarios that I am trying to understand for recovering a table in a tablespace.
Scenario I
Load replace of table in tablespace - one table in tablespace.
IMAGE COPY after LOAD
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.
Would like to recover to Quiesce. Is this a recover to rba or larsn?
SCENARIO II
Load replace of table in tablespace - one table in tablespace.
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.
Would like to recover to Quiesce. Is this a log apply recover to rba or larsn?

Thank you
Steve
--------------------------------------------------------------------------------- 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



Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




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

Joan Keemle

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Avram Friedman)
Steve, in Scenario II:
Has an image copy ever been taken? Is it still available? Are logs
available since that time of image copy?
Did the first LOAD utility specify LOG NO or LOG YES?

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Neff Stephen R
Sent: Monday, January 09, 2006 9:52 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7


Thank You, But I do not want to undo what was done. I would like to
recover to what has been done up to the Quiesce
The second replace of the table was not suppose to happen.

thanks

Steve

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Proctor, William
Sent: Monday, January 09, 2006 10:33 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7



If your wanting to undo what was done in the batch process then
you need to put the Quiesce before the start of the batch job and then
you can recover to the quiesce RBA point and undo the batch processing.



Bill Proctor

Database Administrator (Adabas/DB2)

DB2 UDB V7.1 Database Administration for OS/390

Texas Guaranteed Student Loan Corp.

Austin, Texas

Phone: 512-219-4847





-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Neff Stephen R
Sent: Monday, January 09, 2006 9:30 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7



Hello,

I have two zcenarios that I am trying to understand for
recovering a table in a tablespace.

Scenario I

Load replace of table in tablespace - one table in
tablespace.
IMAGE COPY after LOAD
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a recover to
rba or larsn?

SCENARIO II

Load replace of table in tablespace - one table in
tablespace.
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a log apply
recover to rba or larsn?



Thank you

Steve


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

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

Steve Neff

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Joan Keemle)
An image copy is not availabel in SCENARIO II. The load has LOG NO.

Thanks

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Keemle Joan T
Sent: Monday, January 09, 2006 11:08 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7


Steve, in Scenario II:
Has an image copy ever been taken? Is it still available? Are logs
available since that time of image copy?
Did the first LOAD utility specify LOG NO or LOG YES?

_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Neff Stephen R
Sent: Monday, January 09, 2006 9:52 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7


Thank You, But I do not want to undo what was done. I would like to recover
to what has been done up to the Quiesce
The second replace of the table was not suppose to happen.

thanks

Steve

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Proctor, William
Sent: Monday, January 09, 2006 10:33 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7



If your wanting to undo what was done in the batch process then you need to
put the Quiesce before the start of the batch job and then you can recover
to the quiesce RBA point and undo the batch processing.



Bill Proctor

Database Administrator (Adabas/DB2)

DB2 UDB V7.1 Database Administration for OS/390

Texas Guaranteed Student Loan Corp.

Austin, Texas

Phone: 512-219-4847





-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Neff Stephen R
Sent: Monday, January 09, 2006 9:30 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7



Hello,

I have two zcenarios that I am trying to understand for recovering a
table in a tablespace.

Scenario I

Load replace of table in tablespace - one table in tablespace.
IMAGE COPY after LOAD
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a recover to rba or larsn?


SCENARIO II

Load replace of table in tablespace - one table in tablespace.
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a log apply recover to rba
or larsn?



Thank you

Steve

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

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


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

Steve Neff

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Steve Neff)
Hello, The load replace has nocopypend. There are no RI issues. Looking in
the uitlity guide I believe SCENARIO II is possible. I would load the
original data back and then do a logapply to the Quiesce.

Here is what the utility guide states

LOGONLY Recovers the target objects from their existing data sets by
applying only log records to the data sets. DB2 applies all
log records that were written after a point that is recorded
in the data set itself.

Use the LOGONLY option when the data sets of the target
objects have already been restored to a point of consistency
by another process offline, such as DFSMS Concurrent Copy.

Thanks

Steve

-----Original Message-----
From: Neff Stephen R
Sent: Monday, January 09, 2006 10:30 AM
To: 'DB2 Database Discussion list at IDUG'
Subject: DB2 RECOVERY SCENARIO - ZOS DB2 V7


Hello,

I have two zcenarios that I am trying to understand for recovering a
table in a tablespace.

Scenario I

Load replace of table in tablespace - one table in tablespace.
IMAGE COPY after LOAD
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a recover to rba or larsn?

SCENARIO II

Load replace of table in tablespace - one table in tablespace.
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a log apply recover to rba
or larsn?


Thank you

Steve

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

Phil Grainger

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Steve Neff)
If DB2 encounters ANY LOG NO utility, then it cannot recover across that
point

If there are no image copies available then it is sometimes possible for
DB2 to find the point where the table was created and use THAT as a
recovery start point, but this tends only to be possible when tables are
new(ish) and archive logs are kept lying around.

In your case, for scenario 2, it looks like you will have to rerun the
FIRST LOAD REPLACE and then use a third part tool to repeat the
processing performed by your batch job, or do some sort of (non-IBM)
logonly recovery with a third party tool that lets you specify a FROM
RBA as well as a TO RBA

Do you own any CA tools? If so, give our support people a call if this
is production data. We seem to be getting a reputation for rescuing
peoples data this week!


Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Neff Stephen R
Sent: 09 January 2006 15:57
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7


? On SCENARION II. If no image copy exist how does DB2 no where to
start? If DB2 applies log changes only and encounters a load replace
does it continue to apply log changes after the load replace?

thank you

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Grainger, Phil
Sent: Monday, January 09, 2006 10:50 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7


Steve

The terms RBA and LRSN are designed to confuse as they (nearly)
mean the same thing!

If you are NOT running DB2 datasharing, then you will only ever
have to worry about RBAs (a log RBA is an ever ascending number that
defines a point in a serial log dataset)

If you ARE running datasharing, then you only have to worry
about LRSNs. An LRSN is an ever ascending number indicating a point in a
SET of log datasets that all span the same period of time (such as in a
data sharing group).

So, to answer BOTH your questions :

To recover back to your quiesce points (both of them) you will
do EITHER a RECOVER TORBA or RECOVER TOLRSN (depending on whether you
are datasharing or not)

Hope this helps


Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Neff Stephen R
Sent: 09 January 2006 15:30
To: [login to unmask email]
Subject: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7



Hello,

I have two zcenarios that I am trying to understand for
recovering a table in a tablespace.

Scenario I

Load replace of table in tablespace - one table in
tablespace.
IMAGE COPY after LOAD
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a recover to
rba or larsn?

SCENARIO II

Load replace of table in tablespace - one table in
tablespace.
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a log apply
recover to rba or larsn?


Thank you

Steve


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

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

[login to unmask email]

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Phil Grainger)
To automate the recovery process you may wish to
visit:www.recoveryknowledge.com


Lee

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

Phil Grainger

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to DB2information@AOL.COM)


So the question remains, if there was NO image copy and the load was LOG
NO, then how was the COPY PENDING flag removed??

Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]




________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Neff Stephen R
Sent: 09 January 2006 16:20
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7


An image copy is not availabel in SCENARIO II. The load has LOG NO.

Thanks

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Keemle Joan T
Sent: Monday, January 09, 2006 11:08 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7


Steve, in Scenario II:
Has an image copy ever been taken? Is it still available? Are
logs available since that time of image copy?
Did the first LOAD utility specify LOG NO or LOG YES?



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

Phil Grainger

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Phil Grainger)
The problem is you are NOT recovering the data using an "offline
process" - you are replacing one set of data with another using an
online process (the LOAD utility)

The IBM logonly recovery uses an internal field to determine the "from
RBA" of the recovery. This is why you would have to use a third-party
(CA or BMC) logonly recovery where you could manually specify the "from
RBA"

Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Neff Stephen R
Sent: 09 January 2006 16:27
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7



Hello, The load replace has nocopypend. There are no RI issues. Looking
in the uitlity guide I believe SCENARIO II is possible. I would load the
original data back and then do a logapply to the Quiesce.

Here is what the utility guide states

LOGONLY Recovers the target objects from their existing data sets by

applying only log records to the data sets. DB2 applies all

log records that were written after a point that is recorded

in the data set itself.



Use the LOGONLY option when the data sets of the target

objects have already been restored to a point of consistency

by another process offline, such as DFSMS Concurrent Copy.



Thanks

Steve

-----Original Message-----
From: Neff Stephen R
Sent: Monday, January 09, 2006 10:30 AM
To: 'DB2 Database Discussion list at IDUG'
Subject: DB2 RECOVERY SCENARIO - ZOS DB2 V7


Hello,

I have two zcenarios that I am trying to understand for
recovering a table in a tablespace.

Scenario I

Load replace of table in tablespace - one table in tablespace.
IMAGE COPY after LOAD
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a recover to rba or
larsn?

SCENARIO II

Load replace of table in tablespace - one table in tablespace.
batch processing where table in tablespace is changed.
Quiesce
Load replace of same table in tablespace again.

Would like to recover to Quiesce. Is this a log apply recover to
rba or larsn?


Thank you

Steve

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

Steve Neff

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Phil Grainger)
The load has nocopypending as one of the parameters.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Grainger, Phil
Sent: Monday, January 09, 2006 1:29 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7




So the question remains, if there was NO image copy and the load was LOG NO,
then how was the COPY PENDING flag removed??

Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]




_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Neff Stephen R
Sent: 09 January 2006 16:20
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7


An image copy is not availabel in SCENARIO II. The load has LOG NO.

Thanks

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Keemle Joan T
Sent: Monday, January 09, 2006 11:08 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7


Steve, in Scenario II:
Has an image copy ever been taken? Is it still available? Are logs
available since that time of image copy?
Did the first LOAD utility specify LOG NO or LOG YES?


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

Cristian Molaro

Re: DB2 RECOVERY SCENARIO - ZOS DB2 V7
(in response to Steve Neff)
Hi,

Another option is to recover TOLOGPOINT X'byte-string'. In that case, you
can specify either an RBA or an LRSN value...

Regards,
Cristian Molaro
MConsulting.be
Belgium


On Mon, 9 Jan 2006 15:49:51 -0000, Grainger, Phil <[login to unmask email]> wrote:

>Steve
>
>The terms RBA and LRSN are designed to confuse as they (nearly) mean the
>same thing!
>
>If you are NOT running DB2 datasharing, then you will only ever have to
>worry about RBAs (a log RBA is an ever ascending number that defines a
>point in a serial log dataset)
>
>If you ARE running datasharing, then you only have to worry about LRSNs.
>An LRSN is an ever ascending number indicating a point in a SET of log
>datasets that all span the same period of time (such as in a data
>sharing group).
>
>So, to answer BOTH your questions :
>
>To recover back to your quiesce points (both of them) you will do EITHER
>a RECOVER TORBA or RECOVER TOLRSN (depending on whether you are
>datasharing or not)
>
>Hope this helps
>
>
>Phil Grainger
>CA
>Product Manager, DB2
>Tel: +44 (0)161 928 9334
>Fax: +44 (0)161 941 3775
>Mobile: +44 (0)7970 125 752
>[login to unmask email]
>
>
>
>________________________________
>
>From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
>Behalf Of Neff Stephen R
>Sent: 09 January 2006 15:30
>To: [login to unmask email]
>Subject: [DB2-L] DB2 RECOVERY SCENARIO - ZOS DB2 V7
>
>
>
>Hello,
>
> I have two zcenarios that I am trying to understand for
>recovering a table in a tablespace.
>
>Scenario I
>
> Load replace of table in tablespace - one table in tablespace.
> IMAGE COPY after LOAD
> batch processing where table in tablespace is changed.
> Quiesce
> Load replace of same table in tablespace again.
>
> Would like to recover to Quiesce. Is this a recover to rba or
>larsn?
>
>SCENARIO II
>
> Load replace of table in tablespace - one table in tablespace.
> batch processing where table in tablespace is changed.
> Quiesce
> Load replace of same table in tablespace again.
>
> Would like to recover to Quiesce. Is this a log apply recover to
>rba or larsn?
>
>
>Thank you
>
>Steve
>
>------------------------------------------------------------------------
>--------- 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
>

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