db2性能调优--最大连接数

SYGSYWDB01:/ywdata/aicmis$>db2 get db cfg for bas | grep MAX
Percent. of lock lists per application       (MAXLOCKS) = 30
Package cache size (4KB)                   (PCKCACHESZ) = (MAXAPPLS*8)
Catalog cache size (4KB)              (CATALOGCACHE_SZ) = (MAXAPPLS*5)
Max number of active applications            (MAXAPPLS) = AUTOMATIC(1252)
Max DB files open per application            (MAXFILOP) = 61440
Percent max primary log space by transaction  (MAX_LOG) = 0
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100


SYGSYWDB01:/ywdata/aicmis$>db2 get db cfg for biz | grep MAX
Percent. of lock lists per application       (MAXLOCKS) = 30
Max number of active applications            (MAXAPPLS) = AUTOMATIC(1627)
Max DB files open per application            (MAXFILOP) = 61440
Percent max primary log space by transaction  (MAX_LOG) = 0
Percent log file reclaimed before soft chckpt (SOFTMAX) = 520


SYGSYWDB01:/ywdata/aicmis$>db2 get db cfg for wsnj | grep MAX
Percent. of lock lists per application       (MAXLOCKS) = 60
Max number of active applications            (MAXAPPLS) = AUTOMATIC(678)
Max DB files open per application            (MAXFILOP) = 61440
Percent max primary log space by transaction  (MAX_LOG) = 0
Percent log file reclaimed before soft chckpt (SOFTMAX) = 520


SYGSYWDB01:/ywdata/aicmis$>db2 get dbm cfg | grep MAX
Max number of coordinating agents     (MAX_COORDAGENTS) = AUTOMATIC(200)
Max number of client connections      (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS)
Number of pooled fenced processes         (FENCED_POOL) = AUTOMATIC(MAX_COORDAGENTS)
SPM resync agent limit                 (SPM_MAX_RESYNC) = 20
Maximum query degree of parallelism   (MAX_QUERYDEGREE) = ANY
Max number of node connection retries (MAX_CONNRETRIES) = 5
Max time difference between nodes (min) (MAX_TIME_DIFF) = 60


问题一：最大连接数配置有问题吗？
问题二：实例下面挂着3个库，bas、 biz、 wsnj 正常是不是应该三个库 MAXAPPLS之和小于实例的 MAX_CONNECTIONS？
问题三：  (MAX_COORDAGENTS) = AUTOMATIC(200) 是指MAX_COORDAGENTS最大不超过200？
反之 (MIN_COORDAGENTS) = AUTOMATIC(200) 是指MIX_COORDAGENTS最小不小于200？
(MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS) 是指MAX_CONNECTIONS 与MAX_COORDAGENTS最大一致？


谢谢了~~~~收起