IDS Forum

Re: IDS 11.5 Procedures slow at seemningly ran....

Posted By: George Karabotsos
Date: Thursday, 17 December 2009, at 11:07 a.m.

In Response To: Re: IDS 11.5 Procedures slow at seemningly random (Art Kagel)

My apologies for the ommission :).

DB version: IDS 11.5
System info:
$ uname -a
Linux xxxx 2.6.9-42.ELlargesmp #1 SMP Wed Jul 12 23:46:39 EDT 2006
x86_64 x86_64 x86_64 GNU/Linux

George

On Thu, Dec 17, 2009 at 8:02 AM, Art Kagel <art.kagel@gmail.com> wrote:
> PLEASE PLEASE PLEASE ALWAYS post your IDS version and platform information
> when you post!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> There's not much to go on here. It could be something as common but
> esoteric as the Btree Cleaners/Scanners (depending on IDS version - SEE WHY
> YOU HAVE TO POST VERSION INFO?) waking up with lots of work to do, or under
> or inefficiently configured or it could be as simple as there's a batch job
> that's completely unrelated to the database but it shares IO resources
> (disks, controllers, channels, low level SAN cache) with the IDS instance,
> or your IDS chunks are COOKED and such system load is sharing the system
> buffer cache. It could be as weird as your release of IDS has some old bug
> that we know about, but without version info we couldn't say. Could be that
> another periodic large database task is flushing the data that this
> procedure needs out of the cache sometimes but other times the Perl script
> you are concerned about runs before the batch job. Or perhaps the script
> NEEDS the data that some other batch process loads into the cache and
> sometimes its not there. It could be lots of things.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> See you at the 2010 IIUG Informix Conference
> April 25-28, 2010
> Overland Park (Kansas City), KS
> www.iiug.org/conf
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. 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 Thu, Dec 17, 2009 at 10:52 AM, George Karabotsos <karabot@gmail.com>wrote:
>
>> Hello all,
>>
>> I have been spending a bit of time investigating a problem I have with
>> a couple of my SPL procedures. To give you some background. I have
>> two SPLs that are invoked through a Perl script every 10 min. Three
>> to seven times every 24 hour period (at seemingly random times) these
>> procedures run slowly, some times they take a few minutes to complete,
>> when all the other times it takes 10 seconds or less. I went into a
>> search to find out whether exclusive locks exist the cause the
>> slowdown--I was not able to find much and I was able to see that all
>> our DB work is started with
>> SET ISOLATION TO DIRTY READ;
>> SET LOCK MODE TO WAIT 5;
>> which seems reasonable.
>>
>> What has attracted my attention is that execution from the script in
>> the slow runs take 8+ seconds, sometimes even 14 seconds when in the
>> normal cases it takes less than a second. So I am thinking whether
>> this is a more general problem of DB load for one reason or another at
>> those times.
>>
>> Has anyone of you experienced similar slowdowns? Any hints, ideas
>> will be appreciated.
>>
>> TIA,
>> George
>>
>>
>>
>>
> *******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>
> --0023545bd494ca357a047aeec0ee
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

Messages In This Thread

• IDS 11.5 Procedures slow at seemningly random time
  George Karabotsos -- Thursday, 17 December 2009, at 10:52 a.m.
  • Re: IDS 11.5 Procedures slow at seemningly random
    George Karabotsos -- Thursday, 17 December 2009, at 10:56 a.m.
    • Re: IDS 11.5 Procedures slow at seemningly ran....
      Art Kagel -- Thursday, 17 December 2009, at 11:11 a.m.
      • Re: IDS 11.5 Procedures slow at seemningly ran....
        George Karabotsos -- Thursday, 17 December 2009, at 11:30 a.m.
        • Re: IDS 11.5 Procedures slow at seemningly ran....
          Art Kagel -- Thursday, 17 December 2009, at 12:31 p.m.
  • Re: IDS 11.5 Procedures slow at seemningly random
    Art Kagel -- Thursday, 17 December 2009, at 11:02 a.m.
    • Re: IDS 11.5 Procedures slow at seemningly ran....
      George Karabotsos -- Thursday, 17 December 2009, at 11:07 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.