Command Reference

DB2 CLP Commands

The following table lists the CLP commands grouped by functional category:

Table 4. DB2 CLP Commands

CLP Session Control

LIST COMMAND OPTIONS

UPDATE COMMAND OPTIONS

CHANGE ISOLATION LEVEL

SET RUNTIME DEGREE

TERMINATE

QUIT

Database Manager Control

START DATABASE MANAGER

STOP DATABASE MANAGER

GET DATABASE MANAGER CONFIGURATION

RESET DATABASE MANAGER CONFIGURATION

UPDATE DATABASE MANAGER CONFIGURATION

GET ADMIN CONFIGURATION

RESET ADMIN CONFIGURATION

UPDATE ADMIN CONFIGURATION

Database Control

RESTART DATABASE

CREATE DATABASE

DROP DATABASE

MIGRATE DATABASE

LIST INDOUBT TRANSACTIONS

ACTIVATE DATABASE

DEACTIVATE DATABASE

LIST DRDA INDOUBT TRANSACTIONS

Database Directory Management

CATALOG DATABASE

UNCATALOG DATABASE

CATALOG DCS DATABASE

UNCATALOG DCS DATABASE

CHANGE DATABASE COMMENT

LIST DATABASE DIRECTORY

LIST DCS DIRECTORY

CATALOG GLOBAL DATABASE

ODBC Management

CATALOG ODBC DATA SOURCE

LIST ODBC DATA SOURCES

UNCATALOG ODBC DATA SOURCE

GET CLI CONFIGURATION

UPDATE CLI CONFIGURATION

Client/Server Directory Management

CATALOG LOCAL NODE

CATALOG NAMED PIPE NODE

CATALOG APPC NODE

CATALOG APPCLU NODE

CATALOG APPN NODE

CATALOG IPX/SPX NODE

CATALOG NETBIOS NODE

CATALOG TCP/IP NODE

UNCATALOG NODE

LIST NODE DIRECTORY

Network Support

REGISTER

DEREGISTER

Database Configuration

GET DATABASE CONFIGURATION

RESET DATABASE CONFIGURATION

UPDATE DATABASE CONFIGURATION

Recovery

BACKUP DATABASE

RECONCILE

RESTORE DATABASE

ROLLFORWARD DATABASE

LIST HISTORY

PRUNE HISTORY

UPDATE RECOVERY HISTORY FILE

Operational Utilities

FORCE APPLICATION

LIST PACKAGES/TABLES

REORGCHK

REORGANIZE TABLE

RUNSTATS

Database Monitoring

GET MONITOR SWITCHES

UPDATE MONITOR SWITCHES

GET DATABASE MANAGER MONITOR SWITCHES

GET SNAPSHOT

RESET MONITOR

LIST ACTIVE DATABASES

LIST APPLICATIONS

LIST DCS APPLICATIONS

Data Utilities

EXPORT

IMPORT

LOAD

LOAD QUERY

Application Preparation

PRECOMPILE PROGRAM

BIND

REBIND

Remote Server Utilities

ATTACH

DETACH

Table Space Management

LIST TABLESPACE CONTAINERS

SET TABLESPACE CONTAINERS

LIST TABLESPACES

QUIESCE TABLESPACES FOR TABLE

Node Management

ADD NODE

DROP NODE VERIFY

LIST NODES

Nodegroup Management

LIST NODEGROUPS

REDISTRIBUTE NODEGROUP

Additional Commands

DESCRIBE

ECHO

GET AUTHORIZATIONS

GET CONNECTION STATE

GET INSTANCE

HELP

INVOKE STORED PROCEDURE

QUERY CLIENT

SET CLIENT

INITIALIZE TAPE

REWIND TAPE

SET TAPE POSITION

[ DB2 List of Books | Search the DB2 Books ]