ONSTAT -G DIC

Posted in 2010

Summary

A DBA on IDS 9.4 saw "Total number of dictionary entries: 99218" in onstat -g dic, with DD_HASHSIZE 503 and DD_HASHMAX 4, and asked whether that was a problem and how to tune the parameters. Others noted the count refers to tables (a correction about columns was retracted), and that the database only holds ~2000 tables. Art Kagel advised raising the settings in the ONCONFIG to DD_HASHSIZE 1013 and DD_HASHMAX 10, and also checking the data distribution cache (onstat -g dsc) in case it needs enlarging. No follow-up confirming the result is recorded.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Versions, Editions & End-of-Life

André Luiz Rufino — Fri, 01 Oct 2010 14:02:33 — source: IIUG Forums & Mailing Lists

Hi Everyone, First thing. IDS 9.4. My customer told me that the last line of onstat -g dic output is showing a big value of Total number of dictionary entries: Is almost 99.000 Question: Is that bad? How can I know if it's bad? And if it is, how can I set DD_HASHSIZE and DD_HASHMAX parameters. Thanks a lot, André Luiz

↪ replying to André Luiz Rufino

FRANK — Fri, 01 Oct 2010 19:17:28 — source: IIUG Forums & Mailing Lists

Can you send the output of your onstat -g dic? You can not set DD_HASHSIZE and DD_HASHMAX parameters in your onconfig file? Frank 2010/10/1 André Luiz Rufino <andre_rufino@msn.com> > Hi Everyone, > > First thing. IDS 9.4. My customer told me that the last line of onstat -g > dic > output is showing a big value of Total number of dictionary entries: > > Is almost 99.000 > > Question: Is that bad? How can I know if it's bad? And if it is, how can I > set > DD_HASHSIZE and DD_HASHMAX parameters. > > Thanks a lot, > > André Luiz > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001485f2d0d67305320491930bdb

↪ replying to FRANK

André Luiz Rufino — Fri, 01 Oct 2010 19:25:50 — source: IIUG Forums & Mailing Lists

Last Line Total number of dictionary entries: 99218 DD_HASHSIZE 503 DD_HASHMAX 4 Thanks > To: ids@iiug.org > From: yunyaoqu@gmail.com > Subject: Re: ONSTAT -G DIC [21508] > Date: Fri, 1 Oct 2010 15:17:29 -0400 > > Can you send the output of your onstat -g dic? > > You can not set DD_HASHSIZE and DD_HASHMAX parameters in your onconfig > file? > > Frank > > 2010/10/1 André Luiz Rufino <andre_rufino@msn.com> > > > Hi Everyone, > > > > First thing. IDS 9.4. My customer told me that the last line of onstat -g > > dic > > output is showing a big value of Total number of dictionary entries: > > > > Is almost 99.000 > > > > Question: Is that bad? How can I know if it's bad? And if it is, how can I > > set > > DD_HASHSIZE and DD_HASHMAX parameters. > > > > Thanks a lot, > > > > André Luiz > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001485f2d0d67305320491930bdb > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to André Luiz Rufino

FRANK — Fri, 01 Oct 2010 19:47:50 — source: IIUG Forums & Mailing Lists

If your applications are using around 99000 tables......., hmmm...... 2010/10/1 André Luiz Rufino <andre_rufino@msn.com> > Last Line > Total number of dictionary entries: 99218 > DD_HASHSIZE 503 > DD_HASHMAX 4> > Thanks > > > To: ids@iiug.org > > From: yunyaoqu@gmail.com > > Subject: Re: ONSTAT -G DIC [21508] > > Date: Fri, 1 Oct 2010 15:17:29 -0400 > > > > Can you send the output of your onstat -g dic? > > > > You can not set DD_HASHSIZE and DD_HASHMAX parameters in your onconfig > > file? > > > > Frank > > > > 2010/10/1 André Luiz Rufino <andre_rufino@msn.com> > > > > > Hi Everyone, > > > > > > First thing. IDS 9.4. My customer told me that the last line of onstat > -g > > > dic > > > output is showing a big value of Total number of dictionary entries: > > > > > > Is almost 99.000 > > > > > > Question: Is that bad? How can I know if it's bad? And if it is, how > can I > > > set > > > DD_HASHSIZE and DD_HASHMAX parameters. > > > > > > Thanks a lot, > > > > > > André Luiz > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001485f2d0d67305320491930bdb > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001485f2d0d611af9b049193786e

↪ replying to FRANK

Rogers Patterson — Fri, 01 Oct 2010 20:13:00 — source: IIUG Forums & Mailing Lists

I believe that represents columns not tables. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK Sent: Friday, October 01, 2010 2:48 PM To: ids@iiug.org Subject: Re: ONSTAT -G DIC [21511] If your applications are using around 99000 tables......., hmmm...... 2010/10/1 André Luiz Rufino <andre_rufino@msn.com> > Last Line > Total number of dictionary entries: 99218 > DD_HASHSIZE 503 > DD_HASHMAX 4> > Thanks > > > To: ids@iiug.org > > From: yunyaoqu@gmail.com > > Subject: Re: ONSTAT -G DIC [21508] > > Date: Fri, 1 Oct 2010 15:17:29 -0400 > > > > Can you send the output of your onstat -g dic? > > > > You can not set DD_HASHSIZE and DD_HASHMAX parameters in your onconfig > > file? > > > > Frank > > > > 2010/10/1 André Luiz Rufino <andre_rufino@msn.com> > > > > > Hi Everyone, > > > > > > First thing. IDS 9.4. My customer told me that the last line of onstat > -g > > > dic > > > output is showing a big value of Total number of dictionary entries: > > > > > > Is almost 99.000 > > > > > > Question: Is that bad? How can I know if it's bad? And if it is, how > can I > > > set > > > DD_HASHSIZE and DD_HASHMAX parameters. > > > > > > Thanks a lot, > > > > > > André Luiz > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001485f2d0d67305320491930bdb > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001485f2d0d611af9b049193786e ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to FRANK

