DB2 CLP指令简要汇总

DB2　CLP指令简要汇总：

CODE:

CLP Session Control

“LIST COMMAND OPTIONS”
“UPDATE COMMAND OPTIONS”
“CHANGE ISOLATION LEVEL”
“SET RUNTIME DEGREE”
“TERMINATE”
“QUIT”

Database Manager Control

“START DATABASE MANAGER”
“STOP DATABASE MANAGER”
“GET DATABASE MANAGER CONFIGURATION”
“RESET DATABASE MANAGER CONFIGURATION”
“UPDATE DATABASE MANAGER CONFIGURATION”
“AUTOCONFIGURE”

Database Control

“RESTART DATABASE”
“CREATE DATABASE”
“DROP DATABASE”
“MIGRATE DATABASE”
“ACTIVATE DATABASE”
“DEACTIVATE DATABASE”
“QUIESCE”
“UNQUIESCE”
“LIST INDOUBT TRANSACTIONS”
“LIST DRDA INDOUBT TRANSACTIONS”
“GET DATABASE CONFIGURATION”
“RESET DATABASE CONFIGURATION”
“UPDATE DATABASE CONFIGURATION”
“AUTOCONFIGURE”

Database Directory Management

“CATALOG DATABASE”
“UNCATALOG DATABASE”
“CATALOG DCS DATABASE”
“UNCATALOG DCS DATABASE”
“CHANGE DATABASE COMMENT”
“LIST DATABASE DIRECTORY”
“LIST DCS DIRECTORY”

ODBC Management

“CATALOG ODBC DATA SOURCE”
“LIST ODBC DATA SOURCES”
“UNCATALOG ODBC DATA SOURCE”
“GET CLI CONFIGURATION”
“UPDATE CLI CONFIGURATION”

Client/Server Directory Management

“CATALOG LOCAL NODE”
“CATALOG NAMED PIPE NODE”
“CATALOG APPC NODE”
“CATALOG APPN NODE”
“CATALOG NETBIOS NODE”
“CATALOG TCP/IP NODE”
“UNCATALOG NODE”
“LIST NODE DIRECTORY”

Network Support

“REGISTER”
“DEREGISTER”
“UPDATE LDAP NODE”
“CATALOG LDAP DATABASE”
“UNCATALOG LDAP DATABASE”
“CATALOG LDAP NODE”
“UNCATALOG LDAP NODE”
“REFRESH LDAP”

DB2 Administration Server

“GET ADMIN CONFIGURATION”
“RESET ADMIN CONFIGURATION”
“UPDATE ADMIN CONFIGURATION”
“CREATE TOOLS CATALOG”
“DROP TOOLS CATALOG”

Recovery

“ARCHIVE LOG”
“BACKUP DATABASE”
“RECONCILE”
“RESTORE DATABASE”
“ROLLFORWARD DATABASE”
“LIST HISTORY”
“PRUNE HISTORY/LOGFILE”
“UPDATE HISTORY FILE”
“INITIALIZE TAPE”
“REWIND TAPE”
“SET TAPE POSITION”

Operational Utilities

“FORCE APPLICATION”
“LIST PACKAGES/TABLES”
“REORGCHK”
“REORG INDEXES/TABLE”
“RUNSTATS”

Database Monitoring

“GET MONITOR SWITCHES”
“UPDATE MONITOR SWITCHES”
“GET DATABASE MANAGER MONITOR SWITCHES”
“GET SNAPSHOT”
“RESET MONITOR”
“INSPECT”
“LIST ACTIVE DATABASES”
“LIST APPLICATIONS”
“LIST DCS APPLICATIONS”

Data Utilities

“EXPORT”
“IMPORT”
“LOAD”
“LOAD QUERY”

Health Center

“ADD CONTACT”
“ADD CONTACTGROUP”
“DROP CONTACT”
“DROP CONTACTGROUP”
“GET ALERT CONFIGURATION”
“GET CONTACTGROUP”
“GET CONTACTGROUPS”
“GET CONTACTS”
“GET DESCRIPTION FOR HEALTH INDICATOR”
“GET HEALTH NOTIFICATION CONTACT LIST”
“GET HEALTH SNAPSHOT”
“GET RECOMMENDATIONS”
“RESET ALERT CONFIGURATION”
“UPDATE ALERT CONFIGURATION”
“UPDATE CONTACT”
“UPDATE CONTACTGROUP”
“UPDATE HEALTH NOTIFICATION CONTACT LIST”

Application Preparation

“PRECOMPILE”
“BIND”
“REBIND”

Remote Server Utilities

“ATTACH”
“DETACH”

Table Space Management

“LIST TABLESPACE CONTAINERS”
“SET TABLESPACE CONTAINERS”
“LIST TABLESPACES”
“QUIESCE TABLESPACES FOR TABLE”

Database Partition Management

“ADD DBPARTITIONNUM”
“DROP DBPARTITIONNUM VERIFY”
“LIST DBPARTITIONNUMS”

Database Partition Group Management

“LIST DATABASE PARTITION GROUPS”
“REDISTRIBUTE DATABASE PARTITION GROUP”

Data Links

“ADD DATALINKS MANAGER”
“DROP DATALINKS MANAGER”
“LIST DATALINKS MANAGERS”

Additional Commands

“DESCRIBE”
“ECHO”
“GET AUTHORIZATIONS”
“GET CONNECTION STATE”
“GET INSTANCE”
“GET ROUTINE”
“HELP”
“PING”
“PUT ROUTINE”
“QUERY CLIENT”
“SET CLIENT”

还有一种情况是对于DB2系统指令，这类命令没有统一的获得指令帮助的方法，最好的办法是查阅《Command Reference》，但很多指令都可以用"-h"或"-？"参数获得帮助，如db2icrt、db2idrop、db2licm、db2pd、db2support等等，但也有许多不需要加参数的指令就不能用以上办法，如：db2stop、db2start、db2ilist等，不过加上"-h"或"-？"也只会出个错误提示，但是有的不可以轻易尝试，如db2_kill，最好还是看手册吧!这些指令存在于实例目录下sqllib/bin目录下，有兴趣的可以看一下!

 

 

不过需要注意的是，这些命令的涉及到数据库的起停等等，建议可以在自己的机器上安装一个本地的作测试，禁止在生产系统中作