onstat -u tout field

onstat -u tout field

Post by Gary Quirin » Sat, 15 Sep 2001 00:42:16



What does the tout field indicate when onstat -u is used.  I have a user that is locked up and the tout contains a -1.

The engine is 7.31 on Solaris 7.

Thanks
Gary

Informix Dynamic Server Version 7.31.UC6    -- On-Line -- Up 87 days 13:57:28 --
 1769488 Kbytes

Userthreads
address  flags       sessid      user        tty         wait         tout locks nreads   nwrites

5e05bb1c L--PR-- 1185502  ewartg   ttyp57   fe79a40  -1   3          1               0

 
 
 

onstat -u tout field

Post by Gary Chi » Sat, 15 Sep 2001 10:39:30



> What does the tout field indicate when onstat -u is used.  I have a user that is locked up and the tout contains a -1.

> The engine is 7.31 on Solaris 7.

> Thanks
> Gary

> Informix Dynamic Server Version 7.31.UC6    -- On-Line -- Up 87 days 13:57:28 --
>  1769488 Kbytes

> Userthreads
> address  flags       sessid      user        tty         wait         tout locks nreads   nwrites

> 5e05bb1c L--PR-- 1185502  ewartg   ttyp57   fe79a40  -1   3          1               0

This thread is waiting indefinitely for resource fe79a40 which is a
lock
(indicated by the L- in the flags column.) If you do an onstat -k|grep
fe79a40,
you can find the owner of the lock. Take the value from the owner
column and do an onstat -u|grep "owner value" to find the session id
of the process holding the lock.

 
 
 

onstat -u tout field

Post by Tsutomu Ogiwar » Sat, 15 Sep 2001 12:40:58


Hi Gray.

Here is a part of Informix Administrator's Reference Manual.

tout
is the number of seconds left in the current wait. If the value is
0, the user thread is not waiting for a latch or lock. If the value
is -1, the user thread is in an indefinite wait.

Regards.


Quote:>What does the tout field indicate when onstat -u is used.  I have a user
>that is locked up and the tout contains a -1.

>The engine is 7.31 on Solaris 7.

>Thanks
>Gary

>Informix Dynamic Server Version 7.31.UC6    -- On-Line -- Up 87 days
>13:57:28 --
> 1769488 Kbytes

>Userthreads
>address  flags       sessid      user        tty         wait         tout
>locks nreads   nwrites

>5e05bb1c L--PR-- 1185502  ewartg   ttyp57   fe79a40  -1   3          1      
>         0

--
Tsutomu Ogiwara

Informix Business Promotion Dept
ITOCHU TECHNO-SCIENCE Corporation
KURITA-KUDAN BLDG., 1-11-15, FUJIMI,
CHIYODA-KU TOKYO,102-0074 JAPAN
Phone:+81-3-5226-1951 Fax:+81-3-5226-1959

 
 
 

1. onstat -g ntt vs onstat -u

The output of "onstat -g ntt", is showing that the last read and write
was an hour ago. However, the output of "onstat -u", shows that
the reads are still going up. Any explanation is appreciated!

Thanks

2. EDataBaseError

3. onstat -u / onstat -g ses Problem

4. connect using host:port:sid

5. onstat -D vs onstat -g iof

6. removing SQL Server Desktop Engine

7. onstat -D vs. onstat -g iof

8. Virtual Directory Problems

9. onstat -d,onstat -D

10. Check I tOut: New TabExp Versions are available

11. Chance to tout Informix

12. tbstat -u (tout column)

13. New fields on the onstat -R