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