firebird-support - Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore

Subject	Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
Author	Jack Mason
Post date	2015-06-11T15:05:22Z

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, 'liviuslivius@...' liviuslivius@... [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 jackmason@... [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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-digest@yahoogroups.com
firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

(Message over 64 KB, truncated)