IBM Support

Unable to start or stop db2 - DB2 is hung

Troubleshooting


Problem

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":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM

Document Information

Modified date:
17 June 2018

UID

swg21427711