DB2 CLPコマンド

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

• 外部ファイル形式のいずれかにデータをエクスポート

 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

• 対話モード・セッション内で実行したコマンドの履歴を表示

 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

• 対話モード・コマンド履歴から指定のコマンドを実行

 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