Sample Header Ad - 728x90

How to restrict the number of connections to database from particular IP address on Db2 database?

0 votes
1 answer
491 views
On Db2 v11.5.8.0 Linux x86_64 database every few months some application opens up a lot of connections and it free them up pretty quickly like in 10 mins. I assume it has to be fat client application from Windows, because for WAS applications number of connections are restricted at application server level. Checking high water mark I get: db2 get snapshot for dbm | grep "High water mark for agents registered" > High water mark for agents registered = 4296 What is the best way to limit number of connections by (unknown) IP address? For example I want to restrict maximum number of connection from particular IP address to 100 connections. Bear in mind that I don't know the IP address, it can be any.
Asked by folow (523 rep)
Jan 5, 2023, 07:46 AM
Last activity: Jan 5, 2023, 05:06 PM