CPU usage at 100% Identifying the culprit

SLES 10 SP2 & IDS 10.0 HC9 I have a process somewhere that is running the oninit process at 100% across all 6 of the VPUs that I have set up. I know that in IDS 11.something you can look at processes inside of informix to determine their usage using onstat -g cpu (or something like that), but is there anything like that in 10? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu <mailto:jonathon.wyza@bethelcollege.edu> ========================== SLES 10 SP2 & IDS 10.0 HC9 " I would love to change the world, but they won't give me the source code." -- Unknown

Try running onstat -g mgm. It will identify any active sessions that are using MGM memory. These are the most likely suspects. Once you know the session id you can run onstat -g ses to see the session details including the pid and the last two SQL statements it has run. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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, 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. On Wed, Feb 24, 2010 at 3:31 PM, Wyza, Jonathon <wyzaj@bethelcollege.edu>wrote: > SLES 10 SP2 & IDS 10.0 HC9 > > I have a process somewhere that is running the oninit process at 100% > across all 6 of the VPUs that I have set up. I know that in IDS > 11.something you can look at processes inside of informix to determine > their usage using onstat -g cpu (or something like that), but is there > anything like that in 10? > > Jonathon Wyza > > CX & CBORD System Administrator > > CX Programmer/Analyst > > Administrative Computing > > Bethel College > > (574)-257-3381 > > AIM: Iamwyza > > jonathon.wyza@bethelcollege.edu <mailto:jonathon.wyza@bethelcollege.edu> > > ========================== > > SLES 10 SP2 & IDS 10.0 HC9 > > " I would love to change the world, but they won't give me the source > code." -- Unknown > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517402a0a40dc2b04805eea89

To identify this issues before v11 , I use the command "onstat -g act -r 1" +awk '{ print $1}' + "uniq -c" +"sort -nk1" (this is just a draft of the commands...) With this , you get the number of times the threads appear running in the last seconds . This is useful only if you have a specific session consuming all CPU Just include a select in sysuserthreads in your shell and you have the sessions and usernames: unload to $vTmp1 delimiter " " select us_tid as tid , us_sid as sid , us_name as user from sysuserthreads Isn't 100% accurate , but's help in certain situations. César --- Em qua, 24/2/10, Wyza, Jonathon <wyzaj@bethelcollege.edu> escreveu: De: Wyza, Jonathon <wyzaj@bethelcollege.edu> Assunto: CPU usage at 100% Identifying the culprit [19117] Para: ids@iiug.org Data: Quarta-feira, 24 de Fevereiro de 2010, 17:31 SLES 10 SP2 & IDS 10.0 HC9 I have a process somewhere that is running the oninit process at 100% across all 6 of the VPUs that I have set up. I know that in IDS 11.something you can look at processes inside of informix to determine their usage using onstat -g cpu (or something like that), but is there anything like that in 10? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu <mailto:jonathon.wyza@bethelcollege.edu> ========================== SLES 10 SP2 & IDS 10.0 HC9 " I would love to change the world, but they won't give me the source code." -- Unknown ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ____ Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com