DB2实用命令记录
quiesce tablespace
quiesce tablespaces for table <table_name> share;
Monitor Switches
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 [nodename] REMOTE [IP] SERVER [Port]
DB2 CATALOG DATABASE [dbname] AS [dbalias] AT NODE [nodename]
DB2 UNCATALOG NODE [nodename]
