DB2 数据库常用命令

一.数据库管理

1.1启停数据库：

启动db2服务：db2start
激活数据库实例：db2 activate database <db_name>
查看激活状态的数据库：db2 list active databases

关闭数据库：
失效数据库实例：db2 deactivate database <db_name>
关闭数据库服务：db2stop

1.2 创建数据库：

语法：db2 create database <数据库名> [其他选项]
示例：
db2 create database sampledb
db2 create database mydb codeset utf-8 territory cn

此命令用于创建一个名为sampleDB的数据库，使用默认配置。
若要指定数据库使用的代码页、国家 / 地区代码等，可以添加相应选项，如创建一个使用 UTF-8 编码且地区为中国的数据库

1.3.连接数据库：

语法：connect to <数据库名> [user <用户名> using <密码>]
示例：connect to sampledb user admin using password123

使用admin用户和密码password123连接到名为sampleDB的数据库。
若当前用户已具有数据库访问权限且不需要指定用户名和密码，可以简化为

connect to sampledb

1.4.查看数据库：

查看数据库：db2 list db directory

[db2inst1@rocky8 data]$ db2 list db directory

 System Database Directory

 Number of entries in the directory = 3

Database 1 entry:

 Database alias                       = RPTDB
 Database name                        = RPTDB
 Local database directory             = /data/rptdb
 Database release level               = 10.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

查看数据库应用：db2 list applications

[db2inst1@rocky8 data]$ db2 list active databases

                           Active Databases

Database name                              = RPTDB
Applications connected currently           = 4
Database path                              = /data/rptdb/db2inst1/NODE0000/SQL00001/MEMBER0000/

[db2inst1@rocky8 data]$ 
[db2inst1@rocky8 data]$ 
[db2inst1@rocky8 data]$ db2 list applications

Auth Id  Application    Appl.      Application Id                                                 DB       # of
         Name           Handle                                                                    Name    Agents
-------- -------------- ---------- -------------------------------------------------------------- -------- -----
DB2INST1 DBeaver        29         ::ffff:192.168.0.10.61515.250125075818                         RPTDB    1    
DB2INST1 DBeaver        28         ::ffff:192.168.0.10.61514.250125075817                         RPTDB    1    
DB2INST1 dbvis          8          ::ffff:192.168.0.10.61469.250125075623                         RPTDB    1    
DB2INST1 db2bp          73         *LOCAL.db2inst1.250125083528                                   RPTDB    1    

[db2inst1@rocky8 data]$ 

查看数据库应用和进程号：db2 list applications show detail
查看数据库表空间：db2pd -db <db_name> -tablespace

[db2inst1@rocky8 data]$ db2 connect to sample

   Database Connection Information

 Database server        = DB2/LINUXX8664 10.5.8
 SQL authorization ID   = DB2INST1
 Local database alias   = SAMPLE

[db2inst1@rocky8 data]$ 
[db2inst1@rocky8 data]$ db2pd -db sample -tablespace

Database Member 0 -- Database SAMPLE -- Active -- Up 0 days 00:00:06 -- Date 2025-01-25-16.41.38.328030

Tablespace Configuration:
Address            Id    Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe  LastConsecPg RSE  Name
0x00007F2CE3920D40 0     DMS  Regular 8192   4        Yes  4        1     1         Def 1        0          3            Yes  SYSCATSPACE
0x00007F2CE392DEE0 1     SMS  SysTmp  8192   32       Yes  32       1     1         On  1        0          31           No   TEMPSPACE1
0x00007F2CE393B080 2     DMS  Large   8192   32       Yes  32       1     1         Def 1        0          31           Yes  USERSPACE1
0x00007F2CE3948220 3     DMS  Large   8192   32       Yes  32       1     1         Def 1        0          31           Yes  IBMDB2SAMPLEREL
0x00007F2CE39553C0 4     DMS  Large   8192   32       Yes  32       1     1         Def 1        0          31           Yes  IBMDB2SAMPLEXML
0x00007F2CE39710C0 5     DMS  Large   8192   4        Yes  4        1     1         Def 1        0          3            Yes  SYSTOOLSPACE

