> -----Original Message-----
> From: owner-informix-list@iiug.org [SMTPwner-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