DB2实用命令记录
quiesce tablespacequiesce tablespaces for table <table_name> share;
Monitor Switches
details on http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.admin.mon.doc/doc/c0005719.html
update monitor switches on instance level - With the IBM client on the server machine(it would not take affect with client not on the server)
DB2 UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
DB2 UPDATE DBM CFG USING DFT_MON_LOCK ON
DB2 UPDATE DBM CFG USING DFT_MON_SORT ON
DB2 UPDATE DBM CFG USING DFT_MON_STMT ON
DB2 UPDATE DBM CFG USING DFT_MON_TABLE ON
DB2 UPDATE DBM CFG USING DFT_MON_TIMESTAMP OFF
DB2 UPDATE DBM CFG USING DFT_MON_UOW ON
Update monitor switches on application level
db2 update monitor switches using BUFFERPOOL off global
Reset monitor switches
DB2 Reset DBM CFG
see details on http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0001970.html
Check the DB2 server version
SELECT SERVICE_LEVEL FROM SYSIBMADM.ENV_INST_INFO FOR FETCH ONLY WITH UR
Config Server with command
DB2 CATALOG TCPIP NODE REMOTE SERVER
DB2 CATALOG DATABASE AS AT NODE
DB2 UNCATALOG NODE
页:
[1]