Tablespace Statistics:
Address            Id    TotalPgs   UsablePgs  UsedPgs    PndFreePgs FreePgs    HWM        Max HWM    State      MinRecTime NQuiescers PathsDropped TrackmodState    
0x00007F2CE3920D40 0     16384      16380      16100      0          280        16100      16100      0x00000000 0          0          No           n/a              
0x00007F2CE392DEE0 1     1          1          1          0          0          -          -          0x00000000 0          0          No           n/a              
0x00007F2CE393B080 2     4096       4064       1824       0          2240       1824       1824       0x00000000 0          0          No           n/a              
0x00007F2CE3948220 3     4096       4064       608        0          3456       608        608        0x00000000 0          0          No           n/a              
0x00007F2CE39553C0 4     4096       4064       1440       0          2624       1440       1440       0x00000000 0          0          No           n/a              
0x00007F2CE39710C0 5     4096       4092       108        0          3984       108        108        0x00000000 0          0          No           n/a              

Tablespace Autoresize Statistics:
Address            Id    AS  AR  InitSize             IncSize              IIP MaxSize              LastResize                 LRF
0x00007F2CE3920D40 0     Yes Yes 33554432             -1                   No  None                 None                       No  
0x00007F2CE392DEE0 1     Yes No  0                    0                    No  0                    None                       No  
0x00007F2CE393B080 2     Yes Yes 33554432             -1                   No  None                 None                       No  
0x00007F2CE3948220 3     Yes Yes 33554432             -1                   No  None                 None                       No  
0x00007F2CE39553C0 4     Yes Yes 33554432             -1                   No  None                 None                       No  
0x00007F2CE39710C0 5     Yes Yes 33554432             -1                   No  None                 None                       No  

Tablespace Storage Statistics:
Address            Id    DataTag  Rebalance SGID  SourceSGID
0x00007F2CE3920D40 0     0        No        0     -                    
0x00007F2CE392DEE0 1     0        No        0     -                    
0x00007F2CE393B080 2     -1       No        0     -                    
0x00007F2CE3948220 3     -1       No        0     -                    
0x00007F2CE39553C0 4     -1       No        0     -                    
0x00007F2CE39710C0 5     -1       No        0     -                    

Containers:
Address            TspId ContainNum Type    TotalPgs   UseablePgs PathID     StripeSet  Container 
0x00007F2CE391A120 0     0          File    16384      16380      0          0          /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000000/C0000000.CAT
0x00007F2CE391A780 1     0          Path    1          1          0          0          /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000001/C0000000.TMP
0x00007F2CE38F8720 2     0          File    4096       4064       0          0          /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000002/C0000000.LRG
0x00007F2CE38F8B80 3     0          File    4096       4064       0          0          /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000003/C0000000.LRG
0x00007F2CE38F7400 4     0          File    4096       4064       0          0          /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000004/C0000000.LRG
0x00007F2CE38F7B80 5     0          File    4096       4092       0          0          /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000005/C0000000.LRG
[db2inst1@rocky8 data]$ 

查看数据库配置：db2 get db cfg for <db_name>

