Subject Re: [firebird-support] Change Write Mode
Author Tiziano
I have different software connected to db:

1. Delphi + IB_Object/IBO
2. Web/WCF + NHibernate + Firebird ADO.NET
3. Winforms + Firebird ADO.NET
4. DB Access (linked to firebird with external table) + ODBC

It is possible that a data connection change write mode?


Il Giovedì 13 Novembre 2014 17:48, "Thomas Steinmaurer ts@... [firebird-support]" <firebird-support@yahoogroups.com> ha scritto:


> *UPDATE*
> I have changed batch, switch -online before change write mode.
> Actually the batch is:
> "%FB_PATH%\GSTAT.EXE" -h %DB1% >> %LOG_FILE%
> "%FB_PATH%\GFIX.EXE" -shut full -force 0 -user SYSDBA -password
> masterkey %DB1% >> %LOG_FILE%
> "%FB_PATH%\GFIX.EXE" -online normal -user SYSDBA -password masterkey
> %DB1% >> %LOG_FILE%
> "%FB_PATH%\GFIX.EXE" -write sync -user SYSDBA -password masterkey %DB1%
>  >> %LOG_FILE%
> "%FB_PATH%\GSTAT.EXE" -h %DB1% >> %LOG_FILE%
>
>  From log file it's all ok:
>
> ######## 2014_11_13  3.30.50,84
> [...]
>      Next header page    0
>      Database dialect    3
>      Creation date        Aug 19, 2014 21:56:08
>      Attributes
>
>      Variable header data:
>      Sweep interval:        20000
>      *END*
>
> <after gfix -write sync>
> [...]
>      Page buffers        0
>      Next header page    0
>      Database dialect    3
>      Creation date        Aug 19, 2014 21:56:08
>      Attributes force write
>
>      Variable header data:
>      Sweep interval:    20000
>      *END*
>
>
> But actually force write is off:
>
> ######## 2014_11_13 10.45.33,75
> [...]
>      Implementation ID    16
>      Shadow count        0
>      Page buffers        0
>      Next header page    0
>      Database dialect    3
>      Creation date        Aug 19, 2014 21:56:08
>      Attributes <<<<<<<<<<<<<<
>
>      Variable header data:
>      Sweep interval:        20000
>      *END*
>
>
> How is possible? Any idea? Firebird versione is 2.5.3 on Windows
> Standard Server 2008.

What data access technology are you using?



--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.



------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-digest@yahoogroups.com
    firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/