Maximum connections allowed on a DB2 database - MAXAPPLS and MAX_COORDAGENTS

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

Read More

Command to see connection on a DB2 database - list applications

DB2 Instance Memory and dbptnmem - DBA DB2