473,387 Members | 3,821 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

How to recovery a dropped table?

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
Dec 9 '08 #1
5 5062
Anijos,

Thank you for your reply, helped at lot!

Eduardo
Dec 10 '08 #3
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?
Dec 11 '08 #4
Ganeshmn,

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

Any other suggestions?

Eduardo
Dec 16 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: joshsackett | last post by:
Hi All, I have a 2MB database set to SIMPLE recovery. This database is used only to generate new keys to web users. It has two columns - UID and LASTDATE. The UID column is only updated when users...
7
by: Network Administrator | last post by:
Looks like for the first time in 6 years, I'm experienced some database table corruption. This was due to the space filling up on a server (you don't want to know how that happened). I have 3...
3
by: Burkhard Schultheis | last post by:
I had a crash on my w2k machine. I installed w2k in a new directory. Then I installed DB2 V8.1 in the same directory as before. Now DB2 is not able to start. It tells me that the environment is...
1
by: Vikrant | last post by:
On my DB2/UDB system, some tablespace 'Minimum recovery time' is 2000-11-19 or some '1999-10-04' or different, for some tablespace theres is no 'Minimum recovery time' , what does it tell me? ...
3
by: Michelle | last post by:
Hi, I'm trying to rollforward my database to end of logs and complete, the first error message i get is - SQL6063N rollforward recovery on database X has stopped on node "0" due to change in log...
8
by: Neil Truby | last post by:
There's something clearly missing in my understanding of recovery: I set up a small sample datavase and deleted all the rows from a table. Crucially, I omitted the "commit". I then shut down...
3
by: jignesh shah | last post by:
Hi all, Is there a way to recover a single container if its been corrupted or mark bad without restoring whole tablespace? environment: db28.1/aix5.1/tsm/rs-6000. Regards Jignesh
2
by: Raghava | last post by:
hi all, i was working on DB2 and came across an issue. i.e. can a tablespace be rollforwarded to POINT-IN-TIME? the scenario is as follows: i created a data base and a tablespace in it. i have...
0
by: bbkm | last post by:
when i am doing dropped table reccovery step1- the tablespace should be in recovery mode is it rite step2 - the database should be in archivelog mode is it rite step-3 - identify the dropped table...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.