--DB2频繁出现死锁,常用解决问题的命令
db2 get snapshot for locks on sampledb2 get db cfg for sampledb2 update db cfg using dlchktime 10000-查看数据库管理器级别快照信息
db2 get snapshot for dbm -查看数据库级别快照信息 db2 get snapshot for database on dbname -查看应用级别快照信息 db2 get snapshot for application agentid appl-handler 注:appl-handler可以从list applicaitions的输出中得到 -查看表级别快照信息 db2 get snapshot for tables on dbname 注:需要把tables快照开关设为ON才会有作用 -查看锁快照信息 db2 get snapshot for locks on dbname 或 db2 get snapshot for locks on for application agentid appl-handler -查看动态sql语句快照信息 db2 get snapshot for dynamic sql on dbname db2 get monitor switchesdb2 update monitor switches using lock on statement oncreate event monitor mymonitor for deadlocks,statements write to file 'c:/temp' set event monitor mymonitor state 1db2evmon - path 'c:/temp'