IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Not able to recover tablespace


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Bhavan JS
Warnings : 1

New User


Joined: 30 Nov 2007
Posts: 10
Location: Bangalore

PostPosted: Fri Dec 21, 2007 11:58 am
Reply with quote

Hi,

1. I took imagecopy of my tablespace by providing "COPY TABLESPACE TABLESPACE-NAME COPYDDN SYSCOPY SHRLEVEL CHANGE FULL YES". 2. I deleted all the records from a table (which is on the specified tablespace "TABLESPACE-NAME").
3. Then I ran my recovery & rebuild job by providing "RECOVER TABLESPACE TABLESPACE-NAME" and "REBUILD INDEX(ALL) TABLESPACE TABLESPACE-NAME". I used DSNUTILB utility for both imagecopy and recovery.
My recovery job took the latest imagecopy dataset as input for recovery. Both my imagecopy and recovery job ran successfully with return code 0. But after recovery, there are no records in the table from which I deleted records in step 2.

As far as I know, recovery should recover back the records which I deleted.

Am I missing anything in my process? Your help is appreciated.

Thanks,
Bhavan.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Fri Dec 21, 2007 8:27 pm
Reply with quote

Bhavan JS wrote:
Hi,

1. I took imagecopy of my tablespace by providing "COPY TABLESPACE TABLESPACE-NAME COPYDDN SYSCOPY SHRLEVEL CHANGE FULL YES". 2. I deleted all the records from a table (which is on the specified tablespace "TABLESPACE-NAME").
3. Then I ran my recovery & rebuild job by providing "RECOVER TABLESPACE TABLESPACE-NAME" and "REBUILD INDEX(ALL) TABLESPACE TABLESPACE-NAME". I used DSNUTILB utility for both imagecopy and recovery.
My recovery job took the latest imagecopy dataset as input for recovery. Both my imagecopy and recovery job ran successfully with return code 0. But after recovery, there are no records in the table from which I deleted records in step 2.

As far as I know, recovery should recover back the records which I deleted.

Am I missing anything in my process? Your help is appreciated.

Thanks,
Bhavan.


In addition to using the latest image copy the recovery job would have applied the changes to the table since the last image copy using the DB2 logs. So after recovering the last copy it would have applied the deletes you did.
Back to top
View user's profile Send private message
Bhavan JS
Warnings : 1

New User


Joined: 30 Nov 2007
Posts: 10
Location: Bangalore

PostPosted: Wed Dec 26, 2007 6:16 pm
Reply with quote

Thanks for the reply Craq. But how to ensure if the recovery job really did its job or not?
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Wed Dec 26, 2007 11:22 pm
Reply with quote

Bhavan JS wrote:
Thanks for the reply Craq. But how to ensure if the recovery job really did its job or not?


Read the sysout displays to see what the process did. You can specify the recovery tocopy option which would not apply changes made after the imagecopy.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts force tablespace using LISTDEF input DB2 1
No new posts Map VSAM Dataset to a Table/Tablespace DB2 5
No new posts DB2 tablespace space limitation DB2 3
No new posts Issue While Recovering a Tablespace DB2 4
No new posts Need inputs on DB2 tablespace/table r... DB2 3
Search our Forums:

Back to Top