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最大一致?
谢谢了~~~~
收起