DB2使用命令监控锁的情况.docxVIP

作业：1.使用命令监控锁的情况，使用类型2.练习在CLP命令中使用不同的隔离级别3.使用快照监控数据库的使用情况4.使用表函数监控SQL语句的使用情况1.使用命令监控锁的情况，使用类型[myinst@ye ~]$ db2 activate database mydb3SQL1493N The application is already connected to an active database.#查看锁表--看应用在等什么[myinst@ye ~]$ db2pd -db mydb3 -locks showlock waitDatabase Member 0 -- Database MYDB3 -- Active -- Up 0 days 01:50:51 -- Date 2015-08-18-93864Locks:Address TranHdl Lockname Type Mode Sts Owner Dur HoldCount Att ReleaseFlg rrIID TableNm SchemaNm[myinst@ye ~]$ db2 get db cfg |grep DLCHKTIME #是DB2检查死锁的间隔时间，该值为10000ms Interval for checking deadlock (ms) (DLCHKTIME) = 10000[myinst@ye ~]$ db2 get db cfg |grep LOCKTIMEOUT #锁等待最长时间, 单位是秒 Lock timeout (sec) (LOCKTIMEOUT) = -1 Lock timeout events (MON_LOCKTIMEOUT) = NONE#查看当前的隔离级别[myinst@ye ~]$ db2 SELECT CURRENT ISOLATION FROM SYSIBM.SYSDUMMY1#查看锁表--用快照[myinst@ye ~]$ db2 GET SNAPSHOT FOR LOCKS ON mydb3 Database Lock SnapshotDatabase name = MYDB3Database path = /www/db2/db2test/myinst/NODE0000/SQL00001/MEMBER0000/Input database alias = MYDB3Locks held = 0Applications currently connected = 1Agents currently waiting on locks = 0Snapshot timestamp = 08/18/2015 15:53:47.009051Application handle = 13Application ID = *LOCAL.DB2.150818055741Sequence number = 00001Application name = db2fw0CONNECT Authorization ID = MYINSTApplication status = Connect CompletedStatus change time = Not CollectedApplication code page = 1386Locks held = 0Total wait time (ms) = 0Application handle = 12Applicatio