Re: Analysis of activities during checkpoint

Posted in 2008

coral80@gmx.de — Wed, 02 Jul 2008 13:51:09 +0200 — source: Usenet: comp.databases.informix

You may set an Environment Variable before starting the Informix Server: TRACECKPT=1; export TRACECKPT The checkpoints will be more chatty and you can see what needs more time: writing to disk or sessions in critical section. With onstat -C you can see what the BTSCANNERS are doing. If you find mostly leaf scans then this could be the reason for the long checkpoints. -- GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen! Jetzt dabei sein: http://www.shortview.de/wasistshortview.php?mc=sv_ext_mf@gmx

Related threads

4GL compares NULL differently
ecpp
Re: Connecting to Informix