[firebird-support] Change Write Mode
Hello, I have a db created with an old firebird version (I don't know which version is, I suppose 1.5) and Force Write parameter is OFF. So i created a scheduled batch (during night) to change write mode: "%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" -write sync -user SYSDBA -password masterkey %DB1% >> %LOG_FILE% "%FB_PATH%\GFIX.EXE" -online normal -user SYSDBA -password masterkey %DB1% >> %LOG_FILE% "%FB_PATH%\GSTAT.EXE" -h %DB1% >> %LOG_FILE% %DB1% => : But Write Mode don't change and this is the log: Database "" Database header page information: Flags0 Checksum12345 Generation96532559 Page size4096 ODS version11.1 Oldest transaction94973358 Oldest active94973359 Oldest snapshot94973359 Next transaction94973360 Bumped transaction1 Sequence number0 Next attachment ID14208336 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* <= no log from GFIX execution Database "" Database header page information: Flags0 Checksum12345 Generation96532562 Page size4096 ODS version11.1 Oldest transaction94973358 Oldest active94973359 Oldest snapshot94973359 Next transaction94973360 Bumped transaction1 Sequence number0 Next attachment ID14208337 Implementation ID16 Shadow count0 Page buffers0 Next header page0 Database dialect3 Creation dateAug 19, 2014 21:56:08 Attributes<= no change after GFIX execution Variable header data: Sweep interval:2 *END* What is wrong? Any idea? Thank you in advance, Tiziano.
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.
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
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
> 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 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