rem---在cmd窗口中输入db2cmd,打开数据库管理窗口---
1.#连接某数据库
db2 connect to yilitest
2.#断开当前连接
DB2 disconnect current
3.获取数据库配置
db2 get db cfg
4.#强制重启
db2stop force
db2start
5.#查询数据库记录
db2 select * from yilitest
6.#查询数据库表字段
db2 describe table yilitest
7.创建数据库
$ db2 CREATE DATABASE liry
$ db2 activate db liry
$ db2 connect to liry
创建表
db2 "create table Regular.liry (id integer, name varchar(20), job varchar(20), join_date date, salary integer)"
向表内插入数据
db2 insert into regular. liry (id) values (123),(222)
8.#db2启用数据增量备份
#启用用户出口
db2 update db cfg for liry using userexit on
#启用归档日志
db2 update db cfg for liry using logretain on
#启用增量备份功能
db2 update db cfg for liry using trackmod on
9.修改归档日志的路径
db2 update db cfg for database using logarchmeth1 DISK:C:\DB2\NODE0000\SQL00003\SQLOGDIR
10.根据完全备份恢复
db2 restore db LIRY from F:/qz/workFloder taken at 20190923110540
11.数据库回滚
db2 ROLLFORWARD DATABASE LIRY TO END OF LOGS AND COMPLETE OVERFLOW LOG PATH (F:\qz\autobackup_0916\0916\log\DB2\LIRY\NODE0000\C0000003)