「DB2 CLPコマンド」の版間の差分
ナビゲーションに移動
検索に移動
| 1行目: | 1行目: | ||
==DB2 CLPコマンド== | ==DB2 CLPコマンド== | ||
| − | [[DB2]] | + | [[DB2]] | |
*http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/nav/3_6_2_4 | *http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/nav/3_6_2_4 | ||
2020年2月15日 (土) 08:34時点における版
目次
- 1 DB2 CLPコマンド
- 1.1 ACTIVATE DATABASE
- 1.2 ADD CONTACT
- 1.3 ADD CONTACTGROUP
- 1.4 ADD DBPARTITIONNUM
- 1.5 ADD XMLSCHEMA DOCUMENT
- 1.6 ARCHIVE LOG
- 1.7 ATTACH
- 1.8 AUTOCONFIGURE
- 1.9 BACKUP DATABASE
- 1.10 BIND
- 1.11 CATALOG DATABASE
- 1.12 CATALOG DCS DATABASE
- 1.13 CATALOG LDAP DATABASE
- 1.14 CATALOG LDAP NODE
- 1.15 CATALOG LOCAL NODE
- 1.16 CATALOG NAMED PIPE NODE
- 1.17 CATALOG ODBC DATA SOURCE
- 1.18 CATALOG TCPIP NODE
- 1.19 CHANGE DATABASE COMMENT
- 1.20 CHANGE ISOLATION LEVEL
- 1.21 COMPLETE XMLSCHEMA
- 1.22 CREATE DATABASE
- 1.23 CREATE TOOLS CATALOG
- 1.24 DEACTIVATE DATABASE
- 1.25 DECOMPOSE XML DOCUMENT
- 1.26 DECOMPOSE XML DOCUMENTS
- 1.27 DEREGISTER
- 1.28 DESCRIBE
- 1.29 DETACH
- 1.30 DROP CONTACT
- 1.31 DROP CONTACTGROUP
- 1.32 DROP DATABASE
- 1.33 DROP DBPARTITIONNUM VERIFY
- 1.34 DROP TOOLS CATALOG
- 1.35 ECHO
- 1.36 EDIT
- 1.37 EXPORT
- 1.38 FORCE APPLICATION
- 1.39 GET ADMIN CONFIGURATION
- 1.40 GET ALERT CONFIGURATION
- 1.41 GET CLI CONFIGURATION
- 1.42 GET CONNECTION STATE
- 1.43 GET CONTACTGROUP
- 1.44 GET CONTACTGROUPS
- 1.45 GET CONTACTS
- 1.46 GET DATABASE CONFIGURATION
- 1.47 GET DATABASE MANAGER CONFIGURATION
- 1.48 GET DATABASE MANAGER MONITOR SWITCHES
- 1.49 GET DESCRIPTION FOR HEALTH INDICATOR
- 1.50 GET HEALTH NOTIFICATION CONTACT LIST
- 1.51 GET HEALTH SNAPSHOT
- 1.52 GET INSTANCE
- 1.53 GET MONITOR SWITCHES
- 1.54 GET RECOMMENDATIONS FOR HEALTH INDICATOR
- 1.55 GET ROUTINE
- 1.56 GET SNAPSHOT
- 1.57 HELP
- 1.58 HISTORY
- 1.59 IMPORT
- 1.60 INITIALIZE TAPE
- 1.61 INSPECT
- 1.62 LIST ACTIVE DATABASES
- 1.63 LIST APPLICATIONS
- 1.64 LIST COMMAND OPTIONS
- 1.65 LIST DATABASE DIRECTORY
- 1.66 LIST DATABASE PARTITION GROUPS
- 1.67 LIST DBPARTITIONNUMS
- 1.68 LIST DCS APPLICATIONS
- 1.69 LIST DCS DIRECTORY
- 1.70 LIST DRDA INDOUBT TRANSACTIONS
- 1.71 LIST HISTORY
- 1.72 LIST INDOUBT TRANSACTIONS
- 1.73 LIST NODE DIRECTORY
- 1.74 LIST ODBC DATA SOURCES
- 1.75 LIST PACKAGES/TABLES
- 1.76 LIST TABLESPACE CONTAINERS
- 1.77 LIST TABLESPACES
- 1.78 LIST UTILITIES
- 1.79 LOAD
- 1.80 LOAD QUERY
- 1.81 MIGRATE DATABASE
- 1.82 PING
- 1.83 PRECOMPILE
- 1.84 PRUNE HISTORY/LOGFILE
- 1.85 PUT ROUTINE
- 1.86 QUERY CLIENT
- 1.87 QUIESCE
- 1.88 QUIESCE TABLESPACES FOR TABLE
- 1.89 QUIT
- 1.90 REBIND
- 1.91 RECOVER DATABASE
- 1.92 REDISTRIBUTE DATABASE PARTITION GROUP
- 1.93 REFRESH LDAP
- 1.94 REGISTER
- 1.95 REGISTER XMLSCHEMA
- 1.96 REGISTER XSROBJECT
- 1.97 REORG INDEXES/TABLE
- 1.98 REORGCHK
- 1.99 RESET ADMIN CONFIGURATION
- 1.100 RESET ALERT CONFIGURATION
- 1.101 RESET DATABASE CONFIGURATION
- 1.102 RESET DATABASE MANAGER CONFIGURATION
- 1.103 RESET MONITOR
- 1.104 RESTART DATABASE
- 1.105 RESTORE DATABASE
- 1.106 REWIND TAPE
- 1.107 ROLLFORWARD DATABASE
- 1.108 RUNCMD
- 1.109 RUNSTATS
- 1.110 SET CLIENT
- 1.111 SET RUNTIME DEGREE
- 1.112 SET SERVEROUTPUT
- 1.113 SET TABLESPACE CONTAINERS
- 1.114 SET TAPE POSITION
- 1.115 SET UTIL_IMPACT_PRIORITY
- 1.116 SET WORKLOAD
- 1.117 SET WRITE
- 1.118 START DATABASE MANAGER
- 1.119 START HADR
- 1.120 STOP DATABASE MANAGER
- 1.121 STOP HADR
- 1.122 TAKEOVER HADR
- 1.123 TERMINATE
- 1.124 UNCATALOG DATABASE
- 1.125 UNCATALOG DCS DATABASE
- 1.126 UNCATALOG LDAP DATABASE
- 1.127 UNCATALOG LDAP NODE
- 1.128 UNCATALOG NODE
- 1.129 UNCATALOG ODBC DATA SOURCE
- 1.130 UNQUIESCE
- 1.131 UPDATE ADMIN CONFIGURATION
- 1.132 UPDATE ALERT CONFIGURATION
- 1.133 UPDATE ALTERNATE SERVER FOR DATABASE
- 1.134 UPDATE ALTERNATE SERVER FOR LDAP
- 1.135 UPDATE CLI CONFIGURATION
- 1.136 UPDATE COMMAND OPTIONS
- 1.137 UPDATE CONTACT
- 1.138 UPDATE CONTACTGROUP
- 1.139 UPDATE DATABASE CONFIGURATION
- 1.140 UPDATE DATABASE MANAGER CONFIGURATION
- 1.141 UPDATE HEALTH NOTIFICATION CONTACT LIST
- 1.142 UPDATE HISTORY FILE
- 1.143 UPDATE LDAP NODE
- 1.144 UPDATE MONITOR SWITCHES
- 1.145 UPDATE XMLSCHEMA
- 1.146 UPGRADE DATABASE
DB2 CLPコマンド
DB2 |
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
© 2006 矢木浩人
