IDS Forum

Re: what is waiting for

Posted By: ART KAGEL, BLOOMBERG/ 731 LEXIN
Date: Wednesday, 18 January 2006, at 6:09 p.m.

In Response To: Re: what is waiting for (Néstor Gómez Muñoz)

No sweat. Keep pounding away at understanding, that's how most of us got what
little knowledge we have.

Art
----- Original Message -----
From: N•Stor G•Me.... <ids@iiug.org>
At: 1/13 13:01

thanks Rob and Art for your comments.
This is not a 'problem' indeed, is a rather of 'trying to understand
the status of processes on IDS'.=20

Everything begun when I had a real problem: I ran onbar and cancel it=
,
then the process stay locked on 'cleaning' steep. After 10 hours I tr=
y
to find what was doing the process for so long time and finished kill=
ing
them with onmode -z ID. After that, I started to testing commands and
reading manuals to find out tools to know the state of processes.

This thread and session took my attention because the number of locks
was 31, so I was looking why.

Thanks again. I will ask about my real problems on onbar, on another
post.

--Nestor

El vie, 13-01-2006 a las 12:25 -0500, ART KAGEL, .... escribi=C3=B3:
> Waiting on a netnorm condition usually means that the thread is wai=
ting for=20
> the=20
> client task to make a new request. Basically the thread is idle. Wh=
y the=20
> concern? What's the 'problem' you're trying to track down?=20
>=20
> Art S. Kagel=20
>=20
> ----- Original Message -----=20
> From: NStor GMe.... <ids@iiug.org>=20
> At: 1/13 12:14=20
>=20
> I'd like to find out what is a session waiting for. I will apprecia=
te=20
> any cues to follow. Thanks in advance to the forum comunity.=20
> This is what I have:=20
>=20
> onstat -u=20
> ....=20
> 343ebe88 Y--P--- 29111 sigedw DELL 37b87588 0=20
> 31 54 0=20
> ....=20
>=20
> onstat -g con |grep 37b87588=20
> 10965 37b87588 netnorm 29178 5156=20
>=20
> aditional information:=20
>=20
> onstat -g ses 29111=20
>=20
> IBM Informix Dynamic Server Version 9.40.FC2 -- On-Line -- Up=20
> 12:30:43 -- 1202176 Kbytes=20
>=20
> session #RSAM total used=20
> dynamic=20
> id user tty pid hostname threads memory memory=20
> explain=20
> 29111 sigedw DELL 352 10.13.65 1 69632 48008=20
> off=20
>=20
> tid name rstcb flags curstk status=20
> 29178 sqlexec 343ebe88 Y--P--- 5951 cond wait(netnorm)=20
>=20
> Memory pools count 1=20
> name class addr totalsize freesize #allocfrag=20
> #freefrag=20
> 29111 V 39369040 69632 21624 100 17=20
>=20
> name free used name free used=20
> overhead 0 3248 scb 0 144=20
> opentable 0 4712 filetable 0 1264=20
> log 0 2184 temprec 0 3960=20
> keys 0 208 gentcb 0 2064=20
> ostcb 0 2864 sort 0 104=20
> sqscb 0 18928 sql 0 72=20
> rdahead 0 1856 hashfiletab 0 552=20
> osenv 0 1320 sqtcb 0 4152=20
> fragman 0 376=20
>=20
> sqscb info=20
> scb sqscb optofc pdqpriority sqlstats=20
> optcompind directives=20
> 3859c050 3936a028 0 0 0 2=20
> 1=20
>=20
> Sess SQL Current Iso Lock SQL ISAM F.E.=20
> Id Stmt type Database Lvl Mode ERR ERR Vers=20
> Explain=20
> 29111 - siad RR Not Wait 0 0=20
>=20
>=20
> *******************************************************************=
************=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=
=20
>=20
>=20
> *******************************************************************=
************=20
> Forum Note: Use "Reply" to post a response in the discussion foru=
m.=20
>=20

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

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.