cboccio@yahoo.com.br wrote:
> 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)
<SNIP>
What does onstat -l report? Are all of the log files waiting to be backed
up? You can try a logical log archive (ontape -a if you use ontape) and
see if that frees the logs.
Art S. Kagel