Hi,
at first I want to thank all who replied. I hope that I can try your
suggestions very soon and I will keep you informed - above all if it
doesn't works! :-)
Now I wanted to add some more information for you to keep in mind while
making your suggestions:
* on the system not only 30-50 db users are working but also about 30
users working with legacy systems (file i/o)
* in the db system we are only using raw devices
* the 3 (application) + 2 (rootdbs, temp) dbspaces are spread over 3
hard disks (mirrored by Informix on additional 3 harddisks)
* we have 5 databases (of course not in the rootdbs!) managed by this
instance
* we have about 98% of reads cached (I think our client can be confi-
dent with this value.)
* database/table statistics are updated every night by a cron job
* normally (not peak time, but regular working time: 11:30 am) 8 MB of
512 MB RAM are free and 100 MB of 500 MB swap are used; the load va-
lues are: 1.4+, 1.0+, 0.7+
If you need any further information I should provide, please drop a
line.
Thanks again for your help!
Many regards,
Stephan.
--
Stephan Stresing
Media Systeme
Gesellschaft fuer Druck & Verlag mbH
Suedwestpark 48
D-90449 Nuernberg
Phone +49 911 6809-113
Fax +49 911 6809-110
eMail triple-p.sst@t-online.de
WWW http://www.mediasys.triple-p.com