银行 automatic
参数设置成automatic表示什么意思
我把sortheap调整为10240，sheapthres_shr调整为1024000db2 update db cfg for testdb using sortheap 10240 automaticdb2 update db cfg for testdb using sheapthres_shr 1024000 automatic这两句表示什么意思？10240是这个值的起始值吗？为什么我们生产环境这样... 显示全部
查看其它 6 个回答weiruan85 的回答
把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