how can i redo ,with logonly

leila rahimi

how can i redo ,with logonly
Hi list,
i have a test with logonly recovery option,,,,but i can't earn a result that
i want,,,,,please tell me,is my test correct......
1-start my tablespace in read only
2-run quieses in tablespace
3-take a backup full
4-read/writ start tablespace
5-change one table in that tablespace and add 2 rows to it
6-restore backup full
7-in this state i lose my 2 records,then i expect if u use recover with
logonly option i'll have 2 records again then:
8-start table space with access(ut)
9-recover with logonly
10-but there is no more records,,,,and i have lose 2 records....
i thought i could use logonly option for REDO,,but i don't know how can i
REDO...
if i have a back up of data ,i want to restore more information,that changed
after that back up,(for about 3 hours) how can i earn that?
thanks a lot..
leila

_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com



Michael Kaplan

Re: how can i redo ,with logonly
(in response to leila rahimi)
Hi Leila,

Just to be sure, because you didn't mention it :
whether adding 2 records in step 5 were commited ?

Michael Kaplan
DBA
E-mail : [login to unmask email]
Mobile phone : 058-525276




-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
leila rahimi
Sent: Tuesday, December 25, 2001 5:00 PM
To: [login to unmask email]
Subject: how can i redo ,with logonly


Hi list,
i have a test with logonly recovery option,,,,but i can't earn a result that
i want,,,,,please tell me,is my test correct......
1-start my tablespace in read only
2-run quieses in tablespace
3-take a backup full
4-read/writ start tablespace
5-change one table in that tablespace and add 2 rows to it
6-restore backup full
7-in this state i lose my 2 records,then i expect if u use recover with
logonly option i'll have 2 records again then:
8-start table space with access(ut)
9-recover with logonly
10-but there is no more records,,,,and i have lose 2 records....
i thought i could use logonly option for REDO,,but i don't know how can i
REDO...
if i have a back up of data ,i want to restore more information,that changed
after that back up,(for about 3 hours) how can i earn that?
thanks a lot..
leila

_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com








James Campbell

Re: how can i redo ,with logonly
(in response to Michael Kaplan)
How did you "restore" in step 6?

What happens is that DB2 keeps track (in the page header) of the
RBA (LRSN in data sharing) at which the page was last updated.
When a LOGONLY recovery is done DB2 uses this to determine
the begining range of the range of log records for which updates will
be applied to the page.

There are, basically, two ways of doing a "restore"
- DB2 RECOVER. This will reset all these page header RBAs to
the RBA at the time of the recover
- DSN1COPY. This will leave the page header RBAs as they were
at the time of the backup.

As you can readily see, if you use DB2 RECOVER FROMCOPY
followed by a RECOVER LOGONLY, DB2 will be using the RBA
current at the RECOVER FROMCOPY as the starting point. This
is why there is a note in the Utility Guide "[u]se 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."

James Campbell

On 25 Dec 2001, at 15:59, leila rahimi wrote:

Date sent: Tue, 25 Dec 2001 15:59:53 +0000
Send reply to: DB2 Data Base Discussion List <[login to unmask email]>
From: leila rahimi <[login to unmask email]>
Subject: [DB2-L] how can i redo ,with logonly
To: [login to unmask email]

> Hi list,
> i have a test with logonly recovery option,,,,but i can't earn a result that
> i want,,,,,please tell me,is my test correct......
> 1-start my tablespace in read only
> 2-run quieses in tablespace
> 3-take a backup full
> 4-read/writ start tablespace
> 5-change one table in that tablespace and add 2 rows to it
> 6-restore backup full
> 7-in this state i lose my 2 records,then i expect if u use recover with
> logonly option i'll have 2 records again then:
> 8-start table space with access(ut)
> 9-recover with logonly
> 10-but there is no more records,,,,and i have lose 2 records....
> i thought i could use logonly option for REDO,,but i don't know how can i
> REDO...
> if i have a back up of data ,i want to restore more information,that changed
> after that back up,(for about 3 hours) how can i earn that?
> thanks a lot..
> leila
>
> _________________________________________________________________
> Join the world’s largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
>
>
> the DB2-L webpage at htt
p://www.ryci.com/db2-l. The owners of the list can


James A Campbell



leila rahimi

