db2强制停止SQL6036N问题处理
问题描述: 执行命令db2stop force无响应。返回SQL6036N
原因可以数据库大量sql运行,无法结束,导致数据库hung,连库依然报SQL6036N START 或 STOP DATABASE MANAGER 命令已在处理之中。 解决办法: 删除sqllib/ctrl/db2strst.lck文件,默认这个文件是空的。 执行db2_kill,会提示:Application ipclean:Removing DB2 engine and client IPC resources for db2name. 重新启动DB2:
db2start
查看数据库的活动状态:
db2 list active databases 会显示当前活动库,这时候说明数据库已经恢复正常了。
备注:谨慎使用db2stop force以及db2_kill命令。
db2top排查db2当前运行session情况,确认哪些sql。
http://www-01.ibm.com/support/docview.wss?uid=swg21427711 Unable to start or stop db2 - DB2 is hung Technote (troubleshooting) Problem(Abstract) SQL6036N: START or STOP DATABASE MANAGER command is already in progress. Symptom DB2 will not start or stop. Cause DB2 is hung. Diagnosing the problem SQL6036N maybe seen when issuing db2stop or db2start, or the command may hang. Resolving the problem In some cases, db2 will appear to be hung and will not respond to db2stop or db2start. The db2 commands will give the following message: SQL6036N: START or STOP DATABASE MANAGER command is already in progress. To force the db2 to shut down, open a db2 client command line window and issue: db2_kill Note: restarting the database or recycling the system may also resolve the issue. Product Alias/Synonym
[rim@nxkhdb1 ~]$ db2 connect to rimdb SQL6036N START or STOP DATABASE MANAGER command is already in progress. [rim@nxkhdb1 sqllib]$ cd sqllib/crtl [rim@nxkhdb1 ctrl]$ db2 list active databases SQL6036N START or STOP DATABASE MANAGER command is already in progress. [rim@nxkhdb1 ctrl]$ cp db2strst.lck db2strst.lck.bak [rim@nxkhdb1 ctrl]$ rm db2strst.lck [rim@nxkhdb1 ctrl]$ db2_kill ipclean: Removing DB2 engine and client's IPC resources for rim. [rim@nxkhdb1 ctrl]$ db2start 05/11/2020 10:05:52 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. [rim@nxkhdb1 ctrl]$ db2 list active databases SQL1611W No data was returned by Database System Monitor. [rim@nxkhdb1 ctrl]$ db2 connect to rimdb Database Connection Information Database server = DB2/LINUXX8664 9.7.11 SQL authorization ID = RIM Local database alias = RIMDB [rim@nxkhdb1 ctrl]$ db2 list tablespaces show detail|grep State [rim@nxkhdb1 ctrl]$ db2 list application Auth Id Application Appl. Application Id DB # of Name Handle Name Agents -------- -------------- ---------- -------------------------------------------------------------- -------- ----- RIM db2bp 8 *LOCAL.rim.200511020624 RIMDB 1 RIM db2bp 79 *LOCAL.rim.200511020752 RIMDB 1