Waits cond wait netnorm and IO Wait

Hi IIUG First of all i would like to say that the work that is done here is very good and with quality. I started with database Informix 4 mounths ago and i have a few questions: I would like to know which are the waits and latchs that most affect my database. I'm using the command "onstat -g ath" and had in return many "cond wait netnorm" and a "IO Wait" in user proceses. Besides a few "sleeping forever" on the processes of Listener on the database. My question is: what are these Waits? which is the correct way to collect them? Where can i find documentation about them? Enviroment: SUN Solaris Informix 11.50.FC4 Best regards Luciano

Netnorm is the engine waiting for the user to enter a request. Could be between SQL or waiting for a FETCH on an open cursor. Iowait is waiting for the asynchronous IO mechanisms to return data. Sleeping forever happens when a Netnorm wait condition lasts a long time. The thread suspends itself and waits to be awakened by one of the listener threads. 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 Mon, Jan 11, 2010 at 5:09 AM, LUCIANO ALVARENGA < lucianoalvarenga@gmail.com> wrote: > Hi IIUG > > First of all i would like to say that the work that is done here is very > good > and with quality. > > I started with database Informix 4 mounths ago and i have a few questions: > I would like to know which are the waits and latchs that most affect my > database. > I'm using the command "onstat -g ath" and had in return many "cond wait > netnorm" and a "IO Wait" in user proceses. > Besides a few "sleeping forever" on the processes of Listener on the > database. > > My question is: what are these Waits? which is the correct way to collect > them? Where can i find documentation about them? > > Enviroment: SUN Solaris > Informix 11.50.FC4 > > Best regards > Luciano > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174481f8a249ff047ce0e906

Is there a possibility that I collect this data through SQL, thus making an automatic trace waits to acquire these in my environment. Where do I find more information about waits and latchs?

This has already been done for you. Currently IDS will sample every 4 hours and keep the information for 7 days the user on the system and store their statistics in a table. The table is in the sysadmin database in a table called mon_users. The wait reason is stored in a column called wreason. If you want to change the sample rate or how long the information is stored you can use OAT (www.openadmintool.org). or update the sysadmin database ph_task table directly. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 01/11/2010 08:53:38 AM: > [image removed] > > Re: Waits cond wait netnorm and IO Wait [18646]: > > LUCIANO ALVARENGA > > to: > > ids > > 01/11/2010 08:54 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Is there a possibility that I collect this data through SQL, thus making an > automatic trace waits to acquire these in my environment. > > Where do I find more information about waits and latchs? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >