IBM Support

db2start and db2stop fail with SQL1042C error

Troubleshooting


Problem

When running db2start and db2stop locally, DB2 fails with following error: $ db2start SQL1042C An unexpected system error occurred. SQLSTATE=58004 $ db2stop SQL1042C An unexpected system error occurred. SQLSTATE=58004

Symptom

When "SQL1042C" error is encountered on db2start and db2stop, subsequently all other db2 commands (except "db2level") fail with the following:

'SQL5005C' error if the db2systm file is missing or permission issue such as:


$ db2 list db directory
SQL5005C System Error.

$ db2 get dbm cfg
SQL5005C System Error.

$ db2 list applications
SQL5005C System Error.

'SQL5055C' error if the db2systm file is corrupted/invalid such as:


$ db2 list db directory
SQL5055C The content of the database configuration file is not valid.

$ db2 get dbm cfg
SQL5055C The content of the database configuration file is not valid.

$ db2 list applications
SQL5055C The content of the database configuration file is not valid.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Instance","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21502619