Re: Lock HWM -- Informix 7.24UC1
In article <67oqsq$baj@cssun.mathcs.emory.edu>, Rick Bernstein
<rbernste@alarismed.com> writes
>We are running Informix 7.24UC1 on AIX 4.2.1.
>Is there an Informix command or sysmaster query which will
>identify the high-water mark of locks held.
>"onstat -k|grep total" shows current locks held.
>But we want to determine how close we come to exceeding the
>limit established in the $ONCONFIG file (before we exceed it).
>
>Thanks for any assistance in this matter.
>
>Rick Bernstein Phone: (619) 458-7048
>Alaris Medical Systems FAX: (619) 458-7640
>San Diego, CA 92121 Internet: rbernste@alarismed.com
>
Check $INFORMIXDIR/etc/sysmaster.sql
This is used to build sysmaster,
Table syscfgtab shows you the online configuration.
Try select * from syscfgtab. I think adding where cf_name = "LOCKS"
should give you the current value in cf_effective.
select count(*) from syslocks will give you the number of locks io
use.
--
David Williams