DB2 并发问题诊断与实践-Part I.docVIP

DB2 并发问题诊断与实践1. 设置监控和Snapshot参数 db2 update dbm cfg using DFT_MON_LOCK on DFT_MON_STMT on db2 update monitor switches using bufferpool on lock on sort on statement on table on timestamp on uow on查看Lock状态 2.1 通过list application查看通过list applications show detail查看是否有lock-wat的applicationdb2 list application show detail |grep -i Lock-waitCONNECT Auth Id Application Name Appl. Application Id Seq# Number of Coordinating DB Coordinator Status Status Change Time DB Name DB Path Handle Agents partition number pid/threadDB2INST8 db2bp 110 *LOCAL.db2inst8.130515053048 00001 1 0 112 Lock-w