db2start and db2stop may fail with SQL1042C error

Technote (troubleshooting)


Problem(Abstract)

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

Cross reference information
Segment Product Component Platform Version Edition
Information Management DB2 for Linux- UNIX and Windows

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.1, 9.5, 9.7, 10.1

Operating system(s):

AIX, HP-UX, Linux, Solaris

Reference #:

1593936

Modified date:

2012-05-15

Translate my page

Machine Translation

Content navigation