Re: DD_HASHSIZE & DD_HASHMAX variables
Albert wisse wrote:
>
> <HTML>
> I got from Madison Pruet the sugestion to increase the memory dictionary
> with DD_HASHSIZE & DD_HASMAX because the application in use has
> many tables, 2000 tables pro database isn't uncommon.
>
> <P>The dictionary parameters are undocumented so if anybody has the syntax
> and documentation on them I will would ask him to share this information.
Just add them to the end of your onconfig file like so:
DD_HASHSIZE 211 # Length of DD Hash Table
DD_HASHMAX 45 # Width of DD Hash Table
211 & 45 are just examples. I suspect DD_HASHSIZE should be a prime
number.
Don't forget to 'bounce' IDS.
Hope that helps,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //|
| +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+