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% => <ip>:<path + file name>
But Write Mode don't change and this is the log:
Database "<path + file name>"
Database header page information:
Flags 0
Checksum 12345
Generation 96532559
Page size 4096
ODS version 11.1
Oldest transaction 94973358
Oldest active 94973359
Oldest snapshot 94973359
Next transaction 94973360
Bumped transaction 1
Sequence number 0
Next attachment ID 14208336
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*
<= no log from GFIX execution
Database "<path + file name>"
Database header page information:
Flags 0
Checksum 12345
Generation 96532562
Page size 4096
ODS version 11.1
Oldest transaction 94973358
Oldest active 94973359
Oldest snapshot 94973359
Next transaction 94973360
Bumped transaction 1
Sequence number 0
Next attachment ID 14208337
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 <= no change after GFIX execution
Variable header data:
Sweep interval: 20000
*END*
What is wrong? Any idea?
Thank you in advance,
Tiziano.
