DD_HASHSIZE , DD

DD_HASHSIZE , DD_HASHMAX

This is a discussion on DD_HASHSIZE , DD_HASHMAX within the Informix forums, part of the Database Server Software category; --> 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 ...

		Unix Technical Forum > Database Server Software > Informix
DD_HASHSIZE , DD_HASHMAX

#1 (permalink)

04-20-2008, 03:58 PM

tichman@excite.com

Posts: n/a

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?

« dbaccess improvement | Re: how to copy large data fast »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 04:13 AM.