Operating System Information:

OSName: SunOS
NodeName: domain5
Version: Generic_117000-03
Release: 5.8
Machine: sun4u

Instance db2inst1 uses 32 bits and DB2 code release SQL08020
with level identifier 03010106
Informational tokens are DB2 v8.1.0.72, s040914, U498351, FixPak 7.


Max number of existing agents (MAXAGENTS) = 1000
Maximum query degree of parallelism (MAX_QUERYDEGREE) = 8
Enable intra-partition parallelism (INTRA_PARALLEL) = YES

Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 100000
Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70
Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 512

I have serval question:
1. The maxconnections=min(1000,100000/512)=195
is it right?
2. when (INTRA_PARALLEL) = YES
the memory is : 100000*4k*0.7 is shared , for every application 512*4k*0.3 is allowed
when (INTRA_PARALLEL) = no

for every application 512*4k is allowed
is it right?

3. how can estimate the number of subagents and monitor active agents counts and subagent counts?


anybody helps me ,thanks

One of the things on SunOS is that to identify DB2 process using ps will show only 'db2sysc'. Use db2ptree to get the right picture.

HTH.