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 [email protected] [firebird-support]" <[email protected]> Do: <[email protected]> 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
