Re: [firebird-support] Change Write Mode
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'
t...@iblogmanager.com [firebird-support]" 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 t...@iblogmanager.com
> [firebird-support]" 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: 2
>> *END*
>>
>>
>> [...]
>> 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: 2
>> *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: 2
>> *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
>
>
>
>
>
>
#yiv5091572647 #yiv5091572647 -- #yiv5091572647ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5091572647
#yiv5091572647ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5091572647
#yiv5091572647ygrp-mkp #yiv5091572647hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5091572647 #yiv5091572647ygrp-mkp #yiv5091572647ads
{margin-bottom:10px;}#yiv5091572647 #yiv5091572647ygrp-mkp .yiv5091572647ad
{padding:0 0;}#yiv5091572647 #yiv5091572647ygrp-mkp .yiv5091572647ad p
{margin:0;}#yiv5091572647 #yiv5091572647ygrp-mkp .yiv5091572647ad a
{color:#ff;text-decoration:none;}#yiv5091572647 #yiv5091572647ygrp-sponsor
#yiv5091572647ygrp-lc {font-family:Arial;}#yiv5091572647
#yiv5091572647ygrp-sponsor #yiv5091572647ygrp-lc #yiv5091572647hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5091572647
#yiv5091572647ygrp-sponsor #yiv5091572647ygrp-lc .yiv5091572647ad
{margin-bottom:10px;padding:0 0;}#yiv5091572647 #yiv5091572647actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5091572647
#yiv5091572647activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5091572647
#yiv5091572647activity span {font-weight:700;}#yiv5091572647
#yiv5091572647activity span:first-child
{text-transform:uppercase;}#yiv5091572647 #yiv5091572647activity span a
{color:#5085b6;text-decoration:none;}#yiv5091572647 #yiv5091572647activity span
span {color:#ff7900;}#yiv5091572647 #yiv5091572647ac
Re: [firebird-support] Change Write Mode
> 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 > t...@iblogmanager.com > [firebird-support]" 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: 2 >> *END* >> >> >> [...] >> 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: 2 >> *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: 2 >> *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 > > > > > >
Re: [firebird-support] Change Write Mode
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? Il Giovedì 13 Novembre 2014 17:48, "Thomas Steinmaurer t...@iblogmanager.com [firebird-support]" 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: 2 > *END* > > > [...] > 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: 2 > *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: 2 > *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
Re: [firebird-support] Change Write Mode
> *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 page0 > Database dialect3 > Creation dateAug 19, 2014 21:56:08 > Attributes > > Variable header data: > Sweep interval:2 > *END* > > > [...] > Page buffers0 > Next header page0 > Database dialect3 > Creation dateAug 19, 2014 21:56:08 > Attributes force write > > Variable header data: > Sweep interval: 2 > *END* > > > But actually force write is off: > > 2014_11_13 10.45.33,75 > [...] > Implementation ID16 > Shadow count0 > Page buffers0 > Next header page0 > Database dialect3 > Creation dateAug 19, 2014 21:56:08 > Attributes << > > Variable header data: > Sweep interval:2 > *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-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Change Write Mode
*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 page0 Database dialect3 Creation dateAug 19, 2014 21:56:08 Attributes Variable header data: Sweep interval:2 *END* [...] Page buffers0 Next header page0 Database dialect3 Creation dateAug 19, 2014 21:56:08 Attributesforce write Variable header data: Sweep interval:2 *END* But actually force write is off: 2014_11_13 10.45.33,75 [...] Implementation ID16 Shadow count0 Page buffers0 Next header page0 Database dialect3 Creation dateAug 19, 2014 21:56:08 Attributes<< Variable header data: Sweep interval:2 *END* How is possible? Any idea? Firebird versione is 2.5.3 on Windows Standard Server 2008.
