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