Whats the number of pool agents and whats the pooling set for your we
application and
whats the total memory on the machine





"yjchong"
<db2udbdba-ezmlms
hield-x86239056.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
02/24/2005 07:56
PM Subject
Re: Challeging Question:Database
application process slow down.










Dear all,

My DB2 Settings are:
Max number of active applications (MAXAPPLS) = 223
Max number of existing agents (MAXAGENTS) = 400

Regards,
John

------------------------------------------------------------------------------------------------------------------------------------------------


Dear all,

I have load testing my web application with 50 users using test tool. It
works fine.

When I test it with 100 users. The application failed to process next
request, i.e:
open a new browser and loading the application site, take about 10 minutes
to complete.

May I know how to tune it in DB2 or SQL?
Any guidance or pointer is much appreciated....

Many thanks.

Rgds,
John


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page