Subject Re: [firebird-support] Change Write Mode
Author Tiziano
I have found a lot of TIB_Connection and TIBODatabase with ForcedWrites = dpbFalse (now changed to "dpbDefault").
Thanks so much for the help!!


Il Venerdì 14 Novembre 2014 10:18, "'Thomas Steinmaurer' ts@... [firebird-support]" <firebird-support@yahoogroups.com> ha scritto:


 
> I have different software connected to db:
> 1. Delphi + IB_Object/IBO2. Web/WCF + NHibernate + Firebird ADO.NET3. Winforms
> + Firebird ADO.NET 4. DB Access (linked to firebird with external table) + ODBC
> It is possible that a data connection change write mode?

Yes. In your IBO application, what is the value of TIB_connection.ForcedWrites? I vaguely remember a bug there in the connection design editor flipping the property explicitely to False although "Default" is the default and recommended value for that.

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

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

> 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
>
>
>
>
>
>