one observation:
Maximum number of bytes in a record = 381892
Any record that will not fit in a block (UniData max block size = 16kb)
will start in level 1 overflow and link contiguous blocks as needed.
You can configure/resize forever to 'eliminate overflow' and will always
have level 1 overflow if you have large records (as exist in this file).
Wally Terhune
SWG Client Support -
Information Management Software
U2 Support Architect b IBM U2
Client Support Team
4700 S. Syracuse St., Denver,
CO 80237
Tel: (303) 773-7969 T/L
656-7969
Mobile: (303) 807-6222
[EMAIL PROTECTED]
"David A. Green"
<[EMAIL PROTECTED]
ting.com> To
Sent by: <[email protected]>
[EMAIL PROTECTED] cc
stserver.u2ug.org
Subject
RE: [U2] Unidata file size
04/14/2008 08:05
AM
Please respond to
[EMAIL PROTECTED]
er.u2ug.org
Jeff,
This is just the overflow groups being added as needed. You can run guide
to find a better modulo/block size, but a little data overflow is ok.
Thanks,
David A. Green
www.dagconsulting.com
(480) 813-1725
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff Butera
Sent: Sunday, April 13, 2008 11:51 AM
To: [email protected]
Subject: [U2] Unidata file size
I'm running Unidata 7.1.8 on Solaris 9. I have a static hashed file with
modulo 5009 and block size of 16K. I didn't think static hashed files
would change size at the OS level, but this one is. Am I just wet
behind the ears or do I just misunderstand static hashing?
Here's the file this afternoon:
-rwxrwx--- 1 datatel staff 102105088 Apr 13 12:32 WWW.STATE
and about two hours later:
-rwxrwx--- 1 datatel staff 121372672 Apr 13 14:44 WWW.STATE
Since I know someone might ask:
File name = WWW.STATE
Number of groups in file (modulo) = 5009
Static hashing, hash type = 0
Block size = 16384
File has 62 groups in level one overflow.
Number of records = 505
Total number of bytes = 4673742
Average number of records per group = 0.1
Standard deviation from average = 0.3
Average number of bytes per group = 933.1
Standard deviation from average = 9586.7
Average number of bytes in a record = 9254.9
Average number of bytes in record ID = 21.6
Standard deviation from average = 28809.0
Minimum number of bytes in a record = 51
Maximum number of bytes in a record = 381892
Minimum number of fields in a record = 1
Maximum number of fields in a record = 827
Average number of fields per record = 80.9
Standard deviation from average = 134.7
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556
"Working with them is like going to Las Vegas:
sometimes you get lucky and sometimes you don't."
Dan Parker
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
[demime 1.01d removed an attachment of type image/jpeg which had a name of
1D810929.jpg]
[demime 1.01d removed an attachment of type image/gif which had a name of
graycol.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
pic04567.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
ecblank.gif]
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
