23. 将暂挂的数据恢复到前滚状态
db2 ROLLFORWARD DATABASE TESTDB TO END OF LOGS AND COMPLETE NORETRIEVE |
24.备份表空间
BACKUP DATABASE YNDC TABLESPACE ( USERSPACE1 )
TO "D:\temp" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING |
25.创建db2工具数据库
db2 create tools catalog systools create new database toolsdb |
26.如何进行增量/差量备份
增量:上一次完整备份至本次备份之间增加的数据部分;
差量(delta):上次备份以来(可能是完整备份、增量备份或者差量备份)至本次备份之间增加的数据部分;
27.更新所有表的统计信息
db2 -v connect to DB_NAME
db2 -v "select tbname, nleaf, nlevels, stats_timefrom sysibm.sysindexes"
db2 -v reorgchkupdate statistics on table all
db2 -v "select tbname, nleaf, nlevels, stats_timefrom sysibm.sysindexes"
db2 -v terminate |
28.对一张表运行统计信息
db2 -v runstatson table TAB_NAMEand indexes all |
29.查看是否对数据库执行了RUNSTATS
db2 -v "select tbname, nleaf, nlevels,
stats_timefrom sysibm.sysindexes" |
30.更改缓冲池的大小
缓冲池中,当syscat.bufferpools的npages是-1时,由数据库的配置参数bufferpage控制缓冲池的大小。
将npages的值更改为-1的命令:
db2 -v connect to DB_NAME
db2 -v select * from syscat.bufferpools
db2 -v alter bufferpoolIBMDEFAULTBP size -1
db2 -v connect reset
db2 -v terminate |
更改数据库配置参数BufferPages的命令如下:
db2 -v update db cfgfor dbnameusing BUFFPAGE bigger_value
db2 -v terminate |
31.查看数据库监视内容列表
db2 -v get monitor switches |
32.打开某个数据库监视内容
db2 -v update monitor switches using bufferpoolon |
33.获取数据库快照
db2 -v get snapshot for all databases > snap.out
db2 -v get snapshot for dbm>> snap.out
db2 -v get snapshot for all bufferpools>> snap.out
db2 -v terminate |