Unable to Retrieve data from a table!!!!!! (AREV Specific)
At 28 JAN 1998 09:03:34AM Craig Gerhard wrote:
I made the unpopular mistake of running a fixlh on the data table as opposed to the index table and it corrupted the data in my table. When I exit to DOS it tells me that I still have 15M of data in there but when I try to access the data or dump the table, it tells me there are no rows present. Is there any way to retrieve this data through other means? Please HELP!
At 28 JAN 1998 09:15AM Victor wrote:
From the symptoms you are describing, it sounds like your file was cleared while it had a sizelock greater than 0. This causes the size of the .LK file to equal your frame size (1024) times the modulo (look it up in DUMP). The size of the .OV file should be 0. If the last part is not true, you lost some frames from the overflow free list. You can issue a compress from DUMP to fix that. Unfortunately, all this also means that you physically don't have any data in the file.
If any of the above is not true, I'd expect you to get a group format error if your file is really that large. Probably the only way to recover data is to do a restore.
At 28 JAN 1998 09:34AM Aaron Kaplan wrote:
I'd be hard pressed to see how fixlh on a clean file would cause a complete clearing and not compress the file. Is it the OV or LK that is so large? Is there just an empty 1st frame? Does the header report 0 records? If you look at the file in a DOS viewer, can you acually see the information? If so, look through the frames and see if you just have some empty ones in the front. It's pretty rare, but it happens. If the file is just 15M of nothing, then you'd have to do a restore.
apk@sprezzatura.com
At 01 APR 1998 01:20PM Ken Revak wrote:
I have a customer that just experienced the same problem. What was your final solution? Please email me at catalyst@telusplanet.net.