[db2inst1@rocky8 data]$ db2 get db cfg for sample

       Database Configuration for Database sample

 Database configuration release level                    = 0x1000
 Database release level                                  = 0x1000

 Database territory                                      = US
 Database code page                                      = 1208
 Database code set                                       = UTF-8
 Database country/region code                            = 1
 Database collating sequence                             = IDENTITY
 Alternate collating sequence              (ALT_COLLATE) = 
 Number compatibility                                    = OFF
 Varchar2 compatibility                                  = OFF
 Date compatibility                                      = OFF
 Database page size                                      = 8192

 Statement concentrator                      (STMT_CONC) = OFF

 Discovery support for this database       (DISCOVER_DB) = ENABLE

 Restrict access                                         = NO
 Default query optimization class         (DFT_QUERYOPT) = 5
 Degree of parallelism                      (DFT_DEGREE) = 1
 Continue upon arithmetic exceptions   (DFT_SQLMATHWARN) = NO
 Default refresh age                   (DFT_REFRESH_AGE) = 0
 Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
 Number of frequent values retained     (NUM_FREQVALUES) = 10
 Number of quantiles retained            (NUM_QUANTILES) = 20

 Decimal floating point rounding mode  (DECFLT_ROUNDING) = ROUND_HALF_EVEN

 Backup pending                                          = NO

 All committed transactions have been written to disk    = NO
 Rollforward pending                                     = NO
 Restore pending                                         = NO

 Multi-page file allocation enabled                      = YES

 Log retain for recovery status                          = NO
 User exit for logging status                            = NO

 Self tuning memory                    (SELF_TUNING_MEM) = OFF
 Size of database shared memory (4KB)  (DATABASE_MEMORY) = AUTOMATIC(56176)
 Database memory threshold               (DB_MEM_THRESH) = 100
 Max storage for lock list (4KB)              (LOCKLIST) = 4096
 Percent. of lock lists per application       (MAXLOCKS) = 10
 Package cache size (4KB)                   (PCKCACHESZ) = (MAXAPPLS*8)
 Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 5000
 Sort list heap (4KB)                         (SORTHEAP) = 256

 Database heap (4KB)                            (DBHEAP) = AUTOMATIC(1200)
 Catalog cache size (4KB)              (CATALOGCACHE_SZ) = (MAXAPPLS*5)
 Log buffer size (4KB)                        (LOGBUFSZ) = 256
 Utilities heap size (4KB)                (UTIL_HEAP_SZ) = AUTOMATIC(5000)
 SQL statement heap (4KB)                     (STMTHEAP) = AUTOMATIC(8192)
 Default application heap (4KB)             (APPLHEAPSZ) = AUTOMATIC(256)
 Application Memory Size (4KB)             (APPL_MEMORY) = AUTOMATIC(40000)
 Statistics heap size (4KB)               (STAT_HEAP_SZ) = AUTOMATIC(4384)

 Interval for checking deadlock (ms)         (DLCHKTIME) = 10000
 Lock timeout (sec)                        (LOCKTIMEOUT) = -1

 Changed pages threshold                (CHNGPGS_THRESH) = 60
 Number of asynchronous page cleaners   (NUM_IOCLEANERS) = AUTOMATIC(4)
 Number of I/O servers                   (NUM_IOSERVERS) = AUTOMATIC(12)
 Sequential detect flag                      (SEQDETECT) = YES
 Default prefetch size (pages)         (DFT_PREFETCH_SZ) = AUTOMATIC

 Track modified pages                         (TRACKMOD) = NO

 Default number of containers                            = 1
 Default tablespace extentsize (pages)   (DFT_EXTENT_SZ) = 32

 Max number of active applications            (MAXAPPLS) = AUTOMATIC(40)
 Average number of active applications       (AVG_APPLS) = AUTOMATIC(1)
 Max DB files open per application            (MAXFILOP) = 61440

 Log file size (4KB)                         (LOGFILSIZ) = 1000
 Number of primary log files                (LOGPRIMARY) = 3
 Number of secondary log files               (LOGSECOND) = 10
 Changed path to log files                  (NEWLOGPATH) = 
 Path to log files                                       = /home/db2inst1/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/
 Overflow log path                     (OVERFLOWLOGPATH) = 
 Mirror log path                         (MIRRORLOGPATH) = 
 First active log file                                   = 
 Block log on disk full                (BLK_LOG_DSK_FUL) = NO
 Block non logged operations            (BLOCKNONLOGGED) = NO
 Percent max primary log space by transaction  (MAX_LOG) = 0
 Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0

 Percent log file reclaimed before soft chckpt (SOFTMAX) = 0
 Target for oldest page in LBP       (PAGE_AGE_TRGT_MCR) = 240

 HADR database role                                      = STANDARD
 HADR local host name                  (HADR_LOCAL_HOST) = 
 HADR local service name                (HADR_LOCAL_SVC) = 
 HADR remote host name                (HADR_REMOTE_HOST) = 
 HADR remote service name              (HADR_REMOTE_SVC) = 
 HADR instance name of remote server  (HADR_REMOTE_INST) = 
 HADR timeout value                       (HADR_TIMEOUT) = 120
 HADR target list                     (HADR_TARGET_LIST) = 
 HADR log write synchronization mode     (HADR_SYNCMODE) = NEARSYNC
 HADR spool log data limit (4KB)      (HADR_SPOOL_LIMIT) = AUTOMATIC(0)
 HADR log replay delay (seconds)     (HADR_REPLAY_DELAY) = 0
 HADR peer window duration (seconds)  (HADR_PEER_WINDOW) = 0

 First log archive method                 (LOGARCHMETH1) = OFF
 Archive compression for logarchmeth1    (LOGARCHCOMPR1) = OFF
 Options for logarchmeth1                  (LOGARCHOPT1) = 
 Second log archive method                (LOGARCHMETH2) = OFF
 Archive compression for logarchmeth2    (LOGARCHCOMPR2) = OFF
 Options for logarchmeth2                  (LOGARCHOPT2) = 
 Failover log archive path                (FAILARCHPATH) = 
 Number of log archive retries on error   (NUMARCHRETRY) = 5
 Log archive retry Delay (secs)         (ARCHRETRYDELAY) = 20
 Vendor options                              (VENDOROPT) = 

 Auto restart enabled                      (AUTORESTART) = ON
 Index re-creation time and redo index build  (INDEXREC) = SYSTEM (RESTART)
 Log pages during index build            (LOGINDEXBUILD) = OFF
 Default number of loadrec sessions    (DFT_LOADREC_SES) = 1
 Number of database backups to retain   (NUM_DB_BACKUPS) = 12
 Recovery history retention (days)     (REC_HIS_RETENTN) = 366
 Auto deletion of recovery objects    (AUTO_DEL_REC_OBJ) = OFF

 TSM management class                    (TSM_MGMTCLASS) = 
 TSM node name                            (TSM_NODENAME) = 
 TSM owner                                   (TSM_OWNER) = 
 TSM password                             (TSM_PASSWORD) = 

 Automatic maintenance                      (AUTO_MAINT) = ON
   Automatic database backup            (AUTO_DB_BACKUP) = OFF
   Automatic table maintenance          (AUTO_TBL_MAINT) = ON
     Automatic runstats                  (AUTO_RUNSTATS) = ON
       Real-time statistics            (AUTO_STMT_STATS) = ON
       Statistical views              (AUTO_STATS_VIEWS) = OFF
       Automatic sampling                (AUTO_SAMPLING) = OFF
     Automatic reorganization               (AUTO_REORG) = OFF

 Auto-Revalidation                          (AUTO_REVAL) = DEFERRED

 Currently Committed                        (CUR_COMMIT) = ON
 CHAR output with DECIMAL input        (DEC_TO_CHAR_FMT) = NEW
 Enable XML Character operations        (ENABLE_XMLCHAR) = YES
 WLM Collection Interval (minutes)     (WLM_COLLECT_INT) = 0
 Monitor Collect Settings
 Request metrics                       (MON_REQ_METRICS) = BASE
 Activity metrics                      (MON_ACT_METRICS) = BASE
 Object metrics                        (MON_OBJ_METRICS) = EXTENDED
 Routine data                             (MON_RTN_DATA) = NONE
   Routine executable list            (MON_RTN_EXECLIST) = OFF
 Unit of work events                      (MON_UOW_DATA) = NONE
   UOW events with package list        (MON_UOW_PKGLIST) = OFF
   UOW events with executable list    (MON_UOW_EXECLIST) = OFF
 Lock timeout events                   (MON_LOCKTIMEOUT) = NONE
 Deadlock events                          (MON_DEADLOCK) = WITHOUT_HIST
 Lock wait events                         (MON_LOCKWAIT) = NONE
 Lock wait event threshold               (MON_LW_THRESH) = 5000000
 Number of package list entries         (MON_PKGLIST_SZ) = 32
 Lock event notification level         (MON_LCK_MSG_LVL) = 1

 SMTP Server                               (SMTP_SERVER) = 
 SQL conditional compilation flags         (SQL_CCFLAGS) = 
 Section actuals setting               (SECTION_ACTUALS) = NONE
 Connect procedure                        (CONNECT_PROC) = 
 Adjust temporal SYSTEM_TIME period (SYSTIME_PERIOD_ADJ) = NO
 Log DDL Statements                      (LOG_DDL_STMTS) = NO
 Log Application Information             (LOG_APPL_INFO) = NO
 Default data capture on new Schemas   (DFT_SCHEMAS_DCC) = NO
 Default table organization              (DFT_TABLE_ORG) = ROW
 Default string units                     (STRING_UNITS) = SYSTEM
 National character string mapping       (NCHAR_MAPPING) = GRAPHIC_CU16
 Database is in write suspend state                      = NO
 Extended row size support             (EXTENDED_ROW_SZ) = ENABLE
 Encryption Library for Backup                 (ENCRLIB) = 
 Encryption Options for Backup                (ENCROPTS) = 
 Encrypted database                                      = NO
 Procedural language stack trace        (PL_STACK_TRACE) = NONE

