Fied wtlist gt 0 _ onstat -k

Hi Masters: What is the query to get wtlist > 0 onstat -k IBM Informix Dynamic Server Version 7.31.UD7W4 -- On-Line -- Up 2 days Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 80e20b70 0 cd6a6f08 0 S 100002 204 0 820b9958 d62b1a38 d62b4cd8 80e2d280 HDR+X b00014 14102 0 820b99c0 0 d62b1a38 87db8cc8 HDR+IX 200006 0 0 87db7b1c d9ab9788 b4594b58 8b58586c HDR+X 2a00005 2266c0a 0 8b5804f0 0 d44241a8 80e42994 HDR+X 16000a8 13090d K- 4 8b580628 d62c0318 d62b1a38 8a2f24b4 HDR+X e0000e 924f0d 0 8dab7d94 0 d62b1a38 845ec708 HDR+X 2700030 88c107 K- 1 8dab80a0 d7c41a98 d62b1a38 87db6c7c HDR+X 1600067 27305 K- 1 9127d438 0 d62c6858 0 S 100002 203 0 9127d640 d44246b8 d62b1a38 87db9550 HDR+X 1800013 25a4d07 0 925300b4 0 db879048 0 S 100002 203 0 1477 active, 6000000 total, 524288 hash buckets Thanks in advance

On 2/3/06, Valeriano V.... <jvaleriano@ref.pemex.com> wrote: > > Hi Masters: > > What is the query to get wtlist > 0 > > onstat -k> > IBM Informix Dynamic Server Version 7.31.UD7W4 -- On-Line -- Up 2 days> > Locks > address wtlist owner lklist type tblsnum rowid key#/bsiz > 80e20b70 0 cd6a6f08 0 S 100002 204 0 > 820b9958 d62b1a38 d62b4cd8 80e2d280 HDR+X b00014 14102 0 > 820b99c0 0 d62b1a38 87db8cc8 HDR+IX 200006 0 0 > 87db7b1c d9ab9788 b4594b58 8b58586c HDR+X 2a00005 2266c0a 0 > 8b5804f0 0 d44241a8 80e42994 HDR+X 16000a8 13090d K- 4 > 8b580628 d62c0318 d62b1a38 8a2f24b4 HDR+X e0000e 924f0d 0 > 8dab7d94 0 d62b1a38 845ec708 HDR+X 2700030 88c107 K- 1 > 8dab80a0 d7c41a98 d62b1a38 87db6c7c HDR+X 1600067 27305 K- 1 > 9127d438 0 d62c6858 0 S 100002 203 0 > 9127d640 d44246b8 d62b1a38 87db9550 HDR+X 1800013 25a4d07 0 > 925300b4 0 db879048 0 S 100002 203 0 > 1477 active, 6000000 total, 524288 hash buckets You'd get a wait list bigger than zero if there are some extra threads waiting with SET LOCK MODE WAIT (or the timed variant) all needing to access the same lock. So, if you tried to have 4 sessions all update the same single row in a table, one would get the go ahead and the other three would be waiting for the first to commit or rollback - to release the lock. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

select * from syslocktab where lk_wtlist > 0; Art S. Kagel ----- Original Message ----- From: Valeriano V.... <ids@iiug.org> At: 2/ 3 14:22 Hi Masters: What is the query to get wtlist > 0 onstat -k IBM Informix Dynamic Server Version 7.31.UD7W4 -- On-Line -- Up 2 days Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 80e20b70 0 cd6a6f08 0 S 100002 204 0 820b9958 d62b1a38 d62b4cd8 80e2d280 HDR+X b00014 14102 0 820b99c0 0 d62b1a38 87db8cc8 HDR+IX 200006 0 0 87db7b1c d9ab9788 b4594b58 8b58586c HDR+X 2a00005 2266c0a 0 8b5804f0 0 d44241a8 80e42994 HDR+X 16000a8 13090d K- 4 8b580628 d62c0318 d62b1a38 8a2f24b4 HDR+X e0000e 924f0d 0 8dab7d94 0 d62b1a38 845ec708 HDR+X 2700030 88c107 K- 1 8dab80a0 d7c41a98 d62b1a38 87db6c7c HDR+X 1600067 27305 K- 1 9127d438 0 d62c6858 0 S 100002 203 0 9127d640 d44246b8 d62b1a38 87db9550 HDR+X 1800013 25a4d07 0 925300b4 0 db879048 0 S 100002 203 0 1477 active, 6000000 total, 524288 hash buckets Thanks in advance ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks ART for your help !!! -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de ART KAGEL, .... Enviado el: Lunes, 06 de Febrero de 2006 08:59 a.m. Para: ids@iiug.org Asunto: Re: Fied wtlist gt 0 _ onstat -k [6317] select * from syslocktab where lk_wtlist > 0; Art S. Kagel ----- Original Message ----- From: Valeriano V.... <ids@iiug.org> At: 2/ 3 14:22 Hi Masters: What is the query to get wtlist > 0 onstat -k IBM Informix Dynamic Server Version 7.31.UD7W4 -- On-Line -- Up 2 days Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 80e20b70 0 cd6a6f08 0 S 100002 204 0 820b9958 d62b1a38 d62b4cd8 80e2d280 HDR+X b00014 14102 0 820b99c0 0 d62b1a38 87db8cc8 HDR+IX 200006 0 0 87db7b1c d9ab9788 b4594b58 8b58586c HDR+X 2a00005 2266c0a 0 8b5804f0 0 d44241a8 80e42994 HDR+X 16000a8 13090d K- 4 8b580628 d62c0318 d62b1a38 8a2f24b4 HDR+X e0000e 924f0d 0 8dab7d94 0 d62b1a38 845ec708 HDR+X 2700030 88c107 K- 1 8dab80a0 d7c41a98 d62b1a38 87db6c7c HDR+X 1600067 27305 K- 1 9127d438 0 d62c6858 0 S 100002 203 0 9127d640 d44246b8 d62b1a38 87db9550 HDR+X 1800013 25a4d07 0 925300b4 0 db879048 0 S 100002 203 0 1477 active, 6000000 total, 524288 hash buckets Thanks in advance ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.