DB2快照提取

DB2快照提取

一、开启会话级的数据库快照
db2 update monitor switches using bufferpool on lock on sort on statement on table on uow on timestamp on;

二、系统运行一段时间后，获取快照
db2 get snapshot for database on targeDb > database.sp
db2 get snapshot for tablespaces on targeDb > tablespaces.sp
db2 get snapshot for bufferpools on targeDb > bufferpools.sp
db2 get snapshot for locks on targeDb > locks.sp
db2 get snapshot for tables on targeDb > talbes.sp
db2 get snapshot for applications on targeDb > applications.sp
db2 get snapshot for dynamic sql on targeDb > sql.sp

三 写成执行文件

1.开启快照 minitorOn.sh
db2 update monitor switches using bufferpool on lock on sort on statement on table on uow on timestamp on

2.关闭快照 monitorOff.sh
db2 update monitor switches using bufferpool off lock off sort off statement off table off uow off timestamp off

3.提取快照并追加到相应的文件 snapshort.sh
date >> database.sp
db2 get snapshot for database on easd >> database.sp
date >> tablespaces.sp
db2 get snapshot for tablespaces on easd >> tablespaces.sp
date >> bufferpools.sp
db2 get snapshot for bufferpools on easd >> bufferpools.sp
date >> locks.sp
db2 get snapshot for locks on easd >> locks.sp
date >> talbes.sp
db2 get snapshot for tables on easd >> talbes.sp
date >> applications.sp
db2 get snapshot for applications on easd >> applications.sp
date >> sql.sp
db2 get snapshot for dynamic sql on easd >> sql.sp