Informix Online 5 freezes several times a week

[MarcoEshuis]

Hi,

Several times Informix 5.10.UC1 freezes. When running tbstat -uk I see in the header "CHKPNT REQ". Nothing some to help (tbstat -c e.q). The only solution is to stop the database and start up Informix again.

Can somebody give me some tips? The database is running in a production environment on a virtual (VMWare) server.

Greetings,
Marco
The Netherlands

** Here some parameters **

# Root Dbspace Configuration

ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dev/rinformix0 # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 2000000 # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration

MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing root dbspace mirror
MIRROROFFSET 0 # Offset into mirror device (Kbytes)

# Physical Log Configuration

PHYSDBS rootdbs # Name of dbspace that contains physical log
PHYSFILE 2000 # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES 55 # Number of logical log files
LOGSIZE 1000 # Size of each logical log file (Kbytes)
# Shared Memory Parameters

RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
USERS 150 # Maximum number of concurrent user processes
TRANSACTIONS 150 # Maximum number of concurrent transactions
LOCKS 10000 # Maximum number of locks
BUFFERS 1000 # Maximum number of shared memory buffers
TBLSPACES 2300 # Maximum number of active tblspaces
CHUNKS 8 # Maximum number of chunks
DBSPACES 8 # Maximum number of dbspaces and blobspaces
PHYSBUFF 32 # Size of physical log buffers (Kbytes)
LOGBUFF 32 # Size of logical log buffers (Kbytes)
LOGSMAX 61 # Maximum number of logical log files
CLEANERS 1 # Number of page-cleaner processes
SHMBASE 0x0 # Shared memory base address
CKPTINTVL 300 # Checkpoint interval (in seconds)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU modified begin-cleaning limit (percent)
LRU_MIN_DIRTY 50 # LRU modified end-cleaning limit (percent)
LTXHWM 50 # Long TX high-water mark (percent)
LTXEHWM 60 # Long TX exclusive high-water mark (percent)

 

[PHV]

Have a look here:

http://my.safaribooksonline.com/boo...796239/understanding-the-online-utilities/124

(CKPT REQ) Some process has requested a checkpoint, and the engine is trying to initiate the checkpoint. This flag is often seen if the database is hung waiting for a checkpoint.

and here:

http://www.prstech.com/resources/src/informix_faq/ifaq06.htm#6.23

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MarcoEshuis]

Hi PHV,

Thanks for your tips. Last month I tried a lot, but nothings works.

CLEANERS: from 1 to 6
LOCKS: from 10.000 to 80.000
BUFFERS: from 1000 to 5.000
LRU_MAX_DIRTY: from 60 to 40
LRU_MIN_DIRTY: from 50 to 30

Database is still freezing, sometimes 10 times a day. Do you haven additional hints or tips?

Thanks,
Marco