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

MyMemoWiki

DB2 CLPコマンド

提供: MyMemoWiki
2020年2月16日 (日) 04:24時点におけるPiroto (トーク | 投稿記録)による版
(差分) ← 古い版 | 最新版 (差分) | 新しい版 → (差分)
ナビゲーションに移動 検索に移動

目次

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