Unix Technical Forum

Priority aging

This is a discussion on Priority aging within the Informix forums, part of the Database Server Software category; --> Question for the group. Does IDS 9.4 priority age long running sessions inside the database engine? I know you ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 12:44 PM
cgates
 
Posts: n/a
Default Priority aging

Question for the group. Does IDS 9.4 priority age long running
sessions inside the database engine? I know you can set the NOAGE
parameter to keep the OS from aging the oninit processes when they are
scheduled on the physical CPUs. But does IDS age any of the user
sessions when scheduling them onto the CPUvps?

I ask this because I have a daemon process that gets really slow after
several days. The OS ages the process about 20% (nice 20 to 24). But
when I stop and restart the process it gets more than 20% faster again.
More like 200%.

There is pleanty of idle CPU when it gets slow and no I/O waits.

Love to hear peoples thoughts.

Corey

AIX 5.3-TL4
IDS 9.4 FC6

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 12:44 PM
andrewford@austin.rr.com
 
Posts: n/a
Default Re: Priority aging

I don't think the engine does anything like that. The poor performance
has to be caused by something else.

Could the OS aging of your daemon process be causing the problem even
if there appears to be pleny of CPU cycles available?

Andrew

cgates wrote:
> Question for the group. Does IDS 9.4 priority age long running
> sessions inside the database engine? I know you can set the NOAGE
> parameter to keep the OS from aging the oninit processes when they are
> scheduled on the physical CPUs. But does IDS age any of the user
> sessions when scheduling them onto the CPUvps?
>
> I ask this because I have a daemon process that gets really slow after
> several days. The OS ages the process about 20% (nice 20 to 24). But
> when I stop and restart the process it gets more than 20% faster again.
> More like 200%.
>
> There is pleanty of idle CPU when it gets slow and no I/O waits.
>
> Love to hear peoples thoughts.
>
> Corey
>
> AIX 5.3-TL4
> IDS 9.4 FC6


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-20-2008, 12:45 PM
bozon
 
Posts: n/a
Default Re: Priority aging

You of course set the NOAGE parameter, don't you? (I couldn't quite
tell from your post.)
cgates wrote:
> Question for the group. Does IDS 9.4 priority age long running
> sessions inside the database engine? I know you can set the NOAGE
> parameter to keep the OS from aging the oninit processes when they are
> scheduled on the physical CPUs. But does IDS age any of the user
> sessions when scheduling them onto the CPUvps?
>
> I ask this because I have a daemon process that gets really slow after
> several days. The OS ages the process about 20% (nice 20 to 24). But
> when I stop and restart the process it gets more than 20% faster again.
> More like 200%.
>
> There is pleanty of idle CPU when it gets slow and no I/O waits.
>
> Love to hear peoples thoughts.
>
> Corey
>
> AIX 5.3-TL4
> IDS 9.4 FC6


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

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 10:03 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com