Connection Timedout Exception

What could be the cause of this error?

esidual_billing][AccountInfoDAO][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getAccountDetailsList(ProjPk projPk) ends
[residual_billing][ProjHelper][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getAccountsList(form)
[residual_billing][ProjHelper][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getLocationsMap()
[residual_billing][GlobalParamContext][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getGlobalMap() method strats here
[residual_billing][ConnectionMgr][02/25 12:22:50.811][INFO][Severity 4] [] Method Starts Here
[residual_billing][GlobalParamContext][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getGlobalMap() method ends here
[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getLocationsMap()
[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] handleModifyRequest(projSetupForm,session,user)
[residual_billing][ProjModifyInitialAction][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][ConnectionMgr][02/25 12:24:12.478][DEBUG][Severity 4] [] Not able to get the connection

I can't tell you with what you've given us.
What are you trying to connect to?
Do you have a stack trace?
The code where the error occurs?

Using WAS 6.0.2,DB2 and struts.Trying to connect to DB2 using JDBC.It keeps on throwing Connection Timeout Exception

Only 3 concurrent users for pilot run and 10 connections are allocated in connection pool of WAS.Using SessionDB for Session management of WAS.

There are two errors

1)SESN0040E: BackedHashtable:commonSetup - problem streaming object

2)com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180000

1)2/21/08 7:54:08:751 GMT] 00000cbc LocalTranCoor W WLTC0033W: Resource jdbc/in_gdbilling_resbill rolled back in cleanup of LocalTransactionContainment.
[2/21/08 7:54:08:785 GMT] 00000cbc LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainment.
[2/21/08 7:54:12:633 GMT] 000000ae SessionContex E SESN0040E: BackedHashtable:commonSetup - problem streaming object. Exception caught while trying to serialize session data for subsequent database write. The session data may be too large to serialize. Either put less data in the session or consider configuring Session Manager for MultiRow database mode.

2)[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getLocationsMap()
[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] handleModifyRequest(projSetupForm,session,user)
[residual_billing][ProjModifyInitialAction][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][ConnectionMgr][02/25 12:24:12.478][DEBUG][Severity 4] [] Not able to get the connection
com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180000
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:302)
at services.in.gdbilling.config.ConnectionMgr.getConnection(ConnectionMgr.java(Compiled Code))
at services.in.gdbilling.in.dao.ViewProjDAO.getProjInfo(ViewProjDAO.java:69)
at services.in.gdbilling.cc.helper.LogonHelper.createRBUser(LogonHelper.java:272)
at services.in.gdbilling.ui.logon.actions.LogonAction.execute(LogonAction.java:136)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)
[

Connection Timeout Error is hitting everywhere.I can not tell one place where it is going to hit.Users are complaining this error in different screens and places.It is very difficult to pinpoint the place where it throws this error.

00000337 LocalTranCoor W WLTC0033W: Resource jdbc/in_gdbilling_resbill rolled back in cleanup of LocalTransactionContainment.
00000337 LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled

Needs to following things
From Database
these are the apps currently connected:

Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
can whittle down the list of those app ids that are in lock wait, and those that are not,
and we can try purging the ones that you deem least likely to cause issues... the ones in
UOW status (idle) can usually be purged
Get lock snapshot , so that we can pin point why is this happening

while you're reading through that snaplock - I found another UOW thread - 885, it also has one X lock will check that after this force hmmm, looks like 932 is gone now
Paul can you please tell us what is LOCKTIMEOUT value?
can you please tell us what is LOCKTIMEOUT value
db2 get db cfg | grep LOCK
LOCKTIMEOUT=-1
db2 get db cfg for RESBILL |grep LOCK
Max storage for lock list (4KB) (LOCKLIST) = 100
Percent. of lock lists per application (MAXLOCKS) = 10
Lock timeout (sec) (LOCKTIMEOUT) = -1

what enterprising soul set that value, I wonder? no wonder all those apps are just sitting there lockwaiting

Needs to find out Lock Wait