List IBM DB2 commands

Did you know that you can get a quick list of db2 commands by typing “db2 ?” on the command line?

Following are the DB2 commands from the screen-shot in a form that you can copy and paste:

ACTIVATE DATABASE GET CONTACTS RECOVER
ADD CONTACT GET/UPDATE DB CFG REDISTRIBUTE DB PARTITION
ADD CONTACTGROUP GET/UPDATE DBM CFG REFRESH LDAP
ADD DATALINKS MANAGER GET DBM MONITOR SWITCHES REGISTER LDAP
ADD DBPARTITIONNUM GET DESCRIPTION FOR HEALTH REGISTER XMLSCHEMA
ADD XMLSCHEMA GET NOTIFICATION LIST REGISTER XSROBJECT
ARCHIVE LOG GET HEALTH SNAPSHOT REORG INDEXES/TABLE
ATTACH GET INSTANCE REORGCHK
AUTOCONFIGURE GET MONITOR SWITCHES RESET ADMIN CFG
BACKUP DATABASE GET RECOMMENDATIONS RESET ALERT CFG
BIND GET ROUTINE RESET DB CFG
CATALOG APPC NODE GET SNAPSHOT RESET DBM CFG
CATALOG APPN NODE HELP RESET MONITOR
CATALOG DATABASE HISTORY RESTART DATABASE
CATALOG DCS DATABASE IMPORT RESTORE DATABASE
CATALOG LDAP DATABASE INITIALIZE TAPE REWIND TAPE
CATALOG LDAP NODE INSPECT ROLLFORWARD DATABASE
CATALOG LOCAL NODE LIST ACTIVE DATABASES RUNCMD
CATALOG NPIPE NODE LIST APPLICATIONS RUNSTATS
CATALOG NETBIOS NODE LIST COMMAND OPTIONS SET CLIENT
CATALOG ODBC DATA SOURCE LIST DATABASE DIRECTORY SET RUNTIME DEGREE
CATALOG TCPIP NODE LIST DB PARTITION GROUPS SET TABLESPACE CONTAINERS
CHANGE DATABASE COMMENT LIST DATALINKS MANAGERS SET TAPE POSITION
CHANGE ISOLATION LEVEL LIST DBPARTITIONNUMS SET UTIL_IMPACT_PRIORITY
COMPLETE XMLSCHEMA LIST DCS APPLICATIONS SET WRITE
CREATE DATABASE LIST DCS DIRECTORY START DATABASE MANAGER
CREATE TOOLS CATALOG LIST DRDA INDOUBT START HADR
DEACTIVATE DATABASE LIST HISTORY STOP DATABASE MANAGER
DECOMPOSE XML DOCUMENT LIST INDOUBT TRANSACTIONS STOP HADR
DEREGISTER LIST NODE DIRECTORY TAKEOVER
DESCRIBE LIST ODBC DATA SOURCES TERMINATE
DETACH LIST PACKAGES/TABLES UNCATALOG DATABASE
DROP CONTACT LIST TABLESPACE CONTAINERS UNCATALOG DCS DATABASE
DROP CONTACTGROUP LIST TABLESPACES UNCATALOG LDAP DATABASE
DROP DATABASE LIST UTILITIES UNCATALOG LDAP NODE
DROP DATALINKS MANAGER LOAD UNCATALOG NODE
DROP DBPARTITIONNUM LOAD QUERY UNCATALOG ODBC DATA
DROP TOOLS CATALOG MIGRATE DATABASE UNQUIESCE DATABASE
ECHO PING UNQUIESCE INSTANCE
EDIT PREP/PRECOMPILE UPDATE ALERT CFG
EXPORT PRUNE HISTORY/LOGFILE UPDATE COMMAND OPTIONS
FORCE APPLICATION PUT ROUTINE UPDATE CONTACT
GET/UPDATE ADMIN CFG QUERY CLIENT UPDATE CONTACTGROUP
GET ALERT CFG QUIESCE DATABASE UPDATE NOTIFICATION LIST
GET AUTHORIZATIONS QUIESCE INSTANCE UPDATE HISTORY
GET/UPDATE CLI CFG QUIESCE TABLESPACES UPDATE LDAP NODE
GET CONNECTION STATE QUIT UPDATE MONITOR SWITCHES
GET CONTACTGROUP REBIND XQUERY
GET CONTACTGROUPS RECONCILE