Deepak, Your e-mail is not too detailed, like - what OS ? what server ? what type of applications (e.g. Java) run against the database ? do you have a lot of stored procs (including Java SPs) etc. ? mostly OLTP or DSS environment or mixed ?
A few general pointers though: 1. First of all, your machine size is probably woefully inadequate to hold 1 instance with 6 databases and 150+ connections. DB2 is a huge memory hogger. 2. Make sure that your OS paging space (for DB2 swap space) is *atleast* 2 times your physical memory. 3. How many BPs do you have ? Recommended 1 if memory-constrained (which you are). How much space is allocated to your BPs ? Too small a value means excessive disk I/0 (very bad for performance). Recommended size of all your BPs: at least 50% of available memory. 4. What do you mean when you say "Other instances on this machine are working properly" ? Does it mean you have more DB2 instances installed on this machine ? If so, all I can say is "Oh boy !!". See if you can remove some of the other instances. This alone will drastically bring up the performance of your instance of interest. At best, do a test by shutting down the other instances and see if performance improves on your instance. 5. Try to set up some OS and DB2 monitors. OS monitors can look at your paging, I/O, memory consumption, CPU usage etc. 6. Make sure you DIAGLEVEL is not set to 4. This is a potential reason for severe performance problems. 7. Check to see that your SORTHEAP and SHEAPTHRES paramaters are adequately allocated. List could go on and get much longer. Suggest you start with reading DB2 V7 Administration Guide: Performance. Hope this helps. Abhijit -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 4:45 AM To: [EMAIL PROTECTED] Subject: [DB2EUG] Problem In DB2 universal database Dear All, We are using DB2 universal database version 7.1. and a machine having 2GB of RAM. If the number of connections to a particular instance exceeds 100 then the processing speed of database manager becomes very slow. We are having 6 databases on this instance. If on an average 25 applications connects to one database even then total number of applications become 150. All the parameters in the database manager configuration file and database configuraion file are having their default mvalues expect for MAXAGENTS which is changed to 180. Other instances on this machine are working properly . Please suggest which parameters we should change in order to run our system properly. Thanx in advance for prompt reply Thanx & Rgds Deepak Bansal - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
