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最大一致？
谢谢了~~~~
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最大一致？
谢谢了~~~~
8同行回答
多谢！学习收起
浏览1550
MAX_COORDAGENTS) = AUTOMATIC(200) ---200是起始值吗？还是当前值啊？如果对于automatic的设置，我想看 ...wangzk0206 发表于 2013-10-8 09:16
get db cfg for xxx show detailMAX_COORDAGENTS) = AUTOMATIC(200) ---200是起始值吗？还是当前值啊？
如果对于automatic的设置，我想看 ...
wangzk0206 发表于 2013-10-8 09:16
get db cfg for xxx show detail收起
浏览1602
MAX_COORDAGENTS) = AUTOMATIC(200) ---200是起始值吗？还是当前值啊？
如果对于automatic的设置，我想看这个参数当前值那该怎么看哪？收起
如果对于automatic的设置，我想看这个参数当前值那该怎么看哪？收起
浏览1538
问题一：没有问题。
问题二：从DB2本源出发，运行中，这三个库的运行时的值应该小于MAX_CONNECTIONS的运行时的值。当前这个设置是没问题的，DBM和DB都会自动调整这些值得，AUTOMATIC后面括号里面的值只是起始值，而且这个起始值是仅供DB2自主模块参考而已，根据连接和实例，数据库情况自动调整。
问题三：
MAX_COORDAGENTS) = AUTOMATIC(200) ，200是指这个参数的起始值是200，后续会变化，可能减少，也可能增加，自主模块自决。
MIN_COORDAGENTS) = AUTOMATIC(200)，没有这个参数，假设有，也是指该值的起始值，不是最小值
MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS) 是指MAX_CONNECTIONS 与MAX_COORDAGENTS 不是指最大值一致，而是指MAX_CONNECTIONS参数是AUTOMATIC，而且起始值是MAX_COORDAGENTS的当前值，后续这两个值可能会不一样。
不知道楼主你明白了没有。收起
问题二：从DB2本源出发，运行中，这三个库的运行时的值应该小于MAX_CONNECTIONS的运行时的值。当前这个设置是没问题的，DBM和DB都会自动调整这些值得，AUTOMATIC后面括号里面的值只是起始值，而且这个起始值是仅供DB2自主模块参考而已，根据连接和实例，数据库情况自动调整。
问题三：
MAX_COORDAGENTS) = AUTOMATIC(200) ，200是指这个参数的起始值是200，后续会变化，可能减少，也可能增加，自主模块自决。
MIN_COORDAGENTS) = AUTOMATIC(200)，没有这个参数，假设有，也是指该值的起始值，不是最小值
MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS) 是指MAX_CONNECTIONS 与MAX_COORDAGENTS 不是指最大值一致，而是指MAX_CONNECTIONS参数是AUTOMATIC，而且起始值是MAX_COORDAGENTS的当前值，后续这两个值可能会不一样。
不知道楼主你明白了没有。收起
浏览1494
楼上的兄弟说的很有道理的，参数的设置和具体的应用也有关系的收起
浏览1508
那个number只是参考值。 请看db2 manual：
AUTOMATIC
Some configuration parameters can be set to AUTOMATIC, allowing DB2® to automatically adjust these parameters to reflect the current resource requirements. For a list of configuration parameters that support the AUTOMATIC keyword, refer to the configuration parameters summary. If a value is specified along with the AUTOMATIC keyword, it might influence the automatic calculations.收起
AUTOMATIC
Some configuration parameters can be set to AUTOMATIC, allowing DB2® to automatically adjust these parameters to reflect the current resource requirements. For a list of configuration parameters that support the AUTOMATIC keyword, refer to the configuration parameters summary. If a value is specified along with the AUTOMATIC keyword, it might influence the automatic calculations.收起
浏览1513
