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
Last activity: Jan 5, 2023, 05:06 PM