On a AIX 5.2, DB2 UDB V8.2, the dbm snapshot is as below.
There are around 50 applications at any point of time, intra-parallel
turned on, oltp and reporting queries are run on the server. 8 Gigs of
RAM, what parameters are recommended for
maxagents,max_coordagents,maxcagents,maxconnection s?
If you require other information, I'd be glad to post.
Thanks for the help.
Database Manager Snapshot
Node type = Database Server with
local and remote clients
Instance name = db2inst1
Number of database partitions in DB2 instance = 1
Database manager status = Active
Product name = DB2 v8.1.1.72
Service level = s040914 (U498350)
Private Sort heap allocated = 0
Private Sort heap high water mark = 14400
Post threshold sorts = 0
Piped sorts requested = 189025
Piped sorts accepted = 189025
Start Database Manager timestamp = 08/24/2005
03:00:11.215364
Last reset timestamp =
Snapshot timestamp = 08/24/2005
20:46:03.522502
Remote connections to db manager = 9
Remote connections executing in db manager = 0
Local connections = 0
Local connections executing in db manager = 0
Active local databases = 2
High water mark for agents registered = 80
High water mark for agents waiting for a token = 0
Agents registered = 75
Agents waiting for a token = 0
Idle agents = 21
Committed private Memory (Bytes) = 7782400
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = ON 08/24/2005
10:54:24.129543
Sorting Information (SORT) = ON 08/24/2005
11:23:42.289088
SQL Statement Information (STATEMENT) = ON 08/24/2005
11:23:11.784507
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 08/24/2005
13:44:09.689430
Unit of Work Information (UOW) = ON 08/24/2005
11:23:34.652421
Agents assigned from pool = 183838
Agents created from empty pool = 217
Agents stolen from another application = 272
High water mark for coordinating agents = 39
Max agents overflow = 0
Hash joins after heap threshold exceeded = 57
Total number of gateway connections = 0
Current number of gateway connections = 0
Gateway connections waiting for host reply = 0
Gateway connections waiting for client request = 0
Gateway connection pool agents stolen = 0
Node FCM information corresponds to = 0
Free FCM buffers = 1024
Free FCM buffers low water mark = 973
Free FCM message anchors = 384
Free FCM message anchors low water mark = 382
Free FCM connection entries = 384
Free FCM connection entries low water mark = 356
Free FCM request blocks = 358
Free FCM request blocks low water mark = 331
Memory usage for database manager:
Node number = 0
Memory Pool Type = FCMBP Heap
Current size (bytes) = 4456448
High water mark (bytes) = 4456448
Configured size (bytes) = 4505600
Node number = 0
Memory Pool Type = Database Monitor Heap
Current size (bytes) = 196608
High water mark (bytes) = 360448
Configured size (bytes) = 819200
Node number = 0
Memory Pool Type = Other Memory
Current size (bytes) = 2523136
High water mark (bytes) = 2539520
Configured size (bytes) = 23379968