IBM Support

db2start gives "SQL1042C An unexpected system error occurred. SQLSTATE=58004" on Windows OS

Troubleshooting


Problem

On a Windows OS based server running Db2 server, Db2 fails to start and gives the following error "SQL1042C An unexpected system error occurred. SQLSTATE=58004". Also the key service for Db2 (db2sysc.exe) is not started or running.

Symptom

On a Windows OS machine whenever you try to launch Db2 using the db2start command you see the error below:

C:\>db2start
DB2 : The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.

SQL1042C  An unexpected system error occurred.  SQLSTATE=58004

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Operating System \/ Hardware - OS Configuration","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;10.1;10.5;11.1","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Express-C;Personal;Workgroup Server","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:
01 May 2025

UID

swg22005599