Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

Thu, 11 Jun 2015 08:09:08 -0700 

Thanks,
However, that won't help us. Our concern is that we have been backing up our databases for years and it has been a fruitless exercise. We cannot restore them. We did not have that problem with Interbase 6 but switched to Firebird because it was touted as being "modern, safer" etc. Now we find it is virtually worthless unless we can restore a database it has backed up. 


Unless we can get this problem whipped such that the backups are usable, 
or find another way to back them up, there is no reason we should be 
using Firebird.  That is our concern.



There is apparently another backup program, nbackup, that we will try 
but at this point we are leery of anything other than a "professional" 
backup/restore capability for Firebird.



Hopefully, someone will come up with either a "fix" for this problem or 
a different way we should be doing backups.


Thanks again for your suggestion,

Jack


On 6/11/2015 10:46 AM, 'liviusliv...@poczta.onet.pl' 
liviusliv...@poczta.onet.pl [firebird-support] wrote:


Hi,

Maybe wrong direction

But set this restored with error database to be a readonly and try to 
connect to it


Regards,
Karol Bieniaszewski

----- Reply message -----

Od: "Jack Mason jackma...@mindspring.com [firebird-support]" 
<firebird-support@yahoogroups.com>

Do: <firebird-support@yahoogroups.com>

Temat: [firebird-support] Firebird 2.52 gbak fails to do a restore - 
error trigger (3)

Data: czw., cze 11, 2015 16:26


Here is the gstat - h:

Database "customer"
Database header page information:
    Flags            0
    Checksum        12345
    Generation        1175184
    Page size        4096
    ODS version        11.2
    Oldest transaction    119622
    Oldest active        1072065
    Oldest snapshot        1072058
    Next transaction    1072195
    Bumped transaction    1
    Sequence number        0
    Next attachment ID    275823
    Implementation ID    24
    Shadow count        0
    Page buffers        0
    Next header page    0
    Database dialect    3
    Creation date        Feb 19, 2013 0:09:08
    Attributes        force write

    Variable header data:
    Sweep interval:        20000
    *END*

and here is the gstat everything else:

gstat version LI-V2.5.2.26508 Firebird 2.5

Database "customer"
Database header page information:
    Flags            0
    Checksum        12345
    Generation        1175182
    Page size        4096
    ODS version        11.2
    Oldest transaction    119622
    Oldest active        1072065
    Oldest snapshot        1072058
    Next transaction    1072193
    Bumped transaction    1
    Sequence number        0
    Next attachment ID    275822
    Implementation ID    24
    Shadow count        0
    Page buffers        0
    Next header page    0
    Database dialect    3
    Creation date        Feb 19, 2013 0:09:08
    Attributes        force write

    Variable header data:
    Sweep interval:        20000
    *END*


Database file sequence:
File customer is the only file
    Firebird/linux AMD64 (access method), version "LI-V2.5.2.26508
Firebird 2.5"
    Firebird/linux AMD64 (remote server), version "LI-V2.5.2.26508
Firebird 2.5/tcp (lserver)/P12"
    Firebird/linux AMD64 (remote interface), version "LI-V2.5.2.26508
Firebird 2.5/tcp (lserver)/P12"
    on disk structure version 11.2

