Connecting Tech Pros Worldwide Help | Site Map

How to recovery a dropped table?

Newbie
 
Join Date: Dec 2008
Posts: 4
#1: Dec 9 '08
I am running DB2 v9 in z/OS.
I am trying to recovery a dropped table but I could not do it.
I have the full and incremental image copies from before of the drop table command.
The recover utility is working right and shows RC=0, but the table has not been recovered.
When I try to recover another table that had all the rows deleted is working.
Anyone can help me?

Thank you,
Eduardo
Member
 
Join Date: Nov 2008
Posts: 52
#2: Dec 9 '08

re: How to recovery a dropped table?


Go Through

IBM Information Management Software for z/OS Solutions Information Center

AniJos
Newbie
 
Join Date: Dec 2008
Posts: 4
#3: Dec 10 '08

re: How to recovery a dropped table?


Anijos,

Thank you for your reply, helped at lot!

Eduardo
Newbie
 
Join Date: Dec 2008
Posts: 4
#4: Dec 11 '08

re: How to recovery a dropped table?


Anijos,

Yesterday I tried the procedure described the in IBM site but I am getting this error:



I tried the DSN1COPY with the OBIDXLAT, FULLCOPY and both are given the same error.
Any suggestions now?
Newbie
 
Join Date: Aug 2008
Posts: 28
#5: Dec 15 '08

re: How to recovery a dropped table?


Recover Dropped Tables in DB2
Newbie
 
Join Date: Dec 2008
Posts: 4
#6: Dec 16 '08

re: How to recovery a dropped table?


Ganeshmn,

Thanks for reply, but this tutorial apply for Windows, Linux and UNIX, but I am using z/OS.

Any other suggestions?

Eduardo
Reply


Similar DB2 Database bytes