TRANSACTIONS WITH TOUT
Hi:
There are some SQL to retrieve this sessions with -1 (tout column)
onstat -u
Userthreads
address flags sessid user tty wait tout locks nreads
d3c0ea28 L--PR-- 51146117 gtaca655 tKg 8113adec -1 2 1786
0
b8837a88 L--PR-- 51146211 gtaca655 tgh 8113adec -1 2 1720
0
d501d558 L--PR-- 51146222 gtaca624 tkh 8113adec -1 1 1074
0
db931138 L--PR-- 51146082 ppaa5601 tjd 8110b364 -1 2 1554
2028
ddb0bf78 L--PR-- 51146190 ppaa5601 thh 8110b364 -1 2 1468
2024
ddb11078 L--PR-- 51146165 gtaca624 tye 8113adec -1 1 1081
0
Regards & Thanks in advance
On 1/25/06, Valeriano V.... <jvaleriano@ref.pemex.com> wrote:
> There are some SQL to retrieve this sessions with -1 (tout column)
>
> onstat -u>
> Userthreads
> address flags sessid user tty wait tout locks nreads
>
> d3c0ea28 L--PR-- 51146117 gtaca655 tKg 8113adec -1 2 1786
> 0
> b8837a88 L--PR-- 51146211 gtaca655 tgh 8113adec -1 2 1720
> 0
> d501d558 L--PR-- 51146222 gtaca624 tkh 8113adec -1 1 1074
> 0
> db931138 L--PR-- 51146082 ppaa5601 tjd 8110b364 -1 2 1554
> 2028
> ddb0bf78 L--PR-- 51146190 ppaa5601 thh 8110b364 -1 2 1468
> 2024
> ddb11078 L--PR-- 51146165 gtaca624 tye 8113adec -1 1 1081
> 0
Most likely, yes. I'd go poking at the SysMaster database. The
column name might be timeout rather than tout, but I'd have to look at
the manual to be sure, just the same as you could. (The manual in
question is IDS Administrator's Reference.)
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/
tout
The number of seconds remaining from a call to SET LOCK MODE TO WAIT n. If
the value is 0, the thread is not waiting on a lock, if -1, the thread is
waiting indefinitely.
Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend the IDUG 2006 North America Conference.
Tampa, Florida, USA. 7-11 May 2006.
Visit http://www.iiug.org/conf for more information.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of Jonathan Le....
> Sent: Monday, January 30, 2006 2:01 AM
> To: ids@iiug.org
> Subject: Re: TRANSACTIONS WITH TOUT [6287]
>
>
> On 1/25/06, Valeriano V.... <jvaleriano@ref.pemex.com> wrote:
> > There are some SQL to retrieve this sessions with -1 (tout column)
> >
> > onstat -u> >
> > Userthreads
> > address flags sessid user tty wait tout locks nreads
> >
> > d3c0ea28 L--PR-- 51146117 gtaca655 tKg 8113adec -1 2 1786
> > 0
> > b8837a88 L--PR-- 51146211 gtaca655 tgh 8113adec -1 2 1720
> > 0
> > d501d558 L--PR-- 51146222 gtaca624 tkh 8113adec -1 1 1074
> > 0
> > db931138 L--PR-- 51146082 ppaa5601 tjd 8110b364 -1 2 1554
> > 2028
> > ddb0bf78 L--PR-- 51146190 ppaa5601 thh 8110b364 -1 2 1468
> > 2024
> > ddb11078 L--PR-- 51146165 gtaca624 tye 8113adec -1 1 1081
> > 0
>
> Most likely, yes. I'd go poking at the SysMaster database. The
> column name might be timeout rather than tout, but I'd have
> to look at
> the manual to be sure, just the same as you could. (The manual in
> question is IDS Administrator's Reference.)
>
> --
> Jonathan Leffler #include <disclaimer.h>
> Email: jleffler@earthlink.net, jleffler@us.ibm.com
> Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>