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
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Information Management | DB2 for Linux- UNIX and Windows |
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.