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) Please anybody can help me ?? Tks, Regards, Carlos Eduardo Boccio TS&O Consulting DBA Informix

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