André Luiz Rufino — Fri, 01 Oct 2010 20:15:23 — source: IIUG Forums & Mailing Lists

I don't even have those tables in database. In fact, all my database together has 2005 tables. > To: ids@iiug.org > From: yunyaoqu@gmail.com > Subject: Re: ONSTAT -G DIC [21511] > Date: Fri, 1 Oct 2010 15:47:51 -0400 > > If your applications are using around 99000 tables......., hmmm...... > > 2010/10/1 André Luiz Rufino <andre_rufino@msn.com> > > > Last Line > > Total number of dictionary entries: 99218 > > DD_HASHSIZE 503 > > DD_HASHMAX 4> > > > Thanks > > > > > To: ids@iiug.org > > > From: yunyaoqu@gmail.com > > > Subject: Re: ONSTAT -G DIC [21508] > > > Date: Fri, 1 Oct 2010 15:17:29 -0400 > > > > > > Can you send the output of your onstat -g dic? > > > > > > You can not set DD_HASHSIZE and DD_HASHMAX parameters in your onconfig > > > file? > > > > > > Frank > > > > > > 2010/10/1 André Luiz Rufino <andre_rufino@msn.com> > > > > > > > Hi Everyone, > > > > > > > > First thing. IDS 9.4. My customer told me that the last line of onstat > > -g > > > > dic > > > > output is showing a big value of Total number of dictionary entries: > > > > > > > > Is almost 99.000 > > > > > > > > Question: Is that bad? How can I know if it's bad? And if it is, how > > can I > > > > set > > > > DD_HASHSIZE and DD_HASHMAX parameters. > > > > > > > > Thanks a lot, > > > > > > > > André Luiz > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --001485f2d0d67305320491930bdb > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001485f2d0d611af9b049193786e > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Rogers Patterson

Rogers Patterson — Fri, 01 Oct 2010 20:16:32 — source: IIUG Forums & Mailing Lists

Where is that message recall button...? Yes tables it is. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Rogers Patterson Sent: Friday, October 01, 2010 3:13 PM To: ids@iiug.org Subject: RE: ONSTAT -G DIC [21512] I believe that represents columns not tables. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK Sent: Friday, October 01, 2010 2:48 PM To: ids@iiug.org Subject: Re: ONSTAT -G DIC [21511] If your applications are using around 99000 tables......., hmmm...... 2010/10/1 André Luiz Rufino <andre_rufino@msn.com> > Last Line > Total number of dictionary entries: 99218 > DD_HASHSIZE 503 > DD_HASHMAX 4> > Thanks > > > To: ids@iiug.org > > From: yunyaoqu@gmail.com > > Subject: Re: ONSTAT -G DIC [21508] > > Date: Fri, 1 Oct 2010 15:17:29 -0400 > > > > Can you send the output of your onstat -g dic? > > > > You can not set DD_HASHSIZE and DD_HASHMAX parameters in your onconfig > > file? > > > > Frank > > > > 2010/10/1 André Luiz Rufino <andre_rufino@msn.com> > > > > > Hi Everyone, > > > > > > First thing. IDS 9.4. My customer told me that the last line of onstat > -g > > > dic > > > output is showing a big value of Total number of dictionary entries: > > > > > > Is almost 99.000 > > > > > > Question: Is that bad? How can I know if it's bad? And if it is, how > can I > > > set > > > DD_HASHSIZE and DD_HASHMAX parameters. > > > > > > Thanks a lot, > > > > > > André Luiz > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001485f2d0d67305320491930bdb > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001485f2d0d611af9b049193786e ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to André Luiz Rufino

Art Kagel — Sun, 03 Oct 2010 04:17:54 — source: IIUG Forums & Mailing Lists

Try DD_HASHSIZE 1013 DD_HASHMAX 10 You should also take a serious look at the data distribution cache (onstat -g dsc) to see if that doesn't need to be increased as well. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. 2010/10/1 André Luiz Rufino <andre_rufino@msn.com> > Last Line > Total number of dictionary entries: 99218 > DD_HASHSIZE 503 > DD_HASHMAX 4> > Thanks > > > To: ids@iiug.org > > From: yunyaoqu@gmail.com > > Subject: Re: ONSTAT -G DIC [21508] > > Date: Fri, 1 Oct 2010 15:17:29 -0400 > > > > Can you send the output of your onstat -g dic? > > > > You can not set DD_HASHSIZE and DD_HASHMAX parameters in your onconfig > > file? > > > > Frank > > > > 2010/10/1 André Luiz Rufino <andre_rufino@msn.com> > > > > > Hi Everyone, > > > > > > First thing. IDS 9.4. My customer told me that the last line of onstat > -g > > > dic > > > output is showing a big value of Total number of dictionary entries: > > > > > > Is almost 99.000 > > > > > > Question: Is that bad? How can I know if it's bad? And if it is, how > can I > > > set > > > DD_HASHSIZE and DD_HASHMAX parameters. > > > > > > Thanks a lot, > > > > > > André Luiz > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001485f2d0d67305320491930bdb > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00163630f62bff58950491aeb557

ONSTAT -G DIC

Related threads

Glossary

Your privacy choices