Subject Change Write Mode
Author Tiziano
Post date 2014-11-11T09:53:21Z
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.