Occasionally we have an error in the database (10.1B) "index for recid # could not be deleted". It is then impossible to remove/update a record in the database using standard software or the progress editor.
When this happens, we dump the record, remove it using "proutil -C idxfix" and then reload the dumped record.
In proutil we use the delete option and give it the recid to delete.
(It's not pretty, I know, but it works.)
Now, we have given proutil a wrong recid and something got deleted, but I don't know what.
We have a test database which is refreshed with production (using probkup and prorest) on a regular basis.
Can I retrieve that record (tablename, values) from test?
Is it something like
for each _index where recid(_index) = 2109586 no-lock: disp _index.
?
Any hint would be greatly appreciated.
Willem
When this happens, we dump the record, remove it using "proutil -C idxfix" and then reload the dumped record.
In proutil we use the delete option and give it the recid to delete.
(It's not pretty, I know, but it works.)
Now, we have given proutil a wrong recid and something got deleted, but I don't know what.
We have a test database which is refreshed with production (using probkup and prorest) on a regular basis.
Can I retrieve that record (tablename, values) from test?
Is it something like
for each _index where recid(_index) = 2109586 no-lock: disp _index.
?
Any hint would be greatly appreciated.
Willem