Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
tony edwards — — source: Informix-list mailing list archive (1991-1998)
Team,
We have recently upgraded our HP-UX 9.04 / 5.07 to HP-UX 10.20 /
7.22.UC1X2. Here is some information about the system
configuration......
Database size 50 GB, chunks 43, memory 3 GB, disk nike arrays 120GB,
cpus 8
NUMCPUS 7 LOCKS 600000 BUFFERS 300000 CKPTINTVL 600
NUMAIOVPS 20 PHYSBUFF 400 LOGBUFF 400 LOGSMAX 165
CLEANERS 45 SHMVIRTSIZE 1000000 SHMADD 200000
LRU_MAX_DIRTY 5 LRU_MIN_DIRTY 1 LRUS 45
STACKSIZE 32 OPTCOMPIND 2 NOAGE 0
We don't have KAIO set because processor affinity is not supported on
HP.
Problems we are having....
1) A checkpoint is taking 16-20 seconds (Stats based on interval of
300).
2) Ready to run can be over 60 processes.
3) The oninit processes never go below 156 for a priority and can be as
high as 268.
4) System not using indexes correctly
- Have run update statistics medium for all tables, update statistics
high on first column of
each index and run update statistics low on all other index fields.
Can any one advise me on their update statistics strategie ? (This
system is 24x7)
5) Our LRU writes are 60% and the chunk writes are 40 % of the onstat -F
command.
6) If we changed our optcompind to zero would we need to run so many
update stats?
I look forward to any suggestions you can provide...
Cheers, Tony.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.