Analyzing database pages ...
CUSTOMERS (128)
    Primary pointer page: 183, Index root page: 184
    Average record length: 340.17, total records: 70105
    Average version length: 26.60, total versions: 5, max versions: 2
    Data pages: 6626, data page slots: 6646, average fill: 94%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 8
    40 - 59% = 14
    60 - 79% = 16
    80 - 99% = 6587

    Index FNAME (2)
    Depth: 2, leaf buckets: 135, nodes: 70109
    Average data length: 0.51, total dup: 57228, max dup: 584
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 1
        40 - 59% = 54
        60 - 79% = 40
        80 - 99% = 40

    Index FULLNAME (6)
    Depth: 3, leaf buckets: 330, nodes: 70105
    Average data length: 4.83, total dup: 20467, max dup: 18169
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 133
        40 - 59% = 21
        60 - 79% = 173
        80 - 99% = 3

    Index HOME (3)
    Depth: 2, leaf buckets: 226, nodes: 70108
    Average data length: 2.61, total dup: 9196, max dup: 2392
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 2
        40 - 59% = 101
        60 - 79% = 86
        80 - 99% = 37

    Index LNAME (0)
    Depth: 2, leaf buckets: 154, nodes: 70117
    Average data length: 1.08, total dup: 46986, max dup: 758
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 1
        40 - 59% = 74
        60 - 79% = 15
        80 - 99% = 63

    Index NEWID (4)
    Depth: 2, leaf buckets: 121, nodes: 70105
    Average data length: 1.04, total dup: 2, max dup: 1
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 30
        60 - 79% = 13
        80 - 99% = 78

    Index OFFICEPHONE (5)
    Depth: 2, leaf buckets: 102, nodes: 70105
    Average data length: 0.20, total dup: 67213, max dup: 38383
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 1
        40 - 59% = 32
        60 - 79% = 17
        80 - 99% = 52

    Index RDB$PRIMARY7 (1)
    Depth: 3, leaf buckets: 346, nodes: 70117
    Average data length: 7.64, total dup: 11, max dup: 3
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 9
        40 - 59% = 171
        60 - 79% = 16
        80 - 99% = 150

INVOICES (132)
    Primary pointer page: 191, Index root page: 192
    Average record length: 27.41, total records: 27
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 2, data page slots: 19, average fill: 16%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 1
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$PRIMARY11 (0)
    Depth: 2, leaf buckets: 1, nodes: 27
    Average data length: 8.56, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

ON_ORDER (133)
    Primary pointer page: 194, Index root page: 195
    Average record length: 510.49, total records: 503
    Average version length: 200.83, total versions: 88, max versions: 5
    Data pages: 99, data page slots: 173, average fill: 74%
    Fill distribution:
     0 - 19% = 4
    20 - 39% = 3
    40 - 59% = 17
    60 - 79% = 27
    80 - 99% = 48

    Index CUSTID (0)
    Depth: 2, leaf buckets: 1, nodes: 505
    Average data length: 1.51, total dup: 220, max dup: 85
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 1
        80 - 99% = 0

    Index CUST_NAME (2)
    Depth: 2, leaf buckets: 3, nodes: 506
    Average data length: 7.14, total dup: 209, max dup: 33
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 2
        60 - 79% = 1
        80 - 99% = 0

    Index RDB$PRIMARY6 (1)
    Depth: 2, leaf buckets: 11, nodes: 512
    Average data length: 43.48, total dup: 2, max dup: 1
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 2
        40 - 59% = 5
        60 - 79% = 4
        80 - 99% = 0

    Index STOCK_NUM (3)
    Depth: 2, leaf buckets: 2, nodes: 503
    Average data length: 5.06, total dup: 70, max dup: 6
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 1
        60 - 79% = 1
        80 - 99% = 0

PENDING (134)
    Primary pointer page: 6738, Index root page: 6739
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

RDB$BACKUP_HISTORY (32)
    Primary pointer page: 68, Index root page: 69
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_44 (0)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$CHARACTER_SETS (28)
    Primary pointer page: 60, Index root page: 61
    Average record length: 35.52, total records: 52
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 1, data page slots: 1, average fill: 67%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 1
    80 - 99% = 0

    Index RDB$INDEX_19 (0)
    Depth: 1, leaf buckets: 1, nodes: 52
    Average data length: 2.98, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_25 (1)
    Depth: 1, leaf buckets: 1, nodes: 52
    Average data length: 1.04, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$CHECK_CONSTRAINTS (24)
    Primary pointer page: 52, Index root page: 53
    Average record length: 22.94, total records: 17
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 1, data page slots: 1, average fill: 17%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_14 (0)
    Depth: 1, leaf buckets: 1, nodes: 17
    Average data length: 1.65, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_40 (1)
    Depth: 1, leaf buckets: 1, nodes: 17
    Average data length: 3.12, total dup: 9, max dup: 4
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$COLLATIONS (29)
    Primary pointer page: 62, Index root page: 63
    Average record length: 26.14, total records: 148
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 3, data page slots: 3, average fill: 57%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 1
    40 - 59% = 0
    60 - 79% = 2
    80 - 99% = 0

    Index RDB$INDEX_20 (0)
    Depth: 1, leaf buckets: 1, nodes: 148
    Average data length: 3.72, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 1
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_26 (1)
    Depth: 1, leaf buckets: 1, nodes: 148
    Average data length: 1.76, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$DATABASE (1)
    Primary pointer page: 6, Index root page: 7
    Average record length: 15.00, total records: 1
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 1, data page slots: 1, average fill: 1%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