[db2inst1@rocky8 data]$ 

1.5.断开数据库连接：

db2 connect reset
db2 terminate

1.6.删除数据库：

语法：db2 drop database <数据库名>
示例：db2 drop database olddb
说明：删除名为oldDB的数据库。
需注意，执行此操作将永久删除数据库及其所有数据，务必谨慎使用。
（如果不能删除，尝试断开激活的连接或者重启db2）

二.表空间管理

2.1创建表空间：

系统管理空间（SMS）：
语法： CREATE TABLESPACE <表空间名> MANAGED BY SYSTEM USING (‘<目录路径>’)
示例： CREATE TABLESPACE my_sms_tbsp MANAGED BY SYSTEM USING (‘/db2data/sms_tablespace’)
说明：创建一个名为my_sms_tbsp的系统管理表空间，数据文件存储在/db2data/sms_tablespace目录下。

数据库管理空间（DMS）：
语法：
CREATE TABLESPACE <表空间名> MANAGED BY DATABASE USING (FILE ‘<文件路径>’ <文件大小>[, FILE ‘<文件路径>’ <文件大小>…])
示例：
CREATE TABLESPACE my_dms_tbsp MANAGED BY DATABASE USING (FILE
‘/db2data/dms_tablespace/datafile1.dat’ 100M, FILE
‘/db2data/dms_tablespace/datafile2.dat’ 200M)

