dba-db2.com
Maximum connections allowed on a DB2 database - MAXAPPLS and MAX_COORDAGENTS

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

 

Read More

Command to see connection on a DB2 database - list applications

DB2 Instance Memory and dbptnmem - DBA DB2

 

Author: Jack Vamvas(http://www.dba-db2.com)

Subscribe to DBA-DB2.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright