db2 snapshot 准备步骤

db2 update    dbm cfg using DIAGLEVEL 4

db2 update    dbm cfg using DFT_MON_BUFPOOL ON

db2 update    dbm cfg using DFT_MON_LOCK ON

db2 update    dbm cfg using DFT_MON_SORT ON

db2 update    dbm cfg using DFT_MON_STMT ON

db2 update    dbm cfg using DFT_MON_TABLE ON

db2 update    dbm cfg using DFT_MON_TIMESTAMP ON

db2 update    dbm cfg using DFT_MON_UOW ON

db2 update    dbm cfg using HEALTH_MON ON

db2 update    dbm cfg using MON_HEAP_SZ 1000

db2stop force

db2start

 

 

db2 reset monitor all

 

 

 

db2 get snapshot  for all on <databasename> >> snapshot.log