说明：
创建一个名为my_dms_tbsp的数据库管理表空间，包含两个数据文件，分别为datafile1.dat（大小 100MB）和datafile2.dat（大小 200MB）。

2.2修改表空间：

增加数据文件（DMS 表空间）：
语法：ALTER TABLESPACE <表空间名> ADD (FILE ‘<文件路径>’ <文件大小>)
示例：ALTER TABLESPACE my_dms_tbsp ADD (FILE ‘/db2data/dms_tablespace/datafile3.dat’ 150M)
为my_dms_tbsp表空间添加一个大小为 150MB 的数据文件datafile3.dat。

2.3修改表空间状态：

语法：ALTER TABLESPACE <表空间名> <状态选项>
示例：ALTER TABLESPACE my_tbsp OFFLINE，将my_tbsp表空间设置为离线状态。可用于维护操作，如备份、恢复或修复表空间时。

2.4删除表空间：

语法：DROP TABLESPACE <表空间名>
示例：DROP TABLESPACE unused_tbsp
删除名为unused_tbsp的表空间。删除表空间时，需要确保表空间中没有活动的表或其他依赖对象。

三.备份与恢复

3.1备份数据库：

语法：BACKUP DATABASE <数据库名> [TO <备份路径> | ONLINE]
示例：
完整离线备份：BACKUP DATABASE sampleDB TO /backup_dir，
将sampleDB数据库完整备份到/backup_dir目录下。此备份操作会在数据库离线状态下进行，确保数据一致性。
在线备份：BACKUP DATABASE sampleDB ONLINE TO /backup_dir，
在数据库处于在线运行状态下进行备份，适用于不能长时间停机的生产环境。但在线备份需要数据库处于归档日志模式，以保证备份的完整性和一致性。

3.2恢复数据库：

语法：RESTORE DATABASE <数据库名> FROM <备份路径> [OVERWRITE | REPLACE HISTORY FILE]
示例：RESTORE DATABASE sampleDB FROM /backup_dir OVERWRITE
从/backup_dir目录下的备份文件恢复sampleDB数据库，OVERWRITE选项表示覆盖现有的数据库及其相关配置。REPLACE HISTORY FILE选项用于在恢复时替换数据库历史文件，这在某些情况下（如历史文件损坏）可能会用到。

四.常用命令

列出系统表：db2 list tables for system
列出所有用户表：db2 list tables
列出所有表：db2 list tables for all
列出特定用户表：db2 list tables for schema [user]

复制一张表：db2 create table t1 like t2
显示表结构：db2 describe table tablename
查询表：db2 “select * from table tablename where …”
执行SQL脚本：db2 -tvf scripts.sql

