Technical Blog Post
Abstract
Weekly Tips from DB2 Experts : How to resolve "Error 2215575553 bringing resource online" during DB2 MSCS fail-over
Body
In a DB2 MSCS setup during fail-over DB2 resource does not fail-over and we see the following error in the cluster log
ERR [RES] DB2 Server <DB2-0>: Error 2215575553 bringing resource online.
This can happen due to incorrect permissions on the db2nodes.lck file
DB2 trace will show the following entry
SYSTEM ERROR DB2 UDB oper system services sqloopenp cei
Error ZRC = 0x840F0001 = -2079391743 = SQLO_ACCD
Func.Called: CreateFile
System Errno: 5
Data1 (PD_TYPE_FILE_NAME,41) File name:
\\XXXX\XXXX\XXXX\db2nodes.lck
The error can be resolved by giving correct permissions to db2nodes.lck file
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
UID
ibm13287013