RE: CKPT Blocked

If you mean "unload from a table to a file", then: SET ISOLATION TO DIRTY READ; If you mean "load from a file into a table", you may be running out of logical logs and need to configure more. If that isn't possible, you may have to break the load up into smaller segments with a commit. What are the values for LOGFILES & LOGSIZE? Jay 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 sending to informix-list