View previous topic :: View next topic
|
Author |
Message |
Bhavan JS Warnings : 1 New User
Joined: 30 Nov 2007 Posts: 10 Location: Bangalore
|
|
|
|
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 |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
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 |
|
|
Bhavan JS Warnings : 1 New User
Joined: 30 Nov 2007 Posts: 10 Location: Bangalore
|
|
|
|
Thanks for the reply Craq. But how to ensure if the recovery job really did its job or not? |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
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 |
|
|
|