FireBird (REMR.fdb) Summaries.

Discussion in 'Synapse' started by Jason, Feb 4, 2016.

  1. Jason

    Jason Developer / Handyman Staff Member

    I retrieved this Firbird summaries from IBOconsole.

    Vance
    Code:
    Service started at 2/4/2016 5:14:12 PM
    Database "C:\EMRv\Server\REMR\REMR.FDB"
    Database header page information:
        Flags            0
        Checksum        12345
        Generation        1102959
        Page size        4096
        ODS version        10.1
        Oldest transaction    1102810
        Oldest active        1102811
        Oldest snapshot        1102811
        Next transaction    1102928
        Bumped transaction    1
        Sequence number        0
        Next attachment ID    8911
        Implementation ID    16
        Shadow count        0
        Page buffers        0
        Next header page    0
        Database dialect    3
        Creation date        Sep 2, 2005 9:44:16
        Attributes        force write
        Variable header data:
        *END*
    Database file sequence:
    File C:\EMRv\Server\REMR\REMR.FDB is the only file
    
    Analyzing database pages ...
    
    ACROFORMS (203)
        Primary pointer page: 20757, Index root page: 20759
        Data pages: 0, data page slots: 0, average fill: 0%
    ....
    
    
    Mine
    Code:
    Service started at 2/4/2016 4:56:33 PM
    
    Database "C:\EMR\Server\REMR\REMR.FDB"
    Database header page information:
        Flags            0
        Checksum        12345
        Generation        2173912
        Page size        4096
        ODS version        10.1
        Oldest transaction    2173855
        Oldest active        2173856
        Oldest snapshot        2173856
        Next transaction    2173857
        Bumped transaction    1
        Sequence number        0
        Next attachment ID    9079
        Implementation ID    16
        Shadow count        0
        Page buffers        0
        Next header page    0
        Database dialect    3
        Creation date        Sep 2, 2005 9:44:16
        Attributes        force write
    
        Variable header data:
        *END*
    
    
    Database file sequence:
    File C:\EMR\Server\REMR\REMR.FDB is the only file
    
    Analyzing database pages ...
    
    ANNOTATIONS (213)
        Primary pointer page: 24215, Index root page: 24216
        Data pages: 2, data page slots: 2, average fill: 54%
        Fill distribution:
        0 - 19% = 0
        20 - 39% = 1
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 1 
    ....
    
    Not sure if these summaries tell you much ?

Share This Page