| ページ一覧 | ブログ | twitter |　 書式 | 書式(表) |

MyMemoWiki

「DB2 CLPコマンド」の版間の差分

提供: MyMemoWiki
ナビゲーションに移動 検索に移動
 
1行目: 1行目:
−
==DB2 CLPコマンド==
+
==[[DB2 CLPコマンド]]==
 
[[DB2]] |  
 
[[DB2]] |  
  
5行目: 5行目:
 
===ACTIVATE DATABASE===
 
===ACTIVATE DATABASE===
 
===ADD CONTACT===
 
===ADD CONTACT===
−
===ADD CONTACTGROUP===
+
===ADD CONTACTG[[R]]OUP===
−
===ADD DBPARTITIONNUM===
+
===ADD DBPA[[R]]TITIONNUM===
−
===ADD XMLSCHEMA DOCUMENT===
+
===ADD [[XML]]SCHEMA DOCUMENT===
−
===ARCHIVE LOG===
+
===A[[R]]CHIVE LOG===
 
===ATTACH===
 
===ATTACH===
−
===AUTOCONFIGURE===
+
===AUTOCONFIGU[[R]]E===
 
===BACKUP DATABASE===
 
===BACKUP DATABASE===
 
===BIND===
 
===BIND===
18行目: 18行目:
 
===CATALOG LDAP NODE===
 
===CATALOG LDAP NODE===
 
===CATALOG LOCAL NODE===
 
===CATALOG LOCAL NODE===
−
===CATALOG NAMED PIPE NODE===
+
===CATALOG NAMED [[PIP]]E NODE===
−
===CATALOG ODBC DATA SOURCE===
+
===CATALOG ODBC DATA SOU[[R]]CE===
−
===CATALOG TCPIP NODE===
+
===CATALOG TC[[PIP]] NODE===
−
===CHANGE DATABASE COMMENT===
+
===CHANGE DATABASE [[COM]]MENT===
 
===CHANGE ISOLATION LEVEL===
 
===CHANGE ISOLATION LEVEL===
−
===COMPLETE XMLSCHEMA===
+
===COMPLETE [[XML]]SCHEMA===
−
===CREATE DATABASE===
+
===C[[R]]EATE DATABASE===
−
===CREATE TOOLS CATALOG===
+
===C[[R]]EATE TOOLS CATALOG===
 
===DEACTIVATE DATABASE===
 
===DEACTIVATE DATABASE===
−
===DECOMPOSE XML DOCUMENT===
+
===DECOMPOSE [[XML]] DOCUMENT===
−
===DECOMPOSE XML DOCUMENTS===
+
===DECOMPOSE [[XML]] DOCUMENTS===
−
===DEREGISTER===
+
===DE[[R]]EGISTE[[R]]===
−
===DESCRIBE===
+
===DESC[[R]]IBE===
 
===DETACH===
 
===DETACH===
−
===DROP CONTACT===
+
===D[[R]]OP CONTACT===
−
===DROP CONTACTGROUP===
+
===D[[R]]OP CONTACTG[[R]]OUP===
−
===DROP DATABASE===
+
===D[[R]]OP DATABASE===
−
===DROP DBPARTITIONNUM VERIFY===
+
===D[[R]]OP DBPA[[R]]TITIONNUM VE[[R]]IFY===
−
===DROP TOOLS CATALOG===
+
===D[[R]]OP TOOLS CATALOG===
 
===ECHO===
 
===ECHO===
 
===EDIT===
 
===EDIT===
 
===[http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0008303.html EXPORT]===
 
===[http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0008303.html EXPORT]===
 
*外部ファイル形式のいずれかにデータをエクスポート
 
