Hello Christopher, Thankyou !
Seems we are not using the connection pooling from Tomcat side , below are the DB configuration parameters on context.xml file, do not see any connection pool details here. <Resource name="jdbc/db2" auth="Container" type="javax.sql.DataSource" driverClassName="com.ibm.db2.jcc.DB2Driver" url="jdbc:db2://30.177.13.12:3700/TIREHQ" maxActive="200" maxIdle="30" maxWait="10000" username="wing2" password="w1ngf00t" /> <Resource > I have one more question , Sorry to bother again . Can the below parameters can aid us with this issue , as given on the below Technote , if yes how we need to determine the timings for these parameters. minEvictableIdleTimeMillis timeBetweenEvictionRunsMillis validationQuery removeAbandoned removeAbandonedTimeout https://support.hcltechsw.com/csm?id=kb_article&sysparm_article=KB0098601 Thanks & Regards, Priyanka Kumawat | Middleware Admin T +91.7879364483 EMail - priyanka.kuma...@dxc.com DL - ams-leveraged-webadmin-offsh...@dxc.com DXC Technology -----Original Message----- From: Christopher Schultz <ch...@christopherschultz.net> Sent: 21 October 2022 00:50 To: Kumawat, Priyanka <priyanka.kuma...@dxc.com>; Tomcat Users List <users@tomcat.apache.org> Subject: Re: DB2 database locks Priyanka, On 10/20/22 13:15, Kumawat, Priyanka wrote: > Thankyou muck for the explanation for this !!! we have got from below > mail that it is likely to be an application coding issue and they > needs to fix or use commit etc for long running transactions . > > The one steps that you have given below to set the "query timeout" , > is this one we can set up on Tomcat side? That depends upon how you are obtaining you database connections. If you are using a connection pool provided by Tomcat (either tomcat-pool or dbcp-pool) then you can configure according to the documentation for whichever component you are using (they have similar but different configuration styles). -chris DXC Technology Company -- This message is transmitted to you by or on behalf of DXC Technology Company or one of its affiliates. It is intended exclusively for the addressee. The substance of this message, along with any attachments, may contain proprietary, confidential or privileged information or information that is otherwise legally exempt from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate any part of this message. If you have received this message in error, please destroy and delete all copies and notify the sender by return e-mail. Regardless of content, this e-mail shall not operate to bind DXC Technology Company or any of its affiliates to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
