At 11:08 PM 12/12/2005 +0000, you wrote:

>The Oldest transaction in my DB hasn't been moving for sometime so I
>ran gfix -sweep on it and I got an error saying gfix: "full" or
>"reserve" required.
>
>What does this error mean and how do I fix it ?

I think it means you had a typo in your command. There are two switches in
gfix that start with the characters "-use" - one is -user and the other is
-use. For this reason, BOTH switches need to be used as the full name (not
an abbreviation).

So you need:

gfix -sweep c:\data\mydb.fdb -user sysdba -password mypasswd

FYI, the -use switch takes an obligatory argument which is "full" or
"reserve". That's what is causing your exception. Its default value is
"reserve", which is what you need in all cases except where the database is
intended for read-only usage.

./heLen