查看错误代码信息：
db2 ? 10054

停止激活的连接：
db2 force application all;\db2 force application all;\db2 force application all;\db2stop

查看死锁：
db2 get snapshot for locks on <db_name>
db2 “select agent_id,tabname,lock_mode from table(snap_get_lock(‘<db_name>’)) as aa”

杀掉进程：
db2 force application(NUM)

监控DB2消耗多的SQL语句：
eg:（DB_NAME=SUNDB）
db2top -d SUNDB -----查看消耗资源 按照提示按 l，出现Application Handle，找到资源消耗大的Application Handle（stat）
记下app handle。
db2pd -d SUNDB -dyn -application > /tmp/db2pd1.txt ----到处会话语句，准备进行调优

设置连接方式（重启才会生效）：
db2set DB2COMM=tcpip
db2set DB2COMM=

五.帮助命令

db2 => ?
 ACTIVATE DATABASE        GET CONTACTGROUPS          RECONCILE
 ADD CONTACT              GET CONTACTS               RECOVER
 ADD CONTACTGROUP         GET/UPDATE DB CFG          REDISTRIBUTE DB PARTITION
 ADD DATALINKS MANAGER    GET/UPDATE DBM CFG         REFRESH LDAP
 ADD DBPARTITIONNUM       GET DBM MONITOR SWITCHES   REGISTER LDAP
 ADD XMLSCHEMA            GET DESCRIPTION FOR HEALTH REGISTER XMLSCHEMA
 ARCHIVE LOG              GET NOTIFICATION LIST      REGISTER XSROBJECT
 ATTACH                   GET HEALTH SNAPSHOT        REORG INDEXES/TABLE
 AUTOCONFIGURE            GET INSTANCE               REORGCHK
 BACKUP DATABASE          GET MONITOR SWITCHES       RESET ADMIN CFG
 BIND                     GET RECOMMENDATIONS        RESET ALERT CFG
 CATALOG APPC NODE        GET ROUTINE                RESET DB CFG
 CATALOG APPN NODE        GET SNAPSHOT               RESET DBM CFG
 CATALOG DATABASE         HELP                       RESET MONITOR
 CATALOG DCS DATABASE     HISTORY                    RESTART DATABASE
 CATALOG LDAP DATABASE    IMPORT                     RESTORE DATABASE
 CATALOG LDAP NODE        INITIALIZE TAPE            REWIND TAPE
 CATALOG LOCAL NODE       INSPECT                    ROLLFORWARD DATABASE
 CATALOG NPIPE NODE       LIST ACTIVE DATABASES      RUNCMD
 CATALOG NETBIOS NODE     LIST APPLICATIONS          RUNSTATS
 CATALOG ODBC DATA SOURCE LIST COMMAND OPTIONS       SET CLIENT
 CATALOG TCPIP NODE       LIST DATABASE DIRECTORY    SET RUNTIME DEGREE
 CHANGE DATABASE COMMENT  LIST DB PARTITION GROUPS   SET TABLESPACE CONTAINERS
 CHANGE ISOLATION LEVEL   LIST DATALINKS MANAGERS    SET TAPE POSITION
 COMPLETE XMLSCHEMA       LIST DBPARTITIONNUMS       SET UTIL_IMPACT_PRIORITY
 CREATE DATABASE          LIST DCS APPLICATIONS      SET WRITE
 CREATE TOOLS CATALOG     LIST DCS DIRECTORY         START DATABASE MANAGER
 DEACTIVATE DATABASE      LIST DRDA INDOUBT          START HADR
 DECOMPOSE XML DOCUMENT   LIST HISTORY               STOP DATABASE MANAGER
 DECOMPOSE XML DOCUMENTS  LIST INDOUBT TRANSACTIONS  STOP HADR
 DEREGISTER               LIST NODE DIRECTORY        TAKEOVER HADR
 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

Note:  Some commands are operating system specific and may not be available.

For further help:
                  ? db2-command   - help for specified command
                  ? OPTIONS       - help for all command options
                  ? HELP          - help for reading help screens
The preceding three options can be run as db2 <option> from an OS prompt.

                  !db2ic          - DB2 Information Center (Windows only)
This command can also be run as db2ic from an OS prompt.