银行 automatic
参数设置成automatic表示什么意思
我把sortheap调整为10240，sheapthres_shr调整为1024000db2 update db cfg for testdb using sortheap 10240 automatic
db2 update db cfg for testdb using sheapthres_shr
1024000 automatic
这两句表示什么意思？10240是这个值的起始值吗？
为什么我们生产环境这样设置后，现在sortheap又变成900了哪？sheapthres_shr也变成比较小了？
难道是我理解错误吗？我一直以为设置成这样子表示10240是这个参数的最小值！
db2 update db cfg for testdb using sheapthres_shr
1024000 automatic
这两句表示什么意思？10240是这个值的起始值吗？
为什么我们生产环境这样设置后，现在sortheap又变成900了哪？sheapthres_shr也变成比较小了？
难道是我理解错误吗？我一直以为设置成这样子表示10240是这个参数的最小值！
7 同行回答
把stmm 的log看看 就知道了。 或者传上来分析下。
When updating a parameter to automatic, it is also possible to specify a starting value as well as the AUTOMATIC keyword. Note that the value can mean something different for each parameter, and in some cases it is not applicable. Before specifying a value, read the parameter's documentation to determine what it represents. In the following example, num_poolagents will be updated to AUTOMATIC and the database manager will use 20 as the minimum number of idle agents to pool:
db2 update dbm cfg using num_poolagents 20 automatic 收起
When updating a parameter to automatic, it is also possible to specify a starting value as well as the AUTOMATIC keyword. Note that the value can mean something different for each parameter, and in some cases it is not applicable. Before specifying a value, read the parameter's documentation to determine what it represents. In the following example, num_poolagents will be updated to AUTOMATIC and the database manager will use 20 as the minimum number of idle agents to pool:
db2 update dbm cfg using num_poolagents 20 automatic 收起
