IDS Forum

Re: IDS 12.10 - Query Slow

Posted By: Art Kagel
Date: Friday, 11 November 2016, at 11:17 a.m.

In Response To: Re: IDS 12.10 - Query Slow (MOHD FADZIL JUSOH)

OK ...

Without a restart you can add AIO VPs with:

onmode -p +5 aio
(similarly you can drop aio vps with: onmode -p -<N> aio to remove <N> aio
vps)

In the ONCONFIG, under v11.10 the NUMAIOVPS parameter is still active, so
you could change:
NUMAIOVPS 31 to NUMAIOVPS 36

On either 11.10 or 12.10, you can use the newer VPCLASS parameter to
configure any VP class, so:

VPCLASS aio,num=36,noage ## The 'noage' option is important on AIX and
HPUX to prevent the

aggressive process
aging that happens in those OSes. Other

UNIXes like Linux &
MacOS are less aggressive, but setting noage

is still a good idea.
The AUTO_AIOVPS parameter controls whether Informix automatically tries to
add and drop AIO VPs as needed. You can set this to '1' to enable it. It is
harmless, but setting it doesn't mean you do not have to manually monitor
and tune the AIO VPs because this autonomic setting is often too slow to
respond to peak loads, so having the number of AIO VPs properly set in the
first place is important. Then you can rely on AUTO_AIOVPS to adjust their
number if you hit an unusual load peak.

Art

Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com

Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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.

On Fri, Nov 11, 2016 at 9:30 AM, MOHD FADZIL JUSOH <fadzil@isianpadu.com>
wrote:

> Hi,
>
> Look like i need to test it on our environment and determined which one is
> better, i will do it.
>
> I have given you advice on tuning the AIO VPs while DIRECT_IO is disabled.
> - Let me try this first, tuning on AIO VPs, How to do it? What value i
> need to
> set it?
>
> I noticed that different value for both version.
> on version 11.10
> #NUMAIOVPS
> and version 12.10 have AUTO_AIOVPS parameter.
> # AUTO_AIOVPS - Enables (1) or disables (0) automatic management
>
> I just enable or assign value for this parameter (auto)aiovps? Required
> database restart after change parameter to take effect?
>
> Please advice
>
> Thank You
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--bcaec508f4bcf3f7c1054108d139

Messages In This Thread

• IDS 12.10 - Query Slow
  MOHD FADZIL JUSOH -- Wednesday, 9 November 2016, at 9:04 a.m.
  • Re: IDS 12.10 - Query Slow
    Fernando Nunes -- Wednesday, 9 November 2016, at 9:12 a.m.
    • Re: IDS 12.10 - Query Slow
      MOHD FADZIL JUSOH -- Wednesday, 9 November 2016, at 9:28 a.m.
      • Re: IDS 12.10 - Query Slow
        Art Kagel -- Wednesday, 9 November 2016, at 9:37 a.m.
        • RE: IDS 12.10 - Query Slow
          Everett Mills -- Wednesday, 9 November 2016, at 10:14 a.m.
        • Re: IDS 12.10 - Query Slow
          MOHD FADZIL JUSOH -- Thursday, 10 November 2016, at 9:49 a.m.
          • Re: IDS 12.10 - Query Slow
            Art Kagel -- Thursday, 10 November 2016, at 11:34 a.m.
            • Re: IDS 12.10 - Query Slow
              MOHD FADZIL JUSOH -- Friday, 11 November 2016, at 3:02 a.m.
              • Re: IDS 12.10 - Query Slow
                Art Kagel -- Friday, 11 November 2016, at 6:52 a.m.
                • RE: IDS 12.10 - Query Slow
                  Paul Watson -- Friday, 11 November 2016, at 8:44 a.m.
                  • Re: IDS 12.10 - Query Slow
                    Fernando Nunes -- Friday, 11 November 2016, at 8:55 a.m.
                    • Re: IDS 12.10 - Query Slow
                      MOHD FADZIL JUSOH -- Friday, 11 November 2016, at 9:14 a.m.
                      • Re: IDS 12.10 - Query Slow
                        Art Kagel -- Friday, 11 November 2016, at 9:19 a.m.
                        • Re: IDS 12.10 - Query Slow
                          MOHD FADZIL JUSOH -- Friday, 11 November 2016, at 9:30 a.m.
                          • Re: IDS 12.10 - Query Slow
                            Art Kagel -- Friday, 11 November 2016, at 11:17 a.m.
    • Re: IDS 12.10 - Query Slow
      Alexandre Marini -- Wednesday, 9 November 2016, at 10:01 a.m.
      • Re: IDS 12.10 - Query Slow
        MOHD FADZIL JUSOH -- Thursday, 10 November 2016, at 9:57 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.