SEO

#1 (**permalink**) 04-20-2008, 08:55 AM

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

#2 (**permalink**) 04-20-2008, 08:55 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

CKPT Blocked