IDS Forum

Re: View thread info?

Posted By: Art Kagel
Date: Monday, 14 July 2008, at 11:32 a.m.

In Response To: View thread info? (BART GROOT)

The table sysrstcb maps session id (sid) to the threads working for that
session (tid). You can then also look in systhreads for more thread detail
from the systhreads view or the underlying systcplst table.

onstat -g rea shows only threads ready to run that are waiting for a VP to
run them, not acctively running threads.

Art

On Mon, Jul 14, 2008 at 8:35 AM, BART GROOT <bart.groot@corusgroup.com>
wrote:

> Hi Experts,
>
> We use an informix database as database layer for an ERP application. We
> encounter high CPU usage of the informix server while the ERP application
> is
> hardly used (low number of active users). The high CPU load always starts
> at
> the same timepoint in the morning and ends always at the same timepoint in
> the
> evening, suggesting a scheduled action. However, the ERP application
> support
> team cannot find anything from within the application. Therefor I would
> like
> to find more information on the database level.
>
> We have configured a system with 2 CPU vp's. When looking at the active
> threads I see the CPU vp's to be constantly busy:
>
> $ onstat -g act
>
> IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up 11 days
> 05:43:52 -- 1033008 Kbytes
>
> Running threads:
> tid tcb rstcb prty status vp-class name
> 8 700000040e44538 0 2 running 1cpu sm_poll
> 9 700000040e731d8 0 2 running 9soc soctcppoll
> 71276 7000000474fa028 700000043135820 2 running 3cpu sqlexec
>
> The 1cpu vp is switching between sm_poll and sqlexec. The 3cpu is always
> doing
> sqlexec and is causing the major part of the system load.
>
> When running onstat -g rea I see no queueing of threads.
>
> Is there any way in which I can find out what the cpu vp is doing for each
> thread? e.g. Can I revert a thread id to a session to find out what SQL is
> being ran by which user?
>
> I will try to stop the ERP application to see if the CPU usage lowers. If
> not,
> could it be something Informix internal?
>
> Does anyone have more suggestions on how to approach and investigate such
> issues?
>
> Thanks,
>
> Regards,
> Bart.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Art S. Kagel
Oninit (www.oninit.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, 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.

Messages In This Thread

• View thread info?
  BART GROOT -- Monday, 14 July 2008, at 8:35 a.m.
  • Re: View thread info?
    SHANOOF BASHEER -- Monday, 14 July 2008, at 9:41 a.m.
    • RE: View thread info?
      Sebastian, Norma J. -- Monday, 14 July 2008, at 10:02 a.m.
  • Re: View thread info?
    Art Kagel -- Monday, 14 July 2008, at 11:32 a.m.
  • Re: View thread info?
    BART GROOT -- Tuesday, 15 July 2008, at 12:44 a.m.
    • Re: View thread info?
      SHANOOF BASHEER -- Tuesday, 15 July 2008, at 3:52 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.