db2 sqlstate 55032怎么解决?

发布网友 发布时间：2022-04-11 08:23

我来回答

共3个回答

懂视网 时间：2022-04-11 12:44

问题描述：

执行命令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

db2强制停止SQL6036N问题处理

标签：运行   win   ase   hung   monit   rod   window   turned   RoCE   

热心网友 时间：2022-04-11 09:52

热心网友 时间：2022-04-11 11:10