Subject Re: firebird.conf for HP Proliant Server
Author frodo_haija
Dear Helen

Thanks you verry much for your interesting writes.

The gstat -i give me a file with 6280 lines. Here the first part of
the file:

Database "d:\database\msup.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 21374673
Page size 4096
ODS version 11.0
Oldest transaction 21374659
Oldest active 21374660
Oldest snapshot 21374660
Next transaction 21374667
Bumped transaction 1
Sequence number 0
Next attachment ID 12
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Feb 13, 2008 20:13:13
Attributes force write

Variable header data:
Sweep interval: 20000
*END*


Database file sequence:
File d:\database\msup.fdb is the only file

Analyzing database pages ...
ABFRAGESOURCE (229)

Index IXTYPE_208 (1)
Depth: 1, leaf buckets: 1, nodes: 249
Average data length: 0.01, total dup: 248, max dup: 248
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

Index IX_208_208_1_0 (3)
Depth: 1, leaf buckets: 1, nodes: 249
Average data length: 0.86, total dup: 104, max dup: 13
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

ABSTRACTORDNER (136)

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

How do i have to interpret this?

Do i have to upload the hole file?

Greetings from Switzerland

Haija