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@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
收起