Thread: CKPT Blocked
View Single Post

   
  #2 (permalink)  
Old 04-20-2008, 09:55 AM
Art S. Kagel
 
Posts: n/a
Default Re: CKPT Blocked

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
Reply With Quote