1. 客户端命令: db2
该命令类似于oracle的sqlplus, mysql的mysql命令
可以在db2命令后直接跟查询命令，如 db2 list db directory
也可以先运行db2命令，程序启动后，再运行list db directory
2. 列出所有数据库: list db directory
3. 连接数据库: connect to [dbname] user [username] using [password]
例如 connect to sample，连接成功后显示如下信息
-------------------------------------------------------------
database connection information
database server = db2/linuxx8664 10.5.4
sql authorization id = db2inst2
local database alias = sample
-------------------------------------------------------------
4. 断开数据库连接: connect reset
5. 创建数据库: create database [dbname]
6. 删除数据库: drop database [dbname]
7. 查询数据库下有哪些表
1) 列出所有表: list tables for all
2) 列出所有系统表: list tables for system
3) 列出所有用户表: list tables / list tables for user
4) 列出特定用户表: list tables for schema [user]
8. 显示表结构: describe table tablename
9. 表的创建/插入/修改/查询，标准sql
10. 显示当前数据库管理实例: get instance
11. 启用归档日志
老版本(v8.2): db2 update db cfg for [dbname] using logretain on
新版本(v8.2之后): db2 update db cfg for [dbname] using logarchmeth1 logretain
12. 离线备份: backup database [dbname] to [path]
如: backup database sample to /db2/db2inst2/duanbb/backup
13. 在线备份(要求启用归档日志): backup database [dbname] online to [path]
如: backup database sample to online /db2/db2inst2/duanbb/backup
14. 恢复数据库: restore database [dbname] from [path]
如: restore database sample from /db2/db2inst2/duanbb/backup