List IBM DB2 Commands
Posted on Mar 29, 2009 (last modified Jun 1, 2021)
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 |