21 February,2013 by Jack Vamvas
Question: How can I find out the maximum amount of connections allowed on a DB2 database?
Answer: Work through this example to analyse the connections. The example indicates support for 68 (with room to grow) and the high watermark is 38.
To check at a database level check MAXAPPLS . This parameter specifies the maximum number of concurrent applications that can be connected to a database.
db2 get db cfg for DB_NAME | grep 'MAXAPPLS' --returns Max number of active applications (MAXAPPLS) = AUTOMATIC(68)
To check at an instance level check : MAX_COORDAGENTS , which is used to limit the number of coordinating agents and MAX_CONNECTIONS which reports the maximum number of client connections allowed per database partition
db2 get dbm cfg | grep 'MAX' --returns Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(200) Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS)
To check for the high watermark use
db2 get snapshot for dbm | grep 'High' --returns High water mark for agents registered = 38 High water mark for coordinating agents = 38 High water mark (bytes) = 15466496 High water mark (bytes) = 851968 High water mark (bytes) = 327680