DB2 命令

最新推荐文章于 2022-11-24 14:08:55 发布

原创最新推荐文章于 2022-11-24 14:08:55 发布 · 900 阅读

1 ·

CC 4.0 BY-SA版权

DB2 专栏收录该内容

4 篇文章

订阅专栏

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"

15. 释放数据库: deactivate database [dbname]

16. 获取数据库配置及当前状态信息: db2 get db cfg for <dbname>

17. 停止/启动数据库

db2stop force

db2start