IDS Forum

RE: what is waiting for

Posted By: Esteban Casuscelli
Date: Saturday, 14 January 2006, at 2:50 p.m.

In Response To: RE: what is waiting for (Schmitz, Rob B [IBM Contractor for Sprint])

Yes, you are right.

Basically the "Y" flag in the first position of an
onstat -u or ( cond wait netnorm )means that there is
nothing to do on the server side ( database server )
and the session is waiting for new messages from the
client side ( in your example dbaccess ).

esteban.-
--- "Schmitz, Ro...." <Rob.B.Schmitz@sprint.com>
escribió:

>
> As I understand it, when the status on onstat -g ses
> is "cond wait(netnorm)"
> that means the engine has completed everything the
> session requested and the
> engine is now waiting for the session to make
> another request. The session is
> not waiting on anything. This would be the situation
> if you were in dbaccess
> and issued an SQL statement and the statement has
> completed but you are still
> in dbaccess and have not closed your session. The
> engine is still waiting on
> you.
>
> Rob Schmitz
> Informix DBA
> rob.b.schmitz@sprint.com
> schmitzr@us.ibm.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org
> [mailto:ids-bounces@iiug.org] On Behalf Of Néstor
> Góme....
> Sent: Friday, January 13, 2006 11:15 AM
> To: ids@iiug.org
> Subject: what is waiting for [6206]
>
> I'd like to find out what is a session waiting for.
> I will appreciate
> any cues to follow. Thanks in advance to the forum
> comunity.
> This is what I have:
>
> onstat -u
> .....
> 343ebe88 Y--P--- 29111 sigedw DELL 37b87588 0
> 31 54 0
> .....
>
> onstat -g con |grep 37b87588
> 10965 37b87588 netnorm 29178 5156
>
> aditional information:
>
> onstat -g ses 29111
>
> IBM Informix Dynamic Server Version 9.40.FC2 --
> On-Line -- Up
> 12:30:43 -- 1202176 Kbytes
>
> session #RSAM total used
> dynamic
> id user tty pid hostname threads memory memory
> explain
> 29111 sigedw DELL 352 10.13.65 1 69632 48008
> off
>
> tid name rstcb flags curstk status
> 29178 sqlexec 343ebe88 Y--P--- 5951 cond
> wait(netnorm)
>
> Memory pools count 1
> name class addr totalsize freesize #allocfrag
> #freefrag
> 29111 V 39369040 69632 21624 100 17
>
> name free used name free used
> overhead 0 3248 scb 0 144
> opentable 0 4712 filetable 0 1264
> log 0 2184 temprec 0 3960
> keys 0 208 gentcb 0 2064
> ostcb 0 2864 sort 0 104
> sqscb 0 18928 sql 0 72
> rdahead 0 1856 hashfiletab 0 552
> osenv 0 1320 sqtcb 0 4152
> fragman 0 376
>
> sqscb info
> scb sqscb optofc pdqpriority sqlstats
> optcompind directives
> 3859c050 3936a028 0 0 0 2
> 1
>
> Sess SQL Current Iso Lock SQL ISAM F.E.
> Id Stmt type Database Lvl Mode ERR ERR Vers
> Explain
> 29111 - siad RR Not Wait 0 0
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
>
>

___________________________________________________________
1GB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar

Messages In This Thread

• what is waiting for
  Néstor Gómez Muñoz -- Friday, 13 January 2006, at 12:14 p.m.
  • RE: what is waiting for
    Schmitz, Rob B [IBM Contractor for Sprint] -- Friday, 13 January 2006, at 12:22 p.m.
    • RE: what is waiting for
      Esteban Casuscelli -- Saturday, 14 January 2006, at 2:50 p.m.
  • Re: what is waiting for
    ART KAGEL, BLOOMBERG/ 731 LEXIN -- Friday, 13 January 2006, at 12:25 p.m.
    • Re: what is waiting for
      Néstor Gómez Muñoz -- Friday, 13 January 2006, at 1:02 p.m.
      • Re: what is waiting for
        ART KAGEL, BLOOMBERG/ 731 LEXIN -- Wednesday, 18 January 2006, at 6:09 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.