onstat -g ath
Marco asked where the "status" column of onstat -g ath is documented, puzzled that all sqlexec threads showed "cond wait netnorm" while onstat -g sql showed plenty of active SQL. Madison Pruet explained that cond wait netnorm simply means the thread is waiting for network traffic from the client (e.g. an ACK or next request) and that -g ath and -g sql are unrelated views. Philippe Pignon added that it is normal, not a performance symptom, and pointed to oninit.com's onstat reference. Marco then said his real issue is the server appearing to hang and asked how to find the culprit thread; no answer to that is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Where I can found a documentation for the column "status" of this output?
example: cond wait netnorm
on a other screen with "onstat -g sql [sid] -r 2" I see many SQL command.
C:\\\\>onstat -g ath | grep sql
File STDIN:
35 1e09bdb8 1d816e7c 2 cond wait netnorm 1cpu qlexec
37 1dd110c8 1d8180b8 2 cond wait netnorm 1cpu sqlexec
39 1dd2a228 1d8186cc 2 cond wait netnorm 1cpu sqlexec
41 1dd84568 1d8192f4 2 cond wait netnorm 1cpu sqlexec
55 1e13d070 1d819908 2 cond wait netnorm 1cpu sqlexec
83 1f377a58 1d81a530 2 cond wait netnorm 1cpu sqlexec
94 1f1771a8 1d81b158 2 cond wait netnorm 1cpu sqlexec
122 1dc9f068 1d81c394 2 cond wait netnorm 1cpu sqlexec
123 1f72de18 1d81bd80 2 cond wait netnorm 1cpu sqlexec
160 1ea646e0 1d81cfbc 2 cond wait netnorm 1cpu sqlexec
618 20db9228 1d81b76c 2 cond wait netnorm 1cpu sqlexec
699 1ebb3930 1d819f1c 2 cond wait netnorm 1cpu sqlexec
1025 1e18e580 1d81c9a8 2 cond wait netnorm 1cpu sqlexec
1051 1ddd4c68 1d818ce0 2 cond wait netnorm 1cpu sqlexec
1304 1f2dcbb0 1d81ee20 2 cond wait netnorm 1cpu sqlexec
C:\\\\>
Thanks
Marco Schwarz
It means that the thread is waiting on the condition. netnorm (network=
normal). That meand that the thread is waiting for somthing to be sent=
from the client.
=
"Marco Schwarz" =
<marco.schwarz@ro =
lmail.net> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
onstat -g ath [6615] =
04/28/2006 10:34 =
AM =
=
=
Please respond to =
ids@iiug.org =
=
=
Where I can found a documentation for the column "status" of this outpu=
t?
example: cond wait netnorm
on a other screen with "onstat -g sql [sid] -r 2" I see many SQL comman=
d.
C:\\\\>onstat -g ath | grep sql
File STDIN:
35 1e09bdb8 1d816e7c 2 cond wait netnorm 1cpu qlexec
37 1dd110c8 1d8180b8 2 cond wait netnorm 1cpu sqlexec
39 1dd2a228 1d8186cc 2 cond wait netnorm 1cpu sqlexec
41 1dd84568 1d8192f4 2 cond wait netnorm 1cpu sqlexec
55 1e13d070 1d819908 2 cond wait netnorm 1cpu sqlexec
83 1f377a58 1d81a530 2 cond wait netnorm 1cpu sqlexec
94 1f1771a8 1d81b158 2 cond wait netnorm 1cpu sqlexec
122 1dc9f068 1d81c394 2 cond wait netnorm 1cpu sqlexec
123 1f72de18 1d81bd80 2 cond wait netnorm 1cpu sqlexec
160 1ea646e0 1d81cfbc 2 cond wait netnorm 1cpu sqlexec
618 20db9228 1d81b76c 2 cond wait netnorm 1cpu sqlexec
699 1ebb3930 1d819f1c 2 cond wait netnorm 1cpu sqlexec
1025 1e18e580 1d81c9a8 2 cond wait netnorm 1cpu sqlexec
1051 1ddd4c68 1d818ce0 2 cond wait netnorm 1cpu sqlexec
1304 1f2dcbb0 1d81ee20 2 cond wait netnorm 1cpu sqlexec
C:\\\\>
Thanks
Marco Schwarz
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
ok, but if I make onstat -g sql [sid] -r 2 I see many output
IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up
12:16:04 -- 366464 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
597 EXEC PROCEDURE db1 DR Wait 5 0 0 9.03 Off
Current statement name : cn56094
Current SQL statement :
EXECUTE PROCEDURE spinct(?, ?, 'B', ?, NULL, NULL, NULL, 'B', 'J', 'N',
?)
Host variables :
address type flags value
---------------------------------
0x1E0D9020 VCHAR 0x000 135102
0x1E0D9088 VCHAR 0x000 135102
0x1E0D90F0 VCHAR 0x000 EUR
0x1E0D9158 VCHAR 0x000 J
Last parsed SQL statement :
EXECUTE PROCEDURE spinct(?, ?, 'B', ?, NULL, NULL, NULL, 'B', 'J', 'N',
?)
IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up
12:16:52 -- 366464 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
597 db1 DR Wait 5 0 0 9.03 Off
Stored procedure stack :
context proc-counter opcode name
-------------------------------------------------------
0x1ee0e838 0x2087bfe4+0x0008 EXPR verkauf:spchgbetrag
0x1fff3088 0x1eb70f70-0x0020 CURNEXT verkauf:spubuchbetr
0x1f9d0030 0x1df9ad34+0x0008 SQL verkauf:spumwende
Last parsed SQL statement :
EXECUTE PROCEDURE spumwende(?, ?, 'B', ?, NULL, NULL, NULL, 'B', 'J', 'N',
?)
IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up
12:16:54 -- 366464 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
597 - db1 DR Wait 5 0 0 9.03 Off
Last parsed SQL statement :
UPDATE table SET lastupd = "P" || CURRENT YEAR TO FRACTION(5) || USER
WHERE lfndkode = 136505
so I can say that the IDS ist working and not waiting.
thx
Marco
Madison Pruet schrieb:
> It means that the thread is waiting on the condition. netnorm (network=
>
> normal). That meand that the thread is waiting for somthing to be sent=
>
> from the client.
>
> =
>
> "Marco Schwarz" =
>
> <marco.schwarz@ro =
>
> lmail.net> =
> To
>
> Sent by: ids@iiug.org =
>
> ids-bounces@iiug. =
> cc
>
> org =
>
> Subj=
> ect
>
> onstat -g ath [6615] =>
> 04/28/2006 10:34 =
>
> AM =
>
> =
>
> =
>
> Please respond to =
>
> ids@iiug.org =
>
> =
>
> =
>
> Where I can found a documentation for the column "status" of this outpu=
> t?
>
> example: cond wait netnorm
>
> on a other screen with "onstat -g sql [sid] -r 2" I see many SQL comman=
> d.
>
> C:\\\\>onstat -g ath | grep sql
> File STDIN:
> 35 1e09bdb8 1d816e7c 2 cond wait netnorm 1cpu qlexec
> 37 1dd110c8 1d8180b8 2 cond wait netnorm 1cpu sqlexec
> 39 1dd2a228 1d8186cc 2 cond wait netnorm 1cpu sqlexec
> 41 1dd84568 1d8192f4 2 cond wait netnorm 1cpu sqlexec
> 55 1e13d070 1d819908 2 cond wait netnorm 1cpu sqlexec
> 83 1f377a58 1d81a530 2 cond wait netnorm 1cpu sqlexec
> 94 1f1771a8 1d81b158 2 cond wait netnorm 1cpu sqlexec
> 122 1dc9f068 1d81c394 2 cond wait netnorm 1cpu sqlexec
> 123 1f72de18 1d81bd80 2 cond wait netnorm 1cpu sqlexec
> 160 1ea646e0 1d81cfbc 2 cond wait netnorm 1cpu sqlexec
> 618 20db9228 1d81b76c 2 cond wait netnorm 1cpu sqlexec
> 699 1ebb3930 1d819f1c 2 cond wait netnorm 1cpu sqlexec
> 1025 1e18e580 1d81c9a8 2 cond wait netnorm 1cpu sqlexec
> 1051 1ddd4c68 1d818ce0 2 cond wait netnorm 1cpu sqlexec
> 1304 1f2dcbb0 1d81ee20 2 cond wait netnorm 1cpu sqlexec
>
> C:\\\\>
>
> Thanks
> Marco Schwarz
>
> ***********************************************************************=
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> =
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
There is no direct relationship between onstat -g ath and onstat -g sql=
.
The netnorm condition does NOT mean that the server is waiting for an s=
ql
statement to be issued, it simply means that the server is waiting for =
some
network traffic from the client. It might, for instance, mean that the=
server is waiting to receive an ACK that the client received the last
buffer which was transmitted to it, or it might be waiting for the clie=
nt
to request the next buffer.
onstat -g sql shows the last and current statements, but it does not sh=ow
the the network traffic between the server and the client as the statem=
ent
is being executed.
cond netnorm simply means that the server is waiting for some network
traffic from the client.
=
"Marco Schwarz" =
<marco.schwarz@ro =
lmail.net> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Re: onstat -g ath [6617] =
04/28/2006 10:50 =
AM =
=
=
Please respond to =
ids@iiug.org =
=
=
ok, but if I make onstat -g sql [sid] -r 2 I see many output
IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up
12:16:04 -- 366464 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
597 EXEC PROCEDURE db1 DR Wait 5 0 0 9.03 Off
Current statement name : cn56094
Current SQL statement :
EXECUTE PROCEDURE spinct(?, ?, 'B', ?, NULL, NULL, NULL, 'B', 'J', 'N',=
?)
Host variables :
address type flags value
---------------------------------
0x1E0D9020 VCHAR 0x000 135102
0x1E0D9088 VCHAR 0x000 135102
0x1E0D90F0 VCHAR 0x000 EUR
0x1E0D9158 VCHAR 0x000 J
Last parsed SQL statement :
EXECUTE PROCEDURE spinct(?, ?, 'B', ?, NULL, NULL, NULL, 'B', 'J', 'N',=
?)
IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up
12:16:52 -- 366464 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
597 db1 DR Wait 5 0 0 9.03 Off
Stored procedure stack :
context proc-counter opcode name
-------------------------------------------------------
0x1ee0e838 0x2087bfe4+0x0008 EXPR verkauf:spchgbetrag
0x1fff3088 0x1eb70f70-0x0020 CURNEXT verkauf:spubuchbetr
0x1f9d0030 0x1df9ad34+0x0008 SQL verkauf:spumwende
Last parsed SQL statement :
EXECUTE PROCEDURE spumwende(?, ?, 'B', ?, NULL, NULL, NULL, 'B', 'J', '=
N',
?)
IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up
12:16:54 -- 366464 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
597 - db1 DR Wait 5 0 0 9.03 Off
Last parsed SQL statement :
UPDATE table SET lastupd =3D "P" || CURRENT YEAR TO FRACTION(5) || USER=
WHERE lfndkode =3D 136505
so I can say that the IDS ist working and not waiting.
thx
Marco
Madison Pruet schrieb:
> It means that the thread is waiting on the condition. netnorm (networ=
k=3D
>
> normal). That meand that the thread is waiting for somthing to be sen=
t=3D
>
> from the client.
>
> =3D
>
> "Marco Schwarz" =3D
>
> <marco.schwarz@ro =3D
>
> lmail.net> =3D
> To
>
> Sent by: ids@iiug.org =3D
>
> ids-bounces@iiug. =3D
> cc
>
> org =3D
>
> Subj=3D
> ect
>
> onstat -g ath [6615] =3D>
> 04/28/2006 10:34 =3D
>
> AM =3D
>
> =3D
>
> =3D
>
> Please respond to =3D
>
> ids@iiug.org =3D
>
> =3D
>
> =3D
>
> Where I can found a documentation for the column "status" of this out=
pu=3D
> t?
>
> example: cond wait netnorm
>
> on a other screen with "onstat -g sql [sid] -r 2" I see many SQL comm=
an=3D
> d.
>
> C:\\\\>onstat -g ath | grep sql
> File STDIN:
> 35 1e09bdb8 1d816e7c 2 cond wait netnorm 1cpu qlexec
> 37 1dd110c8 1d8180b8 2 cond wait netnorm 1cpu sqlexec
> 39 1dd2a228 1d8186cc 2 cond wait netnorm 1cpu sqlexec
> 41 1dd84568 1d8192f4 2 cond wait netnorm 1cpu sqlexec
> 55 1e13d070 1d819908 2 cond wait netnorm 1cpu sqlexec
> 83 1f377a58 1d81a530 2 cond wait netnorm 1cpu sqlexec
> 94 1f1771a8 1d81b158 2 cond wait netnorm 1cpu sqlexec
> 122 1dc9f068 1d81c394 2 cond wait netnorm 1cpu sqlexec
> 123 1f72de18 1d81bd80 2 cond wait netnorm 1cpu sqlexec
> 160 1ea646e0 1d81cfbc 2 cond wait netnorm 1cpu sqlexec
> 618 20db9228 1d81b76c 2 cond wait netnorm 1cpu sqlexec
> 699 1ebb3930 1d819f1c 2 cond wait netnorm 1cpu sqlexec
> 1025 1e18e580 1d81c9a8 2 cond wait netnorm 1cpu sqlexec
> 1051 1ddd4c68 1d818ce0 2 cond wait netnorm 1cpu sqlexec
> 1304 1f2dcbb0 1d81ee20 2 cond wait netnorm 1cpu sqlexec
>
> C:\\\\>
>
> Thanks
> Marco Schwarz
>
> *********************************************************************=
**=3D
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> =3D
>
>
>
***********************************************************************=
********
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Hi Marco,
"Condition wait" on netnorm is a normal behaviour of IDS and is not sym=
ptom
of performance problem.
You said that you have many SQL running. Well, fine : your IDS works !
So, I don't understand what is your problem : users complain about resp=
ond
time ? your IDS hangs ? NT resources are full ?
About your initial question, see this URL :
http://www.oninit.com/onstat/onstat.php?page=3Dgcon
Regards.
________________________________
Philippe PIGNON
Information Management IT Specialist
IBM Software Group - Lab Services
T=E9l : + 33 1 49 05 37 79
Mobile :+ 33 6 74 93 35 69
Tour Descartes, 2 avenue Gambetta
92400 Courbevoie
http://www.ibm.com/software/fr/
________________________________
=
"Marco Schwarz" =
<marco.schwarz@ro =
lmail.net> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Re: onstat -g ath [6617] =
28/04/2006 17:50 =
=
=
Please respond to =
ids@iiug.org =
=
=
ok, but if I make onstat -g sql [sid] -r 2 I see many output
IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up
12:16:04 -- 366464 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
597 EXEC PROCEDURE db1 DR Wait 5 0 0 9.03 Off
Current statement name : cn56094
Current SQL statement :
EXECUTE PROCEDURE spinct(?, ?, 'B', ?, NULL, NULL, NULL, 'B', 'J', 'N',=
?)
Host variables :
address type flags value
---------------------------------
0x1E0D9020 VCHAR 0x000 135102
0x1E0D9088 VCHAR 0x000 135102
0x1E0D90F0 VCHAR 0x000 EUR
0x1E0D9158 VCHAR 0x000 J
Last parsed SQL statement :
EXECUTE PROCEDURE spinct(?, ?, 'B', ?, NULL, NULL, NULL, 'B', 'J', 'N',=
?)
IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up
12:16:52 -- 366464 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
597 db1 DR Wait 5 0 0 9.03 Off
Stored procedure stack :
context proc-counter opcode name
-------------------------------------------------------
0x1ee0e838 0x2087bfe4+0x0008 EXPR verkauf:spchgbetrag
0x1fff3088 0x1eb70f70-0x0020 CURNEXT verkauf:spubuchbetr
0x1f9d0030 0x1df9ad34+0x0008 SQL verkauf:spumwende
Last parsed SQL statement :
EXECUTE PROCEDURE spumwende(?, ?, 'B', ?, NULL, NULL, NULL, 'B', 'J', '=
N',
?)
IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up
12:16:54 -- 366464 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
597 - db1 DR Wait 5 0 0 9.03 Off
Last parsed SQL statement :
UPDATE table SET lastupd =3D "P" || CURRENT YEAR TO FRACTION(5) || USER=
WHERE lfndkode =3D 136505
so I can say that the IDS ist working and not waiting.
thx
Marco
Madison Pruet schrieb:
> It means that the thread is waiting on the condition. netnorm (networ=
k=3D
>
> normal). That meand that the thread is waiting for somthing to be sen=
t=3D
>
> from the client.
>
> =3D
>
> "Marco Schwarz" =3D
>
> <marco.schwarz@ro =3D
>
> lmail.net> =3D
> To
>
> Sent by: ids@iiug.org =3D
>
> ids-bounces@iiug. =3D
> cc
>
> org =3D
>
> Subj=3D
> ect
>
> onstat -g ath [6615] =3D>
> 04/28/2006 10:34 =3D
>
> AM =3D
>
> =3D
>
> =3D
>
> Please respond to =3D
>
> ids@iiug.org =3D
>
> =3D
>
> =3D
>
> Where I can found a documentation for the column "status" of this out=
pu=3D
> t?
>
> example: cond wait netnorm
>
> on a other screen with "onstat -g sql [sid] -r 2" I see many SQL comm=
an=3D
> d.
>
> C:\\\\>onstat -g ath | grep sql
> File STDIN:
> 35 1e09bdb8 1d816e7c 2 cond wait netnorm 1cpu qlexec
> 37 1dd110c8 1d8180b8 2 cond wait netnorm 1cpu sqlexec
> 39 1dd2a228 1d8186cc 2 cond wait netnorm 1cpu sqlexec
> 41 1dd84568 1d8192f4 2 cond wait netnorm 1cpu sqlexec
> 55 1e13d070 1d819908 2 cond wait netnorm 1cpu sqlexec
> 83 1f377a58 1d81a530 2 cond wait netnorm 1cpu sqlexec
> 94 1f1771a8 1d81b158 2 cond wait netnorm 1cpu sqlexec
> 122 1dc9f068 1d81c394 2 cond wait netnorm 1cpu sqlexec
> 123 1f72de18 1d81bd80 2 cond wait netnorm 1cpu sqlexec
> 160 1ea646e0 1d81cfbc 2 cond wait netnorm 1cpu sqlexec
> 618 20db9228 1d81b76c 2 cond wait netnorm 1cpu sqlexec
> 699 1ebb3930 1d819f1c 2 cond wait netnorm 1cpu sqlexec
> 1025 1e18e580 1d81c9a8 2 cond wait netnorm 1cpu sqlexec
> 1051 1ddd4c68 1d818ce0 2 cond wait netnorm 1cpu sqlexec
> 1304 1f2dcbb0 1d81ee20 2 cond wait netnorm 1cpu sqlexec
>
> C:\\\\>
>
> Thanks
> Marco Schwarz
>
> *********************************************************************=
**=3D
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> =3D
>
>
>
***********************************************************************=
********
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Philippe Pi.... schrieb:
> So, I don't understand what is your problem : users complain about > >
> respondtime ? your IDS hangs ? NT resources are full ?
Yes that my Problem I see the IDS Server hangs, and with onstat -g ath I
mean to found the running thread, but all thread are cont wait netnorm.
So how I found this tread?
thx,
Marco
> Hi Marco,
>
> "Condition wait" on netnorm is a normal behaviour of IDS and is not sym=
> ptom
> of performance problem.
> You said that you have many SQL running. Well, fine : your IDS works !
> So, I don't understand what is your problem : users complain about resp=
> ond
> time ? your IDS hangs ? NT resources are full ?
>
> About your initial question, see this URL :
> http://www.oninit.com/onstat/onstat.php?page=3Dgcon
>
> Regards.
>
> ________________________________
>
> Philippe PIGNON
> Information Management IT Specialist
> IBM Software Group - Lab Services
> T=E9l : + 33 1 49 05 37 79
> Mobile :+ 33 6 74 93 35 69
> Tour Descartes, 2 avenue Gambetta
> 92400 Courbevoie
> http://www.ibm.com/software/fr/
> ________________________________
>
> =
>
> "Marco Schwarz" =
>
> <marco.schwarz@ro =
>
> lmail.net> =
> To
>
> Sent by: ids@iiug.org =
>
> ids-bounces@iiug. =
> cc
>
> org =
>
> Subj=
> ect
>
> Re: onstat -g ath [6617] =
>
> 28/04/2006 17:50 =
>
> =
>
> =
>
> Please respond to =
>
> ids@iiug.org =
>
> =
>
> =
>
> ok, but if I make onstat -g sql [sid] -r 2 I see many output
>
> IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up
> 12:16:04 -- 366464 Kbytes>
> Sess SQL Current Iso Lock SQL ISAM F.E.
> Id Stmt type Database Lvl Mode ERR ERR Vers
> Explain
> 597 EXEC PROCEDURE db1 DR Wait 5 0 0 9.03 Off
>
> Current statement name : cn56094
>
> Current SQL statement :
> EXECUTE PROCEDURE spinct(?, ?, 'B', ?, NULL, NULL, NULL, 'B', 'J', 'N',=>
> ?)
>
> Host variables :
>
> address type flags value
>
> ---------------------------------
>
> 0x1E0D9020 VCHAR 0x000 135102
>
> 0x1E0D9088 VCHAR 0x000 135102
>
> 0x1E0D90F0 VCHAR 0x000 EUR
>
> 0x1E0D9158 VCHAR 0x000 J
>
> Last parsed SQL statement :
> EXECUTE PROCEDURE spinct(?, ?, 'B', ?, NULL, NULL, NULL, 'B', 'J', 'N',=>
> ?)
>
> IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up
> 12:16:52 -- 366464 Kbytes>
> Sess SQL Current Iso Lock SQL ISAM F.E.
> Id Stmt type Database Lvl Mode ERR ERR Vers
> Explain
> 597 db1 DR Wait 5 0 0 9.03 Off
>
> Stored procedure stack :
>
> context proc-counter opcode name
>
> -------------------------------------------------------
>
> 0x1ee0e838 0x2087bfe4+0x0008 EXPR verkauf:spchgbetrag
>
> 0x1fff3088 0x1eb70f70-0x0020 CURNEXT verkauf:spubuchbetr
>
> 0x1f9d0030 0x1df9ad34+0x0008 SQL verkauf:spumwende
>
> Last parsed SQL statement :
> EXECUTE PROCEDURE spumwende(?, ?, 'B', ?, NULL, NULL, NULL, 'B', 'J', '=
> N',>
> ?)
>
> IBM Informix Dynamic Server Version 9.40.TC5 -- On-Line -- Up
> 12:16:54 -- 366464 Kbytes>
> Sess SQL Current Iso Lock SQL ISAM F.E.
> Id Stmt type Database Lvl Mode ERR ERR Vers
> Explain
> 597 - db1 DR Wait 5 0 0 9.03 Off
>
> Last parsed SQL statement :
> UPDATE table SET lastupd =3D "P" || CURRENT YEAR TO FRACTION(5) || USER=>
> WHERE lfndkode =3D 136505
>
> so I can say that the IDS ist working and not waiting.
>
> thx
> Marco
>
> Madison Pruet schrieb:
>> It means that the thread is waiting on the condition. netnorm (networ=
> k=3D
>> normal). That meand that the thread is waiting for somthing to be sen=
> t=3D
>> from the client.
>>
>> =3D
>>
>> "Marco Schwarz" =3D
>>
>> <marco.schwarz@ro =3D
>>
>> lmail.net> =3D
>> To
>>
>> Sent by: ids@iiug.org =3D
>>
>> ids-bounces@iiug. =3D
>> cc
>>
>> org =3D
>>
>> Subj=3D
>> ect
>>
>> onstat -g ath [6615] =3D>>
>> 04/28/2006 10:34 =3D
>>
>> AM =3D
>>
>> =3D
>>
>> =3D
>>
>> Please respond to =3D
>>
>> ids@iiug.org =3D
>>
>> =3D
>>
>> =3D
>>
>> Where I can found a documentation for the column "status" of this out=
> pu=3D
>> t?
>>
>> example: cond wait netnorm
>>
>> on a other screen with "onstat -g sql [sid] -r 2" I see many SQL comm=
> an=3D
>> d.
>>
>> C:\\\\>onstat -g ath | grep sql
>> File STDIN:
>> 35 1e09bdb8 1d816e7c 2 cond wait netnorm 1cpu qlexec
>> 37 1dd110c8 1d8180b8 2 cond wait netnorm 1cpu sqlexec
>> 39 1dd2a228 1d8186cc 2 cond wait netnorm 1cpu sqlexec
>> 41 1dd84568 1d8192f4 2 cond wait netnorm 1cpu sqlexec
>> 55 1e13d070 1d819908 2 cond wait netnorm 1cpu sqlexec
>> 83 1f377a58 1d81a530 2 cond wait netnorm 1cpu sqlexec
>> 94 1f1771a8 1d81b158 2 cond wait netnorm 1cpu sqlexec
>> 122 1dc9f068 1d81c394 2 cond wait netnorm 1cpu sqlexec
>> 123 1f72de18 1d81bd80 2 cond wait netnorm 1cpu sqlexec
>> 160 1ea646e0 1d81cfbc 2 cond wait netnorm 1cpu sqlexec
>> 618 20db9228 1d81b76c 2 cond wait netnorm 1cpu sqlexec
>> 699 1ebb3930 1d819f1c 2 cond wait netnorm 1cpu sqlexec
>> 1025 1e18e580 1d81c9a8 2 cond wait netnorm 1cpu sqlexec
>> 1051 1ddd4c68 1d818ce0 2 cond wait netnorm 1cpu sqlexec
>> 1304 1f2dcbb0 1d81ee20 2 cond wait netnorm 1cpu sqlexec
>>
>> C:\\\\>
>>
>> Thanks
>> Marco Schwarz
>>
>> *********************************************************************=
> **=3D
>> ********
>>
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>> =3D
>>
>>
>>
> ***********************************************************************=
> ********
>
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>
> ***********************************************************************=
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> =
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g