*外部ファイル形式のいずれかにデータをエクスポート
−
===FORCE APPLICATION===
+
===FO[[R]]CE APPLICATION===
−
===GET ADMIN CONFIGURATION===
+
===GET ADMIN CONFIGU[[R]]ATION===
−
===GET ALERT CONFIGURATION===
+
===GET ALE[[R]]T CONFIGU[[R]]ATION===
−
===GET CLI CONFIGURATION===
+
===GET CLI CONFIGU[[R]]ATION===
 
===GET CONNECTION STATE===
 
===GET CONNECTION STATE===
−
===GET CONTACTGROUP===
+
===GET CONTACTG[[R]]OUP===
−
===GET CONTACTGROUPS===
+
===GET CONTACTG[[R]]OUPS===
 
===GET CONTACTS===
 
===GET CONTACTS===
−
===GET DATABASE CONFIGURATION===
+
===GET DATABASE CONFIGU[[R]]ATION===
−
===GET DATABASE MANAGER CONFIGURATION===
+
===GET DATABASE MANAGE[[R]] CONFIGU[[R]]ATION===
−
===GET DATABASE MANAGER MONITOR SWITCHES===
+
===GET DATABASE MANAGE[[R]] MONITO[[R]] SWITCHES===
−
===GET DESCRIPTION FOR HEALTH INDICATOR===
+
===GET DESC[[R]]IPTION FO[[R]] HEALTH INDICATO[[R]]===
 
===GET HEALTH NOTIFICATION CONTACT LIST===
 
===GET HEALTH NOTIFICATION CONTACT LIST===
 
===GET HEALTH SNAPSHOT===
 
===GET HEALTH SNAPSHOT===
 
===GET INSTANCE===
 
===GET INSTANCE===
−
===GET MONITOR SWITCHES===
+
===GET MONITO[[R]] SWITCHES===
−
===GET RECOMMENDATIONS FOR HEALTH INDICATOR===
+
===GET RE[[COM]]MENDATIONS FOR HEALTH INDICATOR===
−
===GET ROUTINE===
+
===GET [[R]]OUTINE===
 
===GET SNAPSHOT===
 
===GET SNAPSHOT===
 
===HELP===
 
===HELP===
 
===[http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0010839.html HISTORY]===
 
===[http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0010839.html HISTORY]===
 
*対話モード・セッション内で実行したコマンドの履歴を表示
 
*対話モード・セッション内で実行したコマンドの履歴を表示
−
===IMPORT===
+
===IMPO[[R]]T===
 
===INITIALIZE TAPE===
 
===INITIALIZE TAPE===
 
===INSPECT===
 
===INSPECT===
 
===LIST ACTIVE DATABASES===
 
===LIST ACTIVE DATABASES===
 
===LIST APPLICATIONS===
 
===LIST APPLICATIONS===
−
===LIST COMMAND OPTIONS===
+
===LIST [[COM]]MAND OPTIONS===
−
===LIST DATABASE DIRECTORY===
+
===LIST DATABASE DI[[R]]ECTO[[R]]Y===
−
===LIST DATABASE PARTITION GROUPS===
+
===LIST DATABASE PA[[R]]TITION G[[R]]OUPS===
−
===LIST DBPARTITIONNUMS===
+
===LIST DBPA[[R]]TITIONNUMS===
 
===LIST DCS APPLICATIONS===
 
===LIST DCS APPLICATIONS===
−
===LIST DCS DIRECTORY===
+
===LIST DCS DI[[R]]ECTO[[R]]Y===
−
===LIST DRDA INDOUBT TRANSACTIONS===
+
===LIST D[[R]]DA INDOUBT T[[R]]ANSACTIONS===
−
===LIST HISTORY===
+
===LIST HISTO[[R]]Y===
−
===LIST INDOUBT TRANSACTIONS===
+
===LIST INDOUBT T[[R]]ANSACTIONS===
−
===LIST NODE DIRECTORY===
+
===LIST NODE DI[[R]]ECTO[[R]]Y===
−
===LIST ODBC DATA SOURCES===
+
===LIST ODBC DATA SOU[[R]]CES===
 
