Re: Req. solve for Lock error

If you do an onstat -p you will get the profile for the instance. In this profile you should get something like this:- INFORMIX-OnLine Version 7.24.UC5 -- On-Line -- Up 16:01:19 -- 939624 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 1489077 7385701 165726546 99.10 137556 277965 1783255 92.29 isamtot open start read write rewrite delete commit rollbk 119641320 665120 11853976 53352839 182867 171414 35496 147928 7 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 11186.78 6019.82 64 128 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 417214 0 12574912 0 0 17 32572 56051 ixda-RA idx-RA da-RA RA-pgsused lchwaits 1015211 1 0 999117 112995 if the ovlock column is reporting any numbers, it means that the number of locks that the instance has, has been exceeded - run 'onstat -c | grep LOCKS ' which will tell you what the LOCKS value in the ONCONFIG files is configured for. ( alternatively, if you don't trust the ONCONFIG file, run 'oncheck -pr | grep LOCKS' to print out what value the LOCKS variable has in the reserved pages ). The query/update that is causing the lock problem should also be put through the optimiser using SET EXPLAIN, which should estimate how many locks it requires. Effectively, upping the number of LOCKS might solve the problem, but unfortunately, you don't know by how much you need to increase it !! Hope this helps !! Sean dengelsen@my-dejanews.com wrote in message <75qb8n$1eh$1@nnrp1.dejanews.com>... >Hello, > >How can I solve this error: > >09:50:26 Process exited with return code 127: /bin/sh /bin/sh -c>/informix/ONLINE/etc/alarm.sh 3 21 "OnLine resource overflow: 'Locks'." "Lock >table overflow - user id > > >Greetings, > >Ditmar den Engelsen > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own