IBM Support

IBM® Db2® security special build for V9.7, V10.1, V10.5, V11.1 and V11.5 creates fencedid file with wrong permissions, causing db2start to fail with SQL1042C

Troubleshooting


Problem

V9.7  SB38744
V10.1 SB38745
V10.5 SB38746
V11.1 SB38747
V11.5 GA & SB38979
Customers applying the security fix for above versions on Linux-type platforms are unable to start the instance after the update due to db2iupdt not creating the file '/home/db2inst1/sqllib/adm/fencedid' with the correct file permissions.

Symptom

Receive error:
SQL1042C An unexpected system error occurred
SQL1032N No start database manager command was issued. SQLSTATE=57019
In db2diag.log shows the following:
```
2019-07-24-15.14.59.360675-300 E2928923A1036        LEVEL: Error (OS)
PID     : 13304096             TID : 258            PROC : db2wdog 0 
INSTANCE: db2inst1                     NODE : 000
HOSTNAME: 
EDUID   : 258                  EDUNAME: db2wdog 0 
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
         DIA8701C Access denied for resource "", operating system return code 
         was "".
CALLED  : OS, -, open
OSERR   : EACCES (13) "Permission denied"
DATA #1 : Codepath, 8 bytes
4:9:15:16:40
DATA #2 : File name, 37 bytes
/home/db2inst1/sqllib/adm/fencedid
DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes
SQLO_REVISE, SQLO_READONLY, SQLO_SHAREREAD
DATA #4 : Hex integer, 4 bytes
0x00000100
DATA #5 : signed integer, 4 bytes
0
DATA #6 : Hex integer, 4 bytes
0x00000000
DATA #7 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.
```

Document Location

Worldwide

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

UID

ibm11038810