IBM Support

db2start and db2stop may fail with SQL1042C error

Troubleshooting


Problem

db2start and db2stop may fail with unexpected system error SQL1042C and SQLSTATE=58004

Symptom

When running db2start and db2stop locally, DB2 may fail with following error:

$ db2start
SQL1042C An unexpected system error occurred. SQLSTATE=58004

$ db2stop
SQL1042C An unexpected system error occurred. SQLSTATE=58004

Entries in db2diag.log:

2012-05-08-01.12.44.976730+120 I358167A346 LEVEL: Severe
PID : 1318976 TID : 1 PROC : db2start
INSTANCE: inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqlestrt.C::main, probe:32
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFB09C : FFFF FBEE ....

2012-05-08-01.12.57.077628+120 I358514A344 LEVEL: Severe
PID : 860306 TID : 1 PROC : db2stop
INSTANCE: inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqlestp.C::main, probe:32
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFB01C : FFFF FBEE ....

Following entry can be seen in the traces:

502 sqlex_db2chkau_main error [probe 550] [ ZRC = 0x870F00BB = -2029059909 = SQLO_QUE_NO_ACCESS]


502 error DB2 UDB bsu security sqlex_db2chkau_main fnc (4.3.92.70.0.550)
pid 164038 tid 1 cpid -1 node -1 sec 0 nsec 300088384 probe 550
Error ZRC = 0x870F00BB = -2029059909 = SQLO_QUE_NO_ACCESS

Cause

SUID is set for db2chkau file under <installation_path>/security64 directory.

Environment

DB2 for LUW

Resolving The Problem

Remove the SUID from db2chkau file under <installation_path>/security64

For example:


$  ls -l /opt/IBM/db2/V9.7FP5/security64/db2chkau
-rwsrwxr-x 1 bin bin 28496 Jan 15 2016 db2chkau

To Remove SUID from db2chkau issue
$ chmod u-s /opt/IBM/db2/V9.7FP5/security64/db2chkau

Related Information

SQL1042C

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Routines (SP & UDF) - SQL","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.7;9.5;9.1;10.1;10.5;11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21593936

Page Feedback