如果使用db2 get snapshot for aplication agentid xx，可以看到某个未提交的应用最后执行的SQL语句，进而定位到问题，比如：
$ db2 get snapshot for application agentid 441
Application Snapshot
Application handle = 441
Application status = UOW Waiting <<--应用状态为UOW Waiting
...
Statement type = Dynamic SQL Statement
Statement = Close
Section number = 201
Application creator = NULLID
Package name = SQLC2K26
Consistency Token =
Package Version ID =
Cursor name = SQLCUR201
Statement member number = 0
Statement start timestamp = 2017-03-09 17:23:15.067789
Statement stop timestamp = 2017-03-09 17:23:15.068893
Elapsed time of last completed stmt(sec.ms)= 0.000024
Total Statement user CPU time = 0.000000
Total Statement system CPU time = 0.000000
..
Dynamic SQL statement text:
select * from t1
如果用视图和表函数，可以考虑先从MON_GET_UNIT_OF_WORK表函数中获取LAST_EXECUTABLE_ID，然后根据这个EXECUTABLE_ID去MON_GET_PKG_CACHE_STMT表函数中查找对应的STMT_TEXT，但这样做有一个缺点，就是一旦SQL被从package cache中刷出去，就查不到了。这种情况下可以从上面的快照命令中获取，如果想直接从表函数/视图中获取，可以考虑SNAPSTMT视图 或SNAP_GET_STMT表函数，具体说明见下面的链接：