Connectionpooling - Db2 issue under load

[naganaveen]

We are trying to execute a load test on Tomcat server which connects to DB2 database.
Under load, we are getting the below exception:

ERROR ; pool-1-thread-23; ?; XXXX; 2011-09-29 04:30:16,732 ; XXXX{msg: select failed with SQLException, iid: null, t: 0, code: null, loc: null, cat: null, srv: null, op: ViewStatus, sinf: WWW;D;82927, extra: {SQL=<<select query removed for security reasons>>, SQLErrorCode=-805, SQLState=51002, SQLException=DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH214 0X5359534C564C3031} }
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH214 0X5359534C564C3031
at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
at com.ibm.db2.jcc.b.gb.o(gb.java:747)
at com.ibm.db2.jcc.b.gb.g(gb.java:143)
at com.ibm.db2.jcc.b.gb.a(gb.java:39)
at com.ibm.db2.jcc.b.w.a(w.java:34)
at com.ibm.db2.jcc.b.vb.g(vb.java:139)
at com.ibm.db2.jcc.c.fg.n(fg.java:1177)
at com.ibm.db2.jcc.c.gg.eb(gg.java:1862)
at com.ibm.db2.jcc.c.gg.d(gg.java:2295)
at com.ibm.db2.jcc.c.gg.V(gg.java:424)
at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407)
at sun.reflect.GeneratedMethodAccessor118.invoke(Unkn own Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tomcat.jdbc.pool.interceptor.StatementD ecoratorInterceptor$StatementProxy.invoke(Statemen tDecoratorInterceptor.java:229)
at $Proxy7.executeQuery(Unknown Source)


My Db configuration is something like this:
<Resource auth="Container" driverClassName="com.ibm.db2.jcc.DB2Driver" size="54" minIdle="7" maxWait="20000" minEvictableIdleTimeMillis="840000" timeBetweenEvictionRunsMillis="300000" name="jdbc/Xyz" password="XXX" username="CCC" type="javax.sql.DataSource" url="jdbc:db2://<<servername>>:<<port>>/<<dbName>>" defaultTransactionIsolation="2" />


I have a questions here:
Why is the StatementDecoratorInterceptor.java is interfering when there is no interceptor configured.