RDB$DEPENDENCIES (13)
    Primary pointer page: 30, Index root page: 31
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_27 (0)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_28 (1)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$EXCEPTIONS (30)
    Primary pointer page: 64, Index root page: 65
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_23 (0)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_24 (1)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$FIELDS (2)
    Primary pointer page: 8, Index root page: 9
    Average record length: 31.92, total records: 512
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 10, data page slots: 10, average fill: 62%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 9
    80 - 99% = 0

    Index RDB$INDEX_2 (0)
    Depth: 1, leaf buckets: 1, nodes: 512
    Average data length: 2.58, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 1
        80 - 99% = 0

RDB$FIELD_DIMENSIONS (21)
    Primary pointer page: 46, Index root page: 47
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_36 (0)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$FILES (10)
    Primary pointer page: 24, Index root page: 25
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

RDB$FILTERS (16)
    Primary pointer page: 36, Index root page: 37
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_17 (0)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_45 (1)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$FORMATS (8)
    Primary pointer page: 20, Index root page: 21
    Average record length: 16.35, total records: 17
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 5, data page slots: 5, average fill: 70%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 1
    40 - 59% = 0
    60 - 79% = 2
    80 - 99% = 2

    Index RDB$INDEX_16 (0)
    Depth: 1, leaf buckets: 1, nodes: 17
    Average data length: 2.94, total dup: 2, max dup: 1
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$FUNCTIONS (14)
    Primary pointer page: 32, Index root page: 33
    Average record length: 63.00, total records: 2
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 1, data page slots: 1, average fill: 4%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_9 (0)
    Depth: 1, leaf buckets: 1, nodes: 2
    Average data length: 13.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$FUNCTION_ARGUMENTS (15)
    Primary pointer page: 34, Index root page: 35
    Average record length: 37.00, total records: 7
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 1, data page slots: 1, average fill: 9%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_10 (0)
    Depth: 1, leaf buckets: 1, nodes: 7
    Average data length: 3.71, total dup: 5, max dup: 3
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$GENERATORS (20)
    Primary pointer page: 44, Index root page: 45
    Average record length: 32.30, total records: 10
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 1, data page slots: 1, average fill: 21%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 1
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_11 (0)
    Depth: 1, leaf buckets: 1, nodes: 10
    Average data length: 11.50, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_46 (1)
    Depth: 1, leaf buckets: 1, nodes: 10
    Average data length: 1.10, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$INDEX_SEGMENTS (3)
    Primary pointer page: 10, Index root page: 11
    Average record length: 39.95, total records: 83
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 2, data page slots: 2, average fill: 61%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 1
    60 - 79% = 1
    80 - 99% = 0

    Index RDB$INDEX_6 (0)
    Depth: 1, leaf buckets: 1, nodes: 83
    Average data length: 1.81, total dup: 14, max dup: 2
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$INDICES (4)
    Primary pointer page: 12, Index root page: 13
    Average record length: 49.57, total records: 69
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 3, data page slots: 3, average fill: 43%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 0
    40 - 59% = 1
    60 - 79% = 1
    80 - 99% = 0

    Index RDB$INDEX_31 (1)
    Depth: 1, leaf buckets: 1, nodes: 69
    Average data length: 4.96, total dup: 34, max dup: 6
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_41 (2)
    Depth: 1, leaf buckets: 1, nodes: 69
    Average data length: 0.00, total dup: 68, max dup: 68
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_5 (0)
    Depth: 1, leaf buckets: 1, nodes: 69
    Average data length: 2.17, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$LOG_FILES (25)
    Primary pointer page: 54, Index root page: 55
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

RDB$PAGES (0)
    Primary pointer page: 3, Index root page: 4
    Average record length: 15.50, total records: 157
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 3, data page slots: 3, average fill: 42%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 0
    40 - 59% = 2
    60 - 79% = 0
    80 - 99% = 0

