IBM Support

Missing SQLDBCONF and SQLDBCON files throws -5005 error

Troubleshooting


Problem

SQL5005C error is thrown when an application attempts to retrieve the database configuration file, SQLDBCONF or its backup, SQLDBCON if they are not to be found on the filesystem.

Symptom

The following messages can be seen in the db2diag.log when DB2 attempts to access these files:

2013-08-13-11.51.22.039180-240 I189076A701 LEVEL: Warning
PID : 30387 TID : 2201804073232PROC : db2sysc 0
INSTANCE: <instance> NODE : 000 DB : <DB>
APPHDL : 0-20435 APPID: *LOCAL.instance.130813155123
AUTHID : <auth ID>
EDUID : 8782 EDUNAME: db2agent (DB) 0
FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify, probe:721
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
DATA #1 : String, 60 bytes
Error opening db config file. Checking if upgrade is needed
DATA #2 : String, 54 bytes
/home/instance/instance/NODE0000/SQL0000#/SQLDBCONF

2013-08-13-11.51.23.539697-240 I189778A677 LEVEL: Error
PID : 30387 TID : 2201804073232PROC : db2sysc 0
INSTANCE: <instance> NODE : 000 DB : <DB>
APPHDL : 0-20435 APPID: *LOCAL.instance.130813155123
AUTHID : <auth ID>
EDUID : 8782 EDUNAME: db2agent (DB) 0
FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify, probe:737
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
DATA #1 : String, 39 bytes
SQL5005: Error opening old config file
DATA #2 : String, 53 bytes
/home/instance/instance/NODE0000/SQL0000#/SQLDBCON

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Routines (SP \u0026 UDF) - SQL","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;10.1;10.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:
30 April 2025

UID

swg21647108

Page Feedback