Re: how can i redo ,with logonly
(in response to James Campbell)
hi Michael
yes,i'm sure that it is commited,i have do this test several times,after
step 5,i have ran a query and i could see that 2 records....in addition,i
have used DSN1COPY, and DFDSS ,for full backups,and then used logonly,,,in
some tests the number of records that i added was about 1000000 ,and i was
sure that they had added,in table..and surely buffer thereshold happend.but
result of use of logonly ,was same....
if my test is incorrect,please guide me.
thanks..
leila.
>From: Michael Kaplan <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: how can i redo ,with logonly
>Date: Tue, 25 Dec 2001 20:52:08 +0100
>
>Hi Leila,
>
>Just to be sure, because you didn't mention it :
>whether adding 2 records in step 5 were commited ?
>
>Michael Kaplan
>DBA
>E-mail : [login to unmask email]
>Mobile phone : 058-525276
>
>
>
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
>leila rahimi
>Sent: Tuesday, December 25, 2001 5:00 PM
>To: [login to unmask email]
>Subject: how can i redo ,with logonly
>
>
>Hi list,
>i have a test with logonly recovery option,,,,but i can't earn a result
>that
>i want,,,,,please tell me,is my test correct......
>1-start my tablespace in read only
>2-run quieses in tablespace
>3-take a backup full
>4-read/writ start tablespace
>5-change one table in that tablespace and add 2 rows to it
>6-restore backup full
>7-in this state i lose my 2 records,then i expect if u use recover with
>logonly option i'll have 2 records again then:
>8-start table space with access(ut)
>9-recover with logonly
>10-but there is no more records,,,,and i have lose 2 records....
>i thought i could use logonly option for REDO,,but i don't know how can i
>REDO...
>if i have a back up of data ,i want to restore more information,that
>changed
>after that back up,(for about 3 hours) how can i earn that?
>thanks a lot..
>leila
>
>_________________________________________________________________
>Join the world’s largest e-mail service with MSN Hotmail.
>http://www.hotmail.com
>
>
>
>the
>
>
>
>
>
>
>


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.



James Campbell

Re: how can i redo ,with logonly
(in response to leila rahimi)
Leila

When you did the recover logonly, did you
- recover to current (ie did not use TORBA); or
- recovered to a point in time (ie you did use TORBA)? If so, what
RBA did you use?

The correct answer is "TORBA(just before restore)"

James Campbell
On 26 Dec 2001, at 11:14, leila rahimi wrote:

Date sent: Wed, 26 Dec 2001 11:14:51 +0000
Send reply to: DB2 Data Base Discussion List <[login to unmask email]>
From: leila rahimi <[login to unmask email]>
Subject: Re: [DB2-L] how can i redo ,with logonly
To: [login to unmask email]

> hi Michael
> yes,i'm sure that it is commited,i have do this test several times,after
> step 5,i have ran a query and i could see that 2 records....in addition,i
> have used DSN1COPY, and DFDSS ,for full backups,and then used logonly,,,in
> some tests the number of records that i added was about 1000000 ,and i was
> sure that they had added,in table..and surely buffer thereshold happend.but
> result of use of logonly ,was same....
> if my test is incorrect,please guide me.
> thanks..
> leila.
> >From: Michael Kaplan <[login to unmask email]>
> >Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
> >To: [login to unmask email]
> >Subject: Re: how can i redo ,with logonly
> >Date: Tue, 25 Dec 2001 20:52:08 +0100
> >
> >Hi Leila,
> >
> >Just to be sure, because you didn't mention it :
> >whether adding 2 records in step 5 were commited ?
> >
> >Michael Kaplan
> >DBA
> >E-mail : [login to unmask email]
> >Mobile phone : 058-525276
> >
> >
> >
> >
> >-----Original Message-----
> >From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
> >leila rahimi
> >Sent: Tuesday, December 25, 2001 5:00 PM
> >To: [login to unmask email]
> >Subject: how can i redo ,with logonly
> >
> >
> >Hi list,
> >i have a test with logonly recovery option,,,,but i can't earn a result
> >that
> >i want,,,,,please tell me,is my test correct......
> >1-start my tablespace in read only
> >2-run quieses in tablespace
> >3-take a backup full
> >4-read/writ start tablespace
> >5-change one table in that tablespace and add 2 rows to it
> >6-restore backup full
> >7-in this state i lose my 2 records,then i expect if u use recover with
> >logonly option i'll have 2 records again then:
> >8-start table space with access(ut)
> >9-recover with logonly
> >10-but there is no more records,,,,and i have lose 2 records....
> >i thought i could use logonly option for REDO,,but i don't know how can i
> >REDO...
> >if i have a back up of data ,i want to restore more information,that
> >changed
> >after that back up,(for about 3 hours) how can i earn that?
> >thanks a lot..
> >leila
> >
> >_________________________________________________________________
> >Join the world’s largest e-mail service with MSN Hotmail.
> >http://www.hotmail.com
> >
> >
> > visit
> >the
> >
> >
> >
> >
> > visit
> >
> >
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
>
>
> the DB2-L webpage at htt
p://www.ryci.com/db2-l. The owners of the list can


James A Campbell