Re: informix 9.3 to 9.4 issue

<snip
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
RESIDENT 1
NOAGE 0 # Process aging
NOAGE 1
NUMAIOVPS 2 # Number of IO vps
Using KAIO?? or AIO??
If using AIO, may need to increase NUMAIOVPs to "number of relatively active chunks"
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
Will 800 Mb of BUFFERS, suggest 10
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
and 5
DBSPACETEMP tmpdbs # Default temp dbspaces
Always have 3 or more for temp dbspaces (REAL temp dbspaces with the -t flag)


Tasks: 122 total, 1 running, 120 sleeping, 1 stopped, 0 zombie
Cpu(s): 2.0% us, 0.8% sy, 0.0% ni, 73.8% id, 23.4% wa, 0.0% hi,
0.0% si
Mem: 4149104k total, 4125452k used, 23652k free, 6220k
buffers
Swap: 4095984k total, 208k used, 4095776k free, 3932260k
cached

What is happening with the memory??

> Mem: 4149104k total, 4125452k used, 23652k free, 6220k buffers

4125452k Used?? Could be a Linux funny s'pose

Oh, and as Art says "update statistics low drop distributions" followed by the "suite of required update statistics" followed by update statistics for procedure.

Ho hum, boiled bum
.