RDB$PROCEDURES (26)
    Primary pointer page: 56, Index root page: 57
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_21 (0)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_22 (1)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$PROCEDURE_PARAMETERS (27)
    Primary pointer page: 58, Index root page: 59
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_18 (0)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_47 (1)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_48 (2)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$REF_CONSTRAINTS (23)
    Primary pointer page: 50, Index root page: 51
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_13 (0)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$RELATIONS (6)
    Primary pointer page: 16, Index root page: 17
    Average record length: 59.32, total records: 50
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 6, data page slots: 6, average fill: 62%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 1
    40 - 59% = 2
    60 - 79% = 1
    80 - 99% = 2

    Index RDB$INDEX_0 (0)
    Depth: 1, leaf buckets: 1, nodes: 50
    Average data length: 9.64, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_1 (1)
    Depth: 1, leaf buckets: 1, nodes: 56
    Average data length: 0.91, total dup: 5, max dup: 5
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$RELATION_CONSTRAINTS (22)
    Primary pointer page: 48, Index root page: 49
    Average record length: 49.91, total records: 23
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 1, data page slots: 1, average fill: 38%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 1
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_12 (0)
    Depth: 1, leaf buckets: 1, nodes: 23
    Average data length: 2.52, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_42 (1)
    Depth: 1, leaf buckets: 1, nodes: 23
    Average data length: 9.61, total dup: 10, max dup: 2
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_43 (2)
    Depth: 1, leaf buckets: 1, nodes: 23
    Average data length: 0.83, total dup: 16, max dup: 16
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$RELATION_FIELDS (5)
    Primary pointer page: 14, Index root page: 15
    Average record length: 62.40, total records: 735
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 19, data page slots: 19, average fill: 75%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 1
    40 - 59% = 0
    60 - 79% = 16
    80 - 99% = 2

    Index RDB$INDEX_15 (2)
    Depth: 2, leaf buckets: 7, nodes: 735
    Average data length: 19.75, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 1
        40 - 59% = 3
        60 - 79% = 1
        80 - 99% = 2

    Index RDB$INDEX_3 (0)
    Depth: 1, leaf buckets: 1, nodes: 735
    Average data length: 1.79, total dup: 224, max dup: 31
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 1

    Index RDB$INDEX_4 (1)
    Depth: 1, leaf buckets: 1, nodes: 735
    Average data length: 0.66, total dup: 685, max dup: 142
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 1
        80 - 99% = 0

RDB$ROLES (31)
    Primary pointer page: 66, Index root page: 67
    Average record length: 30.00, total records: 1
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 1, data page slots: 1, average fill: 1%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_39 (0)
    Depth: 1, leaf buckets: 1, nodes: 1
    Average data length: 9.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$SECURITY_CLASSES (9)
    Primary pointer page: 22, Index root page: 23
    Average record length: 25.50, total records: 22
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 1, data page slots: 1, average fill: 54%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 1
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_7 (0)
    Depth: 1, leaf buckets: 1, nodes: 22
    Average data length: 1.50, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$TRANSACTIONS (19)
    Primary pointer page: 42, Index root page: 43
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_32 (0)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$TRIGGERS (12)
    Primary pointer page: 28, Index root page: 29
    Average record length: 59.83, total records: 35
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 5, data page slots: 5, average fill: 75%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 1
    80 - 99% = 3

    Index RDB$INDEX_38 (1)
    Depth: 1, leaf buckets: 1, nodes: 35
    Average data length: 3.94, total dup: 22, max dup: 5
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_8 (0)
    Depth: 1, leaf buckets: 1, nodes: 35
    Average data length: 1.34, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$TRIGGER_MESSAGES (17)
    Primary pointer page: 38, Index root page: 39
    Average record length: 60.11, total records: 36
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 1, data page slots: 1, average fill: 68%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 1
    80 - 99% = 0

    Index RDB$INDEX_35 (0)
    Depth: 1, leaf buckets: 1, nodes: 36
    Average data length: 1.00, total dup: 12, max dup: 5
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$TYPES (11)
    Primary pointer page: 26, Index root page: 27
    Average record length: 45.56, total records: 228
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 5, data page slots: 5, average fill: 70%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 5
    80 - 99% = 0

    Index RDB$INDEX_37 (0)
    Depth: 1, leaf buckets: 1, nodes: 228
    Average data length: 4.22, total dup: 16, max dup: 1
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 1
        60 - 79% = 0
        80 - 99% = 0

