RE: CKPT Blocked

> -----Original Message----- > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] > On Behalf Of cboccio@yahoo.com.br > Sent: Tuesday, August 02, 2005 1:54 PM > To: informix-list@iiug.org > Subject: CKPT Blocked > > Hi guys !! > > I have a serious problem with a informix instance with the following > configuration: > - OS - Linux Red Hat 8.0 Kernel 2.4.18-14 > - Informix 9.40 UC1 > > The problem is: > When I try to do some unload into a table or another kind of operation > that use logical log, my instance freezing and the message CKPT REQ - > Blocked Ckpt appears during the command "onstat -" > Because this machine is a "test/developer" machine, I have the chunks > in cooked file (permissions - informix and 660) [Bill Dare] You've probably got 1 of 2 possible things going on: 1) Your session doing "some unload into a table or another kind of operation" is getting stuck in a critical section and causing the checkpoint to block. Check that with the following query against sysmaster when the server freezes: select username,sid,pid,is_incrit,is_wckpt from syssessions where is_incrit = 1; 2) You've got a serious I/O bottleneck and your session is doing a lot of inserts/updates/deletes causing checkpoints to take forever. Use sar, vmstat, etc. to take a look at OS level resources and see if there is any problems. Also, check onsat -F and make sure you are seeing plenty of LRU writes. HTH, Bill > Please anybody can help me ?? > > Tks, > > Regards, > > Carlos Eduardo Boccio > TS&O Consulting > DBA Informix > sending to informix-list