High Number of Connections from SAP PI to Sender System Database

[Parthi1]

Hi All

We are having a JDBC to IDOC scenario, with 20 interfaces. All the 20 sender channels are connected to the same sender system database. In our environment we having 5 application servers with 2 nodes in each. JDBC thread count per node is of 15. - Sender system raised an issue that SAP PI creating more number of connections to their database around 3 million connections in a day. In Wily report we noticed around 1.5k connection per second per node to the Sender system .

Any idea why these many connections are initiated/generated from SAP PI to Sender System Database

Thanks in advance for your comments.

Thanks

Parthiban

[ravicarpenter]

What is the value for following parameters :

1. Max Concurrency

2. Disconnect DB after each message

[Parthi1]

Hi ravicarpenter

Thanks for your quick response, the issue we are facing here is for JDBC sender channel Channel.

As I mentioned here Sender Channels is configured to poll the database for every 1 second.

And maximum concurrency parameter can be set only for JDBC receiver Channel.

Thanks

Parthiban

[former_member244098]

Hello Parthiban,

Check the blog below:
https://blogs.sap.com/2012/12/14/decoding-max-concurrency-poolwaittime-driver-properties-in-jdbc-rec...

It is possible to limit the number of parallel database connections by setting the value in the Maximum Concurrency parameter.

Regards,
Natassja

[Parthi1]

Hi natassja.davila

Thanks for your quick response, the issue we are facing here is for JDBC sender channel Channel.

As I mentioned here Sender Channels is configured to poll the database for every 1 second.

And maximum concurrency parameter can be set only for JDBC receiver Channel.

Could you please share any KBA / post available for limiting parallel database connection for JDBC Sender Channel.

Thanks

Parthiban