===LIST PACKAGES/TABLES===
 
===LIST PACKAGES/TABLES===
−
===LIST TABLESPACE CONTAINERS===
+
===LIST TABLESPACE CONTAINE[[R]]S===
 
===LIST TABLESPACES===
 
===LIST TABLESPACES===
−
===LIST UTILITIES===
+
===LIST UTILIT[[IE]]S===
 
===LOAD===
 
===LOAD===
−
===LOAD QUERY===
+
===LOAD QUE[[R]]Y===
−
===MIGRATE DATABASE===
+
===MIG[[R]]ATE DATABASE===
 
===PING===
 
===PING===
−
===PRECOMPILE===
+
===PRE[[COM]]PILE===
−
===PRUNE HISTORY/LOGFILE===
+
===P[[R]]UNE HISTO[[R]]Y/LOGFILE===
−
===PUT ROUTINE===
+
===PUT [[R]]OUTINE===
−
===QUERY CLIENT===
+
===QUERY CL[[IE]]NT===
−
===QUIESCE===
+
===QU[[IE]]SCE===
−
===QUIESCE TABLESPACES FOR TABLE===
+
===QU[[IE]]SCE TABLESPACES FOR TABLE===
 
===QUIT===
 
===QUIT===
−
===REBIND===
+
===[[R]]EBIND===
−
===RECOVER DATABASE===
+
===[[R]]ECOVE[[R]] DATABASE===
−
===REDISTRIBUTE DATABASE PARTITION GROUP===
+
===[[R]]EDIST[[R]]IBUTE DATABASE PA[[R]]TITION G[[R]]OUP===
−
===REFRESH LDAP===
+
===[[R]]EF[[R]]ESH LDAP===
−
===REGISTER===
+
===[[R]]EGISTE[[R]]===
−
===REGISTER XMLSCHEMA===
+
===REGISTER [[XML]]SCHEMA===
−
===REGISTER XSROBJECT===
+
===[[R]]EGISTE[[R]] XS[[R]]OBJECT===
−
===REORG INDEXES/TABLE===
+
===[[R]]EO[[R]]G INDEXES/TABLE===
−
===REORGCHK===
+
===[[R]]EO[[R]]GCHK===
−
===RESET ADMIN CONFIGURATION===
+
===[[R]]ESET ADMIN CONFIGU[[R]]ATION===
−
===RESET ALERT CONFIGURATION===
+
===[[R]]ESET ALE[[R]]T CONFIGU[[R]]ATION===
−
===RESET DATABASE CONFIGURATION===
+
===[[R]]ESET DATABASE CONFIGU[[R]]ATION===
−
===RESET DATABASE MANAGER CONFIGURATION===
+
===[[R]]ESET DATABASE MANAGE[[R]] CONFIGU[[R]]ATION===
−
===RESET MONITOR===
+
===[[R]]ESET MONITO[[R]]===
−
===RESTART DATABASE===
+
===[[R]]ESTA[[R]]T DATABASE===
−
===RESTORE DATABASE===
+
===[[R]]ESTO[[R]]E DATABASE===
−
===REWIND TAPE===
+
===[[R]]EWIND TAPE===
−
===ROLLFORWARD DATABASE===
+
===[[R]]OLLFO[[R]]WA[[R]]D DATABASE===
 
===[http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0010840.html RUNCMD]===
 
===[http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0010840.html RUNCMD]===
 
* 対話モード・コマンド履歴から指定のコマンドを実行
 
* 対話モード・コマンド履歴から指定のコマンドを実行
−
===RUNSTATS===
+
===[[R]]UNSTATS===
−
===SET CLIENT===
+
===SET CL[[IE]]NT===
−
===SET RUNTIME DEGREE===
+
===SET [[R]]UNTIME DEG[[R]]EE===
−
===SET SERVEROUTPUT===
+
===SET SE[[R]]VE[[R]]OUTPUT===
−
===SET TABLESPACE CONTAINERS===
+
===SET TABLESPACE CONTAINE[[R]]S===
 
