Blocked:CKPT

Hi list, Online hungs yesterday on a checkpoint. Logical logs was not full, and I had no message in log file. The status was: Informix Dynamic Server Version 7.30.UC6 -- On-Line (CKPT REQ) -- Up 6 days 0s Blocked:CKPT Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 11192271 12777328 135165545 91.72 459100 859924 1399356 67.19 isamtot open start read write rewrite delete commit rollbk 86901111 1664440 4354573 66715170 75892 33016 7826 411213 19 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 16 19612.95 1870.81 223 447 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 6969396 1661 39680693 16 0 204 6411 149081 ixda-RA idx-RA da-RA RA-pgsused lchwaits 3459888 208303 3751992 6669978 319 System is HP-UX 10.20 The workaround was to stop the engine and restart it. Does anybody know what else to do in this case? Before this day, I never saw ovbuf>0. Does this mean I need to increase BUFFERS parameter. TIA, David...

On Tue, 02 Feb 1999 13:42:21 +0100, David Andrieu <dandrieu@mail.atmel.fr> wrote: > >Hi list, > > Online hungs yesterday on a checkpoint. Logical logs was not full, >and I had no message in log file. > >The status was: > >Informix Dynamic Server Version 7.30.UC6 -- On-Line (CKPT REQ) -- Up 6 >days 0s >Blocked:CKPT This can happen if you have ONDBSPACEDOWN set to 2 (the default) in your onconfig file. Try changing it to 0 or 1. Dave