!!!DB2 CLPコマンド
[DB2]

*http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/nav/3_6_2_4
!!ACTIVATE DATABASE
!!ADD CONTACT
!!ADD CONTACTGROUP
!!ADD DBPARTITIONNUM
!!ADD XMLSCHEMA DOCUMENT
!!ARCHIVE LOG
!!ATTACH
!!AUTOCONFIGURE
!!BACKUP DATABASE
!!BIND
!!CATALOG DATABASE
!!CATALOG DCS DATABASE
!!CATALOG LDAP DATABASE
!!CATALOG LDAP NODE
!!CATALOG LOCAL NODE
!!CATALOG NAMED PIPE NODE
!!CATALOG ODBC DATA SOURCE
!!CATALOG TCPIP NODE
!!CHANGE DATABASE COMMENT
!!CHANGE ISOLATION LEVEL
!!COMPLETE XMLSCHEMA
!!CREATE DATABASE
!!CREATE TOOLS CATALOG
!!DEACTIVATE DATABASE
!!DECOMPOSE XML DOCUMENT
!!DECOMPOSE XML DOCUMENTS
!!DEREGISTER
!!DESCRIBE
!!DETACH
!!DROP CONTACT
!!DROP CONTACTGROUP
!!DROP DATABASE
!!DROP DBPARTITIONNUM VERIFY
!!DROP TOOLS CATALOG
!!ECHO
!!EDIT
!![EXPORT|http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0008303.html]
*外部ファイル形式のいずれかにデータをエクスポート
!!FORCE APPLICATION
!!GET ADMIN CONFIGURATION
!!GET ALERT CONFIGURATION
!!GET CLI CONFIGURATION
!!GET CONNECTION STATE
!!GET CONTACTGROUP
!!GET CONTACTGROUPS
!!GET CONTACTS
!!GET DATABASE CONFIGURATION
!!GET DATABASE MANAGER CONFIGURATION
!!GET DATABASE MANAGER MONITOR SWITCHES
!!GET DESCRIPTION FOR HEALTH INDICATOR
!!GET HEALTH NOTIFICATION CONTACT LIST
!!GET HEALTH SNAPSHOT
!!GET INSTANCE
!!GET MONITOR SWITCHES
!!GET RECOMMENDATIONS FOR HEALTH INDICATOR
!!GET ROUTINE
!!GET SNAPSHOT
!!HELP
!![HISTORY|http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0010839.html]
*対話モード・セッション内で実行したコマンドの履歴を表示
!!IMPORT
!!INITIALIZE TAPE
!!INSPECT
!!LIST ACTIVE DATABASES
!!LIST APPLICATIONS
!!LIST COMMAND OPTIONS
!!LIST DATABASE DIRECTORY
!!LIST DATABASE PARTITION GROUPS
!!LIST DBPARTITIONNUMS
!!LIST DCS APPLICATIONS
!!LIST DCS DIRECTORY
!!LIST DRDA INDOUBT TRANSACTIONS
!!LIST HISTORY
!!LIST INDOUBT TRANSACTIONS
!!LIST NODE DIRECTORY
!!LIST ODBC DATA SOURCES
!!LIST PACKAGES/TABLES
!!LIST TABLESPACE CONTAINERS
!!LIST TABLESPACES
!!LIST UTILITIES
!!LOAD
!!LOAD QUERY
!!MIGRATE DATABASE
!!PING
!!PRECOMPILE
!!PRUNE HISTORY/LOGFILE
!!PUT ROUTINE
!!QUERY CLIENT
!!QUIESCE
!!QUIESCE TABLESPACES FOR TABLE
!!QUIT
!!REBIND
!!RECOVER DATABASE
!!REDISTRIBUTE DATABASE PARTITION GROUP
!!REFRESH LDAP
!!REGISTER
!!REGISTER XMLSCHEMA
!!REGISTER XSROBJECT
!!REORG INDEXES/TABLE
!!REORGCHK
!!RESET ADMIN CONFIGURATION
!!RESET ALERT CONFIGURATION
!!RESET DATABASE CONFIGURATION
!!RESET DATABASE MANAGER CONFIGURATION
!!RESET MONITOR
!!RESTART DATABASE
!!RESTORE DATABASE
!!REWIND TAPE
!!ROLLFORWARD DATABASE
!![RUNCMD|http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0010840.html]
* 対話モード・コマンド履歴から指定のコマンドを実行
!!RUNSTATS
!!SET CLIENT
!!SET RUNTIME DEGREE
!!SET SERVEROUTPUT
!!SET TABLESPACE CONTAINERS
!!SET TAPE POSITION
!!SET UTIL_IMPACT_PRIORITY
!!SET WORKLOAD
!!SET WRITE
!!START DATABASE MANAGER
!!START HADR
!!STOP DATABASE MANAGER
!!STOP HADR
!!TAKEOVER HADR
!!TERMINATE
!!UNCATALOG DATABASE
!!UNCATALOG DCS DATABASE
!!UNCATALOG LDAP DATABASE
!!UNCATALOG LDAP NODE
!!UNCATALOG NODE
!!UNCATALOG ODBC DATA SOURCE
!!UNQUIESCE
!!UPDATE ADMIN CONFIGURATION
!!UPDATE ALERT CONFIGURATION
!!UPDATE ALTERNATE SERVER FOR DATABASE
!!UPDATE ALTERNATE SERVER FOR LDAP
!!UPDATE CLI CONFIGURATION
!!UPDATE COMMAND OPTIONS
!!UPDATE CONTACT
!!UPDATE CONTACTGROUP
!!UPDATE DATABASE CONFIGURATION
!!UPDATE DATABASE MANAGER CONFIGURATION
!!UPDATE HEALTH NOTIFICATION CONTACT LIST
!!UPDATE HISTORY FILE
!!UPDATE LDAP NODE
!!UPDATE MONITOR SWITCHES
!!UPDATE XMLSCHEMA
!!UPGRADE DATABASE