Subject | Re: [firebird-support] Change Write Mode |
---|---|
Author | Tiziano |
Post date | 2014-11-14T10:14:45Z |
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
>
>
>
>
>
>