mars wrote:

> I am a database administrator trying to fix a 2GB firebird ver1.5
> database being used in a hospital. I cannot afford to shutdown the
> database as this is a 24/7 operation.
> I had copied the database file (inside REdhat Linux) to my PC and doing
> a (local) gfix (-v -full/-mend) but the number of errors is still the
> same. I have not tried doing it for the live database.
> I cannot backup using IBExpert. Error is "Arithmetic overflow...".

As for gfix'ing the database with users still connected, I would be
very reluctant.

Are there any interesting messages in the firebird.log lately? What
messages do you see (apart from the "Arithmetic overflow...")?

Did you copy the database without shutting down? This is usually not
a good idea.
After "gfix -mend" you should try to backup+restore (at your local
pc), and see whether errors persists. I believe -mend just tries to
prepare the db for a (hopefully) successful backup.


--
Aage J.