Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Not able to recover tablespace

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Not able to recover tablespace
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    Post subject: Re: Not able to recover tablespace
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    Post subject: Reply to: Not able to recover tablespace
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    Post subject: Re: Reply to: Not able to recover tablespace
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 4 Wed Jan 11, 2017 6:18 pm
No new posts Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm
No new posts Query on Image Copy Tablespace and QU... vickey_dw DB2 3 Fri Oct 23, 2015 10:55 am
No new posts UNLOAD from Image Copy Tablespace wit... alluri12 DB2 5 Wed Sep 23, 2015 7:00 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us