===SET TAPE POSITION===
 
===SET TAPE POSITION===
−
===SET UTIL_IMPACT_PRIORITY===
+
===SET UTIL_IMPACT_P[[R]]IO[[R]]ITY===
−
===SET WORKLOAD===
+
===SET WO[[R]]KLOAD===
−
===SET WRITE===
+
===SET W[[R]]ITE===
−
===START DATABASE MANAGER===
+
===STA[[R]]T DATABASE MANAGE[[R]]===
−
===START HADR===
+
===STA[[R]]T HAD[[R]]===
−
===STOP DATABASE MANAGER===
+
===STOP DATABASE MANAGE[[R]]===
−
===STOP HADR===
+
===STOP HAD[[R]]===
−
===TAKEOVER HADR===
+
===TAKEOVE[[R]] HAD[[R]]===
−
===TERMINATE===
+
===TE[[R]]MINATE===
 
===UNCATALOG DATABASE===
 
===UNCATALOG DATABASE===
 
===UNCATALOG DCS DATABASE===
 
===UNCATALOG DCS DATABASE===
134行目: 134行目:
 
===UNCATALOG LDAP NODE===
 
===UNCATALOG LDAP NODE===
 
===UNCATALOG NODE===
 
===UNCATALOG NODE===
−
===UNCATALOG ODBC DATA SOURCE===
+
===UNCATALOG ODBC DATA SOU[[R]]CE===
−
===UNQUIESCE===
+
===UNQU[[IE]]SCE===
−
===UPDATE ADMIN CONFIGURATION===
+
===UPDATE ADMIN CONFIGU[[R]]ATION===
−
===UPDATE ALERT CONFIGURATION===
+
===UPDATE ALE[[R]]T CONFIGU[[R]]ATION===
−
===UPDATE ALTERNATE SERVER FOR DATABASE===
+
===UPDATE ALTE[[R]]NATE SE[[R]]VE[[R]] FO[[R]] DATABASE===
−
===UPDATE ALTERNATE SERVER FOR LDAP===
+
===UPDATE ALTE[[R]]NATE SE[[R]]VE[[R]] FO[[R]] LDAP===
−
===UPDATE CLI CONFIGURATION===
+
===UPDATE CLI CONFIGU[[R]]ATION===
−
===UPDATE COMMAND OPTIONS===
+
===UPDATE [[COM]]MAND OPTIONS===
 
===UPDATE CONTACT===
 
===UPDATE CONTACT===
−
===UPDATE CONTACTGROUP===
+
===UPDATE CONTACTG[[R]]OUP===
−
===UPDATE DATABASE CONFIGURATION===
+
===UPDATE DATABASE CONFIGU[[R]]ATION===
−
===UPDATE DATABASE MANAGER CONFIGURATION===
+
===UPDATE DATABASE MANAGE[[R]] CONFIGU[[R]]ATION===
 
===UPDATE HEALTH NOTIFICATION CONTACT LIST===
 
===UPDATE HEALTH NOTIFICATION CONTACT LIST===
−
===UPDATE HISTORY FILE===
+
===UPDATE HISTO[[R]]Y FILE===
 
===UPDATE LDAP NODE===
 
===UPDATE LDAP NODE===
−
===UPDATE MONITOR SWITCHES===
+
===UPDATE MONITO[[R]] SWITCHES===
−
===UPDATE XMLSCHEMA===
+
===UPDATE [[XML]]SCHEMA===
−
===UPGRADE DATABASE===
+
===UPG[[R]]ADE DATABASE===

2020年2月16日 (日) 04:24時点における最新版

目次

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

「https://www.typea.info/tips_/index.php?title=DB2_CLPコマンド&oldid=5903」から取得

© 2006 矢木浩人