IBM Support

SQL1042C with db2start

Troubleshooting


Problem

db2start fails due to damaged audit confgiruation

Symptom

Starting DB2 instance using command db2start fails with error code SQL1042C:

SQL1042C An unexpected system error occurred. SQLSTATE=58004

In db2diag.log, the following errors are found.

2016-11-07-13.18.08.632104+000 I4890205A386 LEVEL: Error
PID : 2435468 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: db2srv001
EDUID : 1
FUNCTION: DB2 UDB, bsu security, sqlexAuditGetNodeNum, probe:13939
MESSAGE : ZRC=0x070F00B8=118423736=SQLO_NOT_FOUND
"Environment/registry variable was not found."

2016-11-07-13.18.08.632443+000 I4890592A380 LEVEL: Error
PID : 2435468 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: db2srv001
EDUID : 1
FUNCTION: DB2 UDB, bsu security, sqlexAuditGetLogFileName, probe:14033
MESSAGE : ZRC=0x875C00CD=-2024013619=SQLEX_UNEXPECTED_SYSERR
"Unexpected System Error"

2016-11-07-13.18.08.633079+000 I4891763A801 LEVEL: Error
PID : 2435468 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: db2srv001
EDUID : 1
FUNCTION: DB2 UDB, bsu security, sqlexAuditData::logEvent, probe:1102
MESSAGE : ZRC=0x875C00CD=-2024013619=SQLEX_UNEXPECTED_SYSERR
"Unexpected System Error"
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1042 sqlerrml: 3
sqlerrmc: 205
sqlerrp : SQLEXADT
sqlerrd : (1) 0x875C00CD (2) 0x000000CD (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

2016-11-07-13.18.08.633292+000 I4892565A1278 LEVEL: Error
PID : 2435468 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: db2srv001
EDUID : 1
FUNCTION: DB2 UDB, bsu security, sqlexAuditData::logEvent, probe:1143
MESSAGE : ZRC=0x875C00CD=-2024013619=SQLEX_UNEXPECTED_SYSERR
"Unexpected System Error"
DATA #1 : String, 27 bytes
SQEX dumped temporary SQLCA
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1042 sqlerrml: 3
sqlerrmc: 205
sqlerrp : SQLESTRT
sqlerrd : (1) 0x875C00CD (2) 0x000000CD (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 58004
DATA #3 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1042 sqlerrml: 3
sqlerrmc: 205
sqlerrp : SQLEXADT
sqlerrd : (1) 0x875C00CD (2) 0x000000CD (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.8;9.7;10.1;10.5","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

swg21995706

Page Feedback