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

Cause

The Windows Service responsible for the "db2sysc.exe" process is either disabled, or not able to run by some other cause.

Environment

Windows OS

Diagnosing The Problem

Check that the Db2 related service that runs the executable "db2sysc.exe" is running.

Resolving The Problem

Ensure that the service can start. If it's not running or able to start then check what "Log On" user ID and password credentials the service is using, and make fully sure that these credentials are correct, enabled and working. If the current credentials still cause the service to fail from starting then try a different set of credentials. If that fails then you may need to re-install or repair the Db2 installation and files or refer to your Windows Server administrator.

[{"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"}}]

Document Information

Modified date:
16 June 2018

UID

swg22005599

Page Feedback