To all DB2 guru,

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....

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

Pool agents info:
agentpri = -1
maxagents = 400
maxcagents = -1
max_coordagents = -1
num_initagents = 0
num_poolagents = 400
========================================
Connection pool setting(WAS 5.0 console interface)

Connection Timeout = 1000 seconds
Max Connection= 100 connections
Min Connections= 1 connection
Reap Time= 0 second
Unused Timeout= 1800 seconds
Aged Timeout= 0 second
Purge Policy=EntirePool
=========================================
Total Memory on the Application Server is 1GB.
========================================

Many thanks.

Rgds,
John

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