FW: Numbers of Locks

Posted in 2001

Dirk Moolman — Tue, 13 Feb 2001 16:37:02 +0200 — source: Informix-list mailing list archive (1991-1998)

-----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Tsutomu Ogiwara Sent: Tuesday, February 13, 2001 7:43 AM To: Tham Huei Hwan Cc: informix-list Subject: Re: Numbers of Locks >At 09:56 01/02/13 +0800, Tham Huei Hwan wrote: >Hi Tham. >Probably LOCKS parameter in $INFORMIXDIR/etc/$ONCONFIG Incorrect, the LOCKS parameter sets the total number of locks allowed for that Informix instance, and will be shared by all users. >Regards. >Hi all, > >How to find out how many locks is hold by particular users / process ? > >Thanks and Regards, >Tham > -- Tsutomu Ogiwara Technical Group & Red Brick Group, Informix Sales Promotion Dept ITOCHU TECHNO-SCIENCE Corporation YASUKUNI KUDAN-MINAMI BLDG., 2-3-14, KUDAN-MINAMI, CHIYODA-KU TOKYO,1 02-0074 JAPAN Phone:+81-3-5212-4891 Fax:+81-3-5212-4889 E-mail:Tsutomu.Ogiwara@ctc-g.co.jp / tsutoo@my-deja.com