what to check when informix freezes??????
A DBA asked the group to help build a checklist of things to check when an Informix instance appears to freeze (his starting points: full logical logs, LRU/page cleaners, open file limits, chunk status). No single fault or fix is involved; replies added diagnostic suggestions: confirm the instance is actually running, check checkpoint duration and whether a user is hung in a critical section during CHKPT REQ (noting LBU_PRESERVE leaves one log free), free chunk space, locks/deadlocks via onstat -u, long-transaction rollbacks, mutex waits (onstat -g lmx), shared-memory dumps/assert failures, NETTYPE sizing for user load, and AFDEBUG settings; run onstat -g stk all and onstat -a before calling Tech Support. One poster suggested collating the answers into the FAQ. No specific resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
HIE Informixers--- i am trying to compile a check list to use when informix freezes can you guys please give me some more !!!!!!!! 1 check if the logs are not full 2 check the LRU and the page cleaners 3 increase the number of open files 4 check the status of the chunks 5 6 7 Simbarashe Pangeti Banking Applications Support Executive Tel bus 252540/55 ext 266/267 Home 490405 URL www.uzweb.uz.ac.zw/compcentre/people/simba
Hi,
- check the duration of current Checkpoint.
- free space in your chunks.
- check locks of a specific user with 'onstat -u'
...
Regards,
Andi
Check the instance is still running?? :-) Simbarashe.Pangeti@icl.com wrote: > > HIE Informixers--- > i am trying to compile a check list to use when informix freezes > can you guys please give me some more !!!!!!!! > 1 check if the logs are not full > 2 check the LRU and the page cleaners > 3 increase the number of open files > 4 check the status of the chunks > 5 > 6 > 7 > > Simbarashe Pangeti > Banking Applications Support Executive > Tel bus 252540/55 ext 266/267 > Home 490405 > URL www.uzweb.uz.ac.zw/compcentre/people/simba -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #
Run "onstat -g stk all" & "onstat -a". Call Tech
Support after that. These two commands collect enough
for them to look that what might have caused the
problem.
Sanjeev K. Sagar
Andreas Kumpf wrote:
> Hi,
> - check the duration of current Checkpoint.
> - free space in your chunks.
> - check locks of a specific user with 'onstat -u'
> ...
> Regards,
> Andi
If in CHPT REQ check that there is not a user in a critical section that is itself hung. Simbarashe.Pangeti@icl.com wrote: > > HIE Informixers--- > i am trying to compile a check list to use when informix freezes > can you guys please give me some more !!!!!!!! > 1 check if the logs are not full If you have LBU_PRESERVE remember one log will be free when hung! Art S. Kagel > 2 check the LRU and the page cleaners > 3 increase the number of open files > 4 check the status of the chunks > 5 > 6 > 7 > > Simbarashe Pangeti > Banking Applications Support Executive > Tel bus 252540/55 ext 266/267 > Home 490405 > URL www.uzweb.uz.ac.zw/compcentre/people/simba
A few other things to check....
Make sure your instance isn't rolling back from a long
transaction...
Check to see if you are in a deadlock situation..
Use onstat -g lmx (on 9.x anyway) to make sure you aren't running
into a mutex lock bug.
If you have Shared memory dumps turned on and run into an Assert
Fail, it could take a while for the dump to finish.
Make sure that Nettype is high enough for the amount of users that
are accessing the database..(It can sometimes seem hung).
Check to see if AFDEBUG is set to 1...
On Thu, 14 Sep 2000 07:50:39 +0100, Simbarashe.Pangeti@icl.com wrote:
>
>
> HIE Informixers---
>i am trying to compile a check list to use when informix freezes
>can you guys please give me some more !!!!!!!!
>1 check if the logs are not full
>2 check the LRU and the page cleaners
>3 increase the number of open files
>4 check the status of the chunks
>5
>6
>7
>
>
>
>
>Simbarashe Pangeti
>Banking Applications Support Executive
>Tel bus 252540/55 ext 266/267
> Home 490405
>URL www.uzweb.uz.ac.zw/compcentre/people/simba
>
The FAQ was mentioned further up my screen. Perhaps the replies to this item could be collated for inclusion.... In article <8ppu23$l3i$1@news.xmission.com>, Simbarashe.Pangeti@icl.com writes > > > HIE Informixers--- >i am trying to compile a check list to use when informix freezes >can you guys please give me some more !!!!!!!! >1 check if the logs are not full >2 check the LRU and the page cleaners >3 increase the number of open files >4 check the status of the chunks >5 >6 >7 > > > > >Simbarashe Pangeti >Banking Applications Support Executive >Tel bus 252540/55 ext 266/267 > Home 490405 >URL www.uzweb.uz.ac.zw/compcentre/people/simba > Andrew Lennard andy@kontron.demon.co.uk