RDB$USER_PRIVILEGES (18)
    Primary pointer page: 40, Index root page: 41
    Average record length: 45.17, total records: 58
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 2, data page slots: 2, average fill: 44%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 1
    80 - 99% = 0

    Index RDB$INDEX_29 (0)
    Depth: 1, leaf buckets: 1, nodes: 58
    Average data length: 1.47, total dup: 47, max dup: 5
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_30 (1)
    Depth: 1, leaf buckets: 1, nodes: 58
    Average data length: 0.26, total dup: 55, max dup: 49
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

RDB$VIEW_RELATIONS (7)
    Primary pointer page: 18, Index root page: 19
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$INDEX_33 (0)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index RDB$INDEX_34 (1)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

REQUESTS (130)
    Primary pointer page: 187, Index root page: 188
    Average record length: 75.28, total records: 68
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 2, data page slots: 2, average fill: 77%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 2
    80 - 99% = 0

    Index RDB$PRIMARY9 (0)
    Depth: 1, leaf buckets: 1, nodes: 68
    Average data length: 28.37, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 1
        60 - 79% = 0
        80 - 99% = 0

    Index REQAUTHOR (1)
    Depth: 1, leaf buckets: 1, nodes: 68
    Average data length: 6.00, total dup: 29, max dup: 29
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index REQTITLE (2)
    Depth: 1, leaf buckets: 1, nodes: 68
    Average data length: 28.37, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 1
        60 - 79% = 0
        80 - 99% = 0

SPECORDERS (129)
    Primary pointer page: 185, Index root page: 186
    Average record length: 254.02, total records: 507
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 38, data page slots: 38, average fill: 89%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 38

    Index NAME (1)
    Depth: 1, leaf buckets: 1, nodes: 507
    Average data length: 3.97, total dup: 349, max dup: 107
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 1

    Index RDB$PRIMARY3 (0)
    Depth: 2, leaf buckets: 7, nodes: 507
    Average data length: 42.42, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 6

    Index STOCKID (3)
    Depth: 2, leaf buckets: 5, nodes: 507
    Average data length: 31.30, total dup: 10, max dup: 1
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 1
        60 - 79% = 0
        80 - 99% = 4

    Index STOCK_NO (2)
    Depth: 2, leaf buckets: 3, nodes: 507
    Average data length: 16.97, total dup: 21, max dup: 5
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 1
        80 - 99% = 2

STANDING (131)
    Primary pointer page: 189, Index root page: 190
    Average record length: 0.00, total records: 0
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 0, data page slots: 0, average fill: 0%
    Fill distribution:
     0 - 19% = 0
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 0
    80 - 99% = 0

    Index RDB$PRIMARY21 (0)
    Depth: 1, leaf buckets: 1, nodes: 0
    Average data length: 0.00, total dup: 0, max dup: 0
    Fill distribution:
         0 - 19% = 1
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

TRADELOG (135)
    Primary pointer page: 6778, Index root page: 6779
    Average record length: 57.00, total records: 42366
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 1025, data page slots: 1025, average fill: 75%
    Fill distribution:
     0 - 19% = 1
    20 - 39% = 0
    40 - 59% = 0
    60 - 79% = 1024
    80 - 99% = 0






------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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






--

"Our Constitution was made only for a moral and religious people. It is 
wholly inadequate to the government of any other." -- John Adams, Oct. 
11, 1798 "Where there is no vision, the people perish.." Prov 29:18













    

  • ... 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
    • 

    • 

    • ... Jack Mason jackma...@mindspring.com [firebird-support]
      • 

      • 

      • ... Tim Ward t...@telensa.com [firebird-support]
        • 

        • 

        • ... Jack Mason jackma...@mindspring.com [firebird-support]
          • 

        • 

      • ... Ann Harrison aharri...@ibphoenix.com [firebird-support]
        • 

        • 

        • ... Jack Mason jackma...@mindspring.com [firebird-support]
          • 

          • 

          • ... Ann Harrison aharri...@ibphoenix.com [firebird-support]
            • 

            • 

            • ... Jack Mason jackma...@mindspring.com [firebird-support]
              • 

            • 

          • 

        • 

      • 

    • ... 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
      • 

      • 

      • ... Jack Mason jackma...@mindspring.com [firebird-support]
        • 

      

    










					Reply via email to