MVSFORUMS.com

LEO · Posted: Sun Jan 21, 2007 3:39 pm Post subject: Recover Tablespace issue

Hi,

I have taken Imagecopy of the tablespace , it went thru fine. After that I did some deletions on the underlying tables in tablespace and commited the changes. But I want to restore the tables to initial state.

so I ran the recover utility to recover tablespace, it also ran fine. But the deleted rows does not appear after the recovery .

I have used simple statement : RECOVER DB.TS USING IBM ULTILITY.

PLEASE ADVISE on why I am not able to recover the deleted rows ?

Thanks

kolusu · Posted: Sun Jan 21, 2007 11:19 pm Post subject:

LEO,

On your Recover statement you forgot to mention the option TOLASTCOPY /TOLASTFULLCOPY. You need to specify that to recover to the last image copy taken.

Check this link for a detailed explanation of the RECOVER utitlity with detailed explanation.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH13/2.19?DT=20020826194002

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

LEO · Posted: Mon Jan 22, 2007 11:14 am Post subject:

Thanks Kolusu, it worked with TOLASTFULLCOPY.

But I have another doubt related to this - the above link also mentions the below example :

Example 1: Recovering a table space. The following control statement specifies that the RECOVER utility is to recover table space DSN8D81A.DSN8S81D to the current point in time.

RECOVER TABLESPACE DSN8D81A.DSN8S81D

so I was using the similar statement as mentioned above, then why is it not recoveing to the current point in time ?? - does the current point in time means it recovers using the last full image copy and applies the cganges in log also ??

Thanks
leo

kolusu · Posted: Mon Jan 22, 2007 11:36 am Post subject:

LEO · Posted: Mon Jan 22, 2007 3:09 pm Post subject:

Kolusu,

The last QUIESCE point is taken during the last full Image copy as shown below

DSNUGUTC - QUIESCE TABLESPACE Z013225.PLANTBLH
-DMTA DSNUQUIA - QUIESCE SUCCESSFUL FOR TABLESPACE Z013225.PLANTBLH
-DMTA DSNUQUIA - QUIESCE AT RBA 0907ECB00BCA AND AT LRSN C007ABF44680

then the RECOVER TABLESPACE DB.TS should be recovered to last quiesce point .. right ? but the deleted rows after taking imagecopy are not recovered here. It is recovered only when we use TOLASTFULLCOPY. Please advise me on why is that happening ?

Thanks

kolusu · Posted: Mon Jan 22, 2007 3:15 pm Post subject:

LEO,

Your DB2 system might have taken another QUIESCE after the image copy is taken. Compare the Image copy QUIESCE RBA with the RBA record from the catalog table SYSIBM.SYSCOPY. I bet they are off

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

LEO · Posted: Mon Jan 22, 2007 3:53 pm Post subject:

Both are the same as shown below. I am wondering why this is happening ?

-DMTE DSNUCASA - RECOVER OF TABLESPACE Z013225.PLANTBLH WILL PROCEED TO LOG POINT X'C007ABF44680'

== Table: SYSIBM.SYSCOPY(T1) ==============
== LineCmd ==> ___ Row Status:

START_RBA : {..4..
: C0AF48
: 07B460

Please advise

Thanks,
Leo

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

Well, to my eyes, CURRENT POINT OF TIME means:
Load the last full imagecopy and apply all log records created for that space after the imagecopy is taken.

Therefore your first RECOVER attempt just repeats, what you have done: Delete some of it's records.

This flavour of a RECOVERY is intended for media failure (i.e., the dasd volume is gone of the VSAM file is corrupted). Alternatives for that are POINT-IN-TIME recoveries, where the "point" is an offset in the stream of logs produced by DB2, normaly indentified by a QUIESCE point. The other alternative is a RECOVER-TO COPY, where the recover process stops after just loading the mentioned imagecopy.

regards
Christian

LEO · Posted: Tue Jan 23, 2007 9:50 am Post subject:

Excellent CZerfas !!!! I got the answer. That's a wonderful explanation
Thanks Kolusu for your prompt reply!!