DD_HASHSIZE , DD_HASHMAX

We are running 7.31.UD3 on Solaris 5.9.I am investigating the optimal setting DD_HASHSIZE and DD_HASHMAX. Currenlty they are set at the default (31 and 10).We have approximately 430 tables in the database but when we run onstat -g dic I get 2400 data dictionary entries which seems very high to me. I then noticed that there are multiple entries for some of the tables in the onstat -g dic output. Is this normal?

This is what I understand the parameters to mean DD_HASHSIZE = Total number of dictionary hash buckets (should be a prime number) DD_HASHMAX = Maximum number of dictionary entries per hash bucket So you should aim for an even spread of entries / hash bucket Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: tichman@excite.com >To: informix-list@iiug.org >Subject: DD_HASHSIZE , DD_HASHMAX >Date: 15 Jan 2007 04:39:20 -0800 > >We are running 7.31.UD3 on Solaris 5.9.I am investigating the optimal >setting DD_HASHSIZE and DD_HASHMAX. Currenlty they are set at the >default (31 and 10).We have approximately 430 tables in the database >but when we run onstat -g dic I get 2400 data dictionary entries which >seems very high to me. I then noticed that there are multiple entries >for some of the tables in the onstat -g dic output. Is this normal? > >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ MSN Hotmail is evolving ' check out the new Windows Live Mail http://ideas.live.com