MarcoEshuis
Technical User
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)
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)