Performance problem

Hi all, Thanks to Art and Jonathan for all their help. We were able to complete our project and move to production. But we found one problem there. The system seems to be very slow whenever it accesses DB. It used to work fine in the test environment but there is some problem in the production ENV. Actually we have another application which is a bactch process running on production. It uses the same INFORMIX SERVER. And it is a continuous process which sends lot of transacions to the database. When bring that process down everything seems to be normal for our process. Both the systems use different databases but still they seem to affect each other. As I said we use the same INFORMIXSERVER i.e. for these databases we have the ENV variable INFORMIXSERVER set to say "production". Can this be a problem. Can we do some thing to get our speed back without impacting the other application? We are using informix 7.20. Any help will be greatly appriciated. If possible please send a copy of your email to my id at "asharma@uswest.com". Thanks in advance. Arvind

>Can we do some thing to get our speed back without > impacting the other application? > We are using informix 7.20. Any help will be greatly appriciated. Look at your poll thred - is one running in-line. If not, move poll thread to CPU vp using NETTYPE param. Also, monitor your listener thread operation - if one listener thread is not enough for your system add another one. Other problem can be in your network - monitor your connections through 'netstat -e' and look for 'Errors' field. At Informix level use 'onstat -ntd' to see accepted/rejected entries. Hope this hekps. -- With best regards, Yuri Dovgart, SAP R/3, Informix consultant, "Telecominvest" company. E-mail y_dovgart@tci.ukrtel.net Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.