Hi All,
I am using DB28.1 ee FP4 solaris.
Here is my db and dbm cfg, My doubt is I got an error in my instance notify file :
New connection unable to connect the database.

ADM7523E DB2 was unable to allocate the application group memory set. This
will cause database activation to fail. Reduce the APPGROUP_MEM_SZ DB
configuration parameter and retry.
Previously i had the value for appgroup_mem_sz 30000 and , i reduced to 7500, still i got the same error. After seeing this error again i reduced into 3000 now i am not getting this error.

Here our database is getting connections upto 800 at same time. once it came near to 700, i am getting this error but not after the value changed to 3000.

I checked with the recommendations from autoconfigure command but i am seeing the value is different and it shows unrealistic value, if i change my APPGROUP_MEM_SZ parameter to that value, surely it will throw the error back again.

Could you please recommend the correct value for my dbm and db cfg, or i can follow the with the IBM autoconfigure recommendations.

Our applications is totally developed in c++ and no stored procedures.

Thanks n advance.

Current and Recommended Values for Database Manager Configuration.

Description Parameter Current Value Recommended Value
Application support layer heap size (4KB) (ASLHEAPSZ) = 256 256
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 4096 4096
Enable intra-partition parallelism (INTRA_PARALLEL) = YES YES
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY 4
Max number of existing agents (MAXAGENTS) = 875 400
Agent pool size (NUM_POOLAGENTS) = 250 40
Initial number of agents in pool (NUM_INITAGENTS) = 50 0
Max requester I/O block size (bytes) (RQRIOBLK) = 32767 32767
Sort heap threshold (4KB) (SHEAPTHRES) = 20000 48886

Current and Recommended Values for Database Configuration

Description Parameter Current Value Recommended Value
Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 1024 160
Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 3000 16850
Default application heap (4KB) (APPLHEAPSZ) = 2048 2048
Catalog cache size (4KB) (CATALOGCACHE_SZ) = (MAXAPPLS*4) 761
Changed pages threshold (CHNGPGS_THRESH) = 60 60
Database heap (4KB) (DBHEAP) = 1200 3318
Degree of parallelism (DFT_DEGREE) = 1 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32 32
Default prefetch size (pages) (DFT_PREFETCH_SZ) = 32 32
Default query optimization class (DFT_QUERYOPT) = 5 5
Max storage for lock list (4KB) (LOCKLIST) = 20000 2275
Log buffer size (4KB) (LOGBUFSZ) = 8 99
Log file size (4KB) (LOGFILSIZ) = 4096 1024
Number of primary log files (LOGPRIMARY) = 20 3
Number of secondary log files (LOGSECOND) = 10 0
Max number of active applications (MAXAPPLS) = 1000 40
Percent. of lock lists per application (MAXLOCKS) = 10 60
Group commit count (MINCOMMIT) = 1 1
Number of asynchronous page cleaners (NUM_IOCLEANERS) = 1 1
Number of I/O servers (NUM_IOSERVERS) = 3 5
Package cache size (4KB) (PCKCACHESZ) = (MAXAPPLS*8) 859
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100 120
Sort list heap (4KB) (SORTHEAP) = 1024 2444
SQL statement heap (4KB) (STMTHEAP) = 2048 2048
Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384 4384
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000 157797

Current and Recommended Values for Bufferpool(s)

Description Parameter Current Value Recommended Value
IBMDEFAULTBP Bufferpool size = 40000 473392

DB210203I AUTOCONFIGURE completed successfully. Database manager or database
configuration values may have been changed. The instance must be restarted
before any changes come into effect. You may also want to rebind your packages
after the new configuration parameters take effect so that the new values will
be used.