Several open connections noticed in DB2
[access connections] [adapter] [connections] [connections tray] [DB2] [JDBC] [max connections] [open]
Related:
- Configuring timeout for dummy SQL query in advanced modeSymptom You are using JDBC adapter in your scenarios with...
- Configuring Maximum Message Size Limits for OOM ErrorSymptom You notice that the J2EE Engine restarts frequently, due...
Symptom
During the processing of JDBC receiver communication channels, too many open connections are noticed in the DB2 logs, which in turn lead to performance problems.
Other terms
JDBC, DB2, open connections, JDBC Adapter
Reason and Prerequisites
This issue occured due to a programmatic error.
Solution
The issue has been solved by changes in the code. The archives and the
support package stack guide can be found on the SAP Service Marketplace as described in SAP Note 952402.