银行实例参数
dft_mon开头的实例参数是重启后生效还是立即生效
我在db2 v9.5上执行，dft_mon开头的参数更新后，立即生效。db2 v10.5上执行，dft_mon开头的参数更新后，需要实例重启后才生效？
请问是这样子的吗？是从哪个版本开始变化的啊？收起
请问是这样子的吗？是从哪个版本开始变化的啊？收起
查看其它 10 个回答weiruan85的回答
db2sdin1@p780i1:/home/db2sdin1>db2 attach to db2sdin1
Instance Attachment Information
Instance server = DB2/AIX64 10.5.3
Authorization ID = DB2SDIN1
Local instance alias = DB2SDIN1
db2sdin1@p780i1:/home/db2sdin1>db2 get dbm cfg show detail |grep DFT_MON_STMT
Statement (DFT_MON_STMT) = ON ON
db2sdin1@p780i1:/home/db2sdin1>db2 update dbm cfg using DFT_MON_STMT off immediate
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
db2sdin1@p780i1:/home/db2sdin1>db2 get dbm cfg show detail |grep DFT_MON_STMT
Statement (DFT_MON_STMT) = OFF OFF
db2sdin1@p780i1:/home/db2sdin1>
db2sdin1@p780i1:/home/db2sdin1>db2 update dbm cfg using DFT_MON_STMT on immediate
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
db2sdin1@p780i1:/home/db2sdin1>
db2sdin1@p780i1:/home/db2sdin1>db2 get dbm cfg show detail |grep DFT_MON_STMT
Statement (DFT_MON_STMT) = ON ON
Instance Attachment Information
Instance server = DB2/AIX64 10.5.3
Authorization ID = DB2SDIN1
Local instance alias = DB2SDIN1
db2sdin1@p780i1:/home/db2sdin1>db2 get dbm cfg show detail |grep DFT_MON_STMT
Statement (DFT_MON_STMT) = ON ON
db2sdin1@p780i1:/home/db2sdin1>db2 update dbm cfg using DFT_MON_STMT off immediate
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
db2sdin1@p780i1:/home/db2sdin1>db2 get dbm cfg show detail |grep DFT_MON_STMT
Statement (DFT_MON_STMT) = OFF OFF
db2sdin1@p780i1:/home/db2sdin1>
db2sdin1@p780i1:/home/db2sdin1>db2 update dbm cfg using DFT_MON_STMT on immediate
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
db2sdin1@p780i1:/home/db2sdin1>
db2sdin1@p780i1:/home/db2sdin1>db2 get dbm cfg show detail |grep DFT_MON_STMT
Statement (DFT_MON_STMT) = ON ON
浏览1687