IBM DB2 LUW DBA Tutorial -- db2top

/**

声明：此随笔为在youtube上学习‘ IBM DB2 LUW/UDB DBA Tutorial for Beginners' 课程笔记.

YouTube视频连接：https://www.youtube.com/watch?v=Pjvwm4rC5Ok&list=PLCNIKwM6iuv7g1hDWDcNkc66vZuVJmvZg

**/

1. Check application

　　db2 list application

　　

 

 2. db2top -d sep2019

 

 3. db2pd -db sep2019 -wlocks

4. select AGENT_ID, substr(TABNAME, 1,30) TABNAME, LOCK_OBJECT_TYPE, LOCK_MODE, LOCK_STATUS FROM TABLE(SNAP_GET_LOCK('',-1)) as T where TABNAME is not null and TABNAME='T1'

5. db2 "force application (1300)"

posted on 2020-07-27 00:13  画扇2020  阅读(138)  评论(0)  编辑  收藏  举报