I created a dynamic hashed file. It contains only keys, made up of two
integers (with @TM between).
I then populated this file with lots of keys.
I expected ANALYZE.FILE to show key space and unused space, but it's showing
lots of space for "data", even though there is none.
Is what's being counted as data the storage overheads?
Unfortunately I can't use UVFIXFILE, because the hashed file was created with
64-bit addressing. When I try to use fixtool, it responds with "Start
Diagnostics. An error has occurred during running. Error: Unable to open the
data file." This is curious, and happens if the -file option is used to
specify the file. The -filepath options simply abends with "You must specify a
file to use."
Here is the ANALYZE.FILE output. I hope it doesn't wrap around too badly. It
seems to be an awful lot of data space (25-51 bytes per record) to me, even
allowing for 22 bytes/record storage overhead, when there are no data fields.
File type .................. DYNAMIC
NLS Character Set Mapping .. NONE
Hashing Algorithm .......... GENERAL
No. of groups (modulus) .... 110524 current ( minimum 1, 0 empty,
21078 overflowed, 998 badly )
Number of records .......... 5024984
Large record size .......... 1628 bytes
Number of large records .... 0
Group size ................. 2048 bytes
Load factors ............... 80% (split), 50% (merge) and 80% (actual)
Total size ................. 272252928 bytes
Total size of record data .. 140600271 bytes
Total size of record IDs ... 42745685 bytes
Unused space ............... 88902876 bytes
Total space for records .... 272248832 bytes
Number per group ( total of 110524 groups )
Average Minimum Maximum StdDev
Group buffers .............. 1.19 1 3 0.39
Records .................... 45.47 13 118 16.88
Large records .............. 0.00 0 0 0.00
Data bytes ................. 1272.12 354 3589 512.08
Record ID bytes ............ 386.75 114 1007 143.71
Unused bytes ............... 780.68 24 2044 371.44
Total bytes ................ 2439.56 2048 6144 0.00
Number per record ( total of 5024984 records )
Average Minimum Maximum StdDev
Data bytes ................. 27.98 25 51 1.94
Record ID bytes ............ 8.51 3 9 0.66
Total bytes ................ 36.49 28 60 2.12
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
