Re: Lock HWM -- Informix 7.24UC1

Hi, Run onstat -p. It displays several overflow statistics of which locks is one (see ovlock). ex. onstat -p INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 01:24:13 -- 374120 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 503528 503655 3606071 86.04 477 939 16391 97.09 isamtot open start read write rewrite delete commit rollbk 1194323 8419 18042 1120943 5504 70 188 49 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 348.50 218.92 2 8 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 3494 0 1081884 0 0 0 492 375 ixda-RA idx-RA da-RA RA-pgsused lchwaits 12132 146 235619 245664 2274 > > 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 > > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net