Subject AW: AW: [firebird-support] How to test for forced writes?
Author Steffen Heil
Hi

Thanks for the information.

However I am on 2.0.4 (and currently bound to that) and I need to decide
from linux on command line, whether forced writes is on.
Can you give me any hint?

Regards,
Steffen


> -----Ursprüngliche Nachricht-----
> Von: firebird-support@yahoogroups.com [mailto:firebird-
> support@yahoogroups.com] Im Auftrag von Norman Dunbar
> Gesendet: Mittwoch, 26. Januar 2011 17:26
> An: firebird-support@yahoogroups.com
> Betreff: Re: AW: [firebird-support] How to test for forced writes?
>
> Hi Steffen,
>
> > In an older mail to this list (2010-10-01 09:28) Norman Dunbar wrote:
> >
> >> Note, if gfix hasn't been used against this database, then the above
> > command will not display "Attributes".
> >
> > So does the absence of that line in the output say "gfix was not used,
> > so no information" or does is say "forced writes is off" ?
>
> On a database that has never been "gfix -write async" the Attributes do
not
> show anything for forced writes. At least, up until version 2.5 where it
> *does* show "forced writes" immediately after a database has been
> created.
>
> On 2.1.3, there is nothing listed until after you run "gfix -write" to set
the
> forced writes on.
>
> Once the database has had "gfix -write" run against it, the attributes do
show
> details.
>
> There may have been a change between 2.1.3 and 2.5 where this was
> resolved.
>
>
> Cheers,
> Norman.
>
>
>
>
>
>
>
> >
> >
> > My problem: This database is part of one of our products and I need to
> > be sure, it always works in forced writes mode.
> > I always thought it would, but now I want to be sure.
> >
> > Your statement above indicated, we are wrong, but what now?
> >
> > Can we "simply" run " gfix -user sysdba -pass XYZ -write sync
> > /path/to/database.fdb" ?
> >
> > What about backups? If they are restored, do we need to run that
> > command again?
> >
> >
> > Regards,
> > Steffen
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> >
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item on the
> > main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> >
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++++++++
> > Yahoo! Groups Links
> >
> >
> >
> >
>
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> Thorpe House
> 61 Richardshaw Lane
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7EL
>
> Company Number: 05132767
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item on the main
> (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++++++++
> Yahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]