执行force application命令,希望force掉7322:$ db2 "force application(17322)"
DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective immediately.
然而7322依然获得好好的,状态依旧为UOW-Executing,等了很久都没有变化:
Application Cpu% IO% Mem% Application Application Delta Delta Delta Delta Delta Sess Assoc. Paral.
Handle(Stat) Total Total Total Status Name RowsRead/s RowsWritten/s IOReads/s IOWrites/s TQr+w/s Memory Agents Degree
------------ ------- ------- ------- ----------------------------------- --------------- -------------- -------------- -------------- -------------- -------------- -------- ------ ------
17322(*) 50.06% 0.00% 1.05% UOW Executing db2bp.exe 0 0 0 0 0 3.1M 4 1
快照和日志中都没有看到有啥异常,想用db2support收信息来着,结果卡住了。(系统压力不大,CPU、内存、IO都很空闲。)
最后只好重启库,重启的时候由于有很多连接db2stop force总是失败,最后用db2_kill完成的。
请大家帮忙看看是啥情况??? 并给出建议,再次发生时应该收集哪些信息以分析问题??
附件:
7322_snapApp.txt (41.76 KB)
收起