cancel
Showing results for 
Search instead for 
Did you mean: 

SQL5005c system error - not able to start db

Former Member
0 Kudos

Hi,

Our ECC 6.0 system with db2 v9.1 FP5 went down due to hardware issue. Now when I try to start the system, db is not coming up and getting the SQL5005C system error.

I have installed only today and don't have any backup for this system.

Log of db2diag.log:

2009-05-25-19.30.31.480563-420 E8580076E530 LEVEL: Warning (OS)

PID : 6997 TID : 47738965271520PROC : db2fm

INSTANCE: db2r3p NODE : 000

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)

DATA #1 : File name, 31 bytes

/db2/db2r3p/sqllib/db2nodes.cfg

2009-05-25-19.30.31.480962-420 I8580607E401 LEVEL: Severe

PID : 6997 TID : 47738965271520PROC : db2fm

INSTANCE: db2r3p NODE : 000

FUNCTION: DB2 UDB, oper system services, sqloWriteDb2nodes, probe:15

MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2009-05-25-19.30.31.481058-420 I8581009E400 LEVEL: Severe

PID : 6997 TID : 47738965271520PROC : db2fm

INSTANCE: db2r3p NODE : 000

FUNCTION: DB2 UDB, oper system services, sqloReadDb2nodes, probe:70

MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2009-05-25-19.30.31.481184-420 I8581410E370 LEVEL: Error

PID : 6997 TID : 47738965271520PROC : db2fm

INSTANCE: db2r3p NODE : 000

FUNCTION: DB2 UDB, config/install, sqlfReadDb2nodes, probe:10

MESSAGE : SQL5005: sqloReadDb2nodes rc =

DATA #1 : Hexdump, 4 bytes

0x00007FFF94174C50 : 0100 0F84 ....

2009-05-25-19.30.31.481250-420 I8581781E347 LEVEL: Severe

PID : 6997 TID : 47738965271520PROC : db2fm

INSTANCE: db2r3p NODE : 000

FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32

DATA #1 : Hexdump, 4 bytes

0x00007FFF94174E4C : 73EC FFFF s...

2009-05-25-19.30.41.575526-420 E8582129E530 LEVEL: Warning (OS)

PID : 7001 TID : 47675579462624PROC : db2fm

INSTANCE: db2r3p NODE : 000

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)

DATA #1 : File name, 31 bytes

/db2/db2r3p/sqllib/db2nodes.cfg

2009-05-25-19.30.41.575944-420 I8582660E401 LEVEL: Severe

PID : 7001 TID : 47675579462624PROC : db2fm

INSTANCE: db2r3p NODE : 000

FUNCTION: DB2 UDB, oper system services, sqloWriteDb2nodes, probe:15

MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2009-05-25-19.30.41.576039-420 I8583062E400 LEVEL: Severe

PID : 7001 TID : 47675579462624PROC : db2fm

INSTANCE: db2r3p NODE : 000

FUNCTION: DB2 UDB, oper system services, sqloReadDb2nodes, probe:70

MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2009-05-25-19.30.41.576128-420 I8583463E370 LEVEL: Error

PID : 7001 TID : 47675579462624PROC : db2fm

INSTANCE: db2r3p NODE : 000

FUNCTION: DB2 UDB, config/install, sqlfReadDb2nodes, probe:10

MESSAGE : SQL5005: sqloReadDb2nodes rc =

DATA #1 : Hexdump, 4 bytes

0x00007FFF562DFDC0 : 0100 0F84 ....

2009-05-25-19.30.41.576192-420 I8583834E347 LEVEL: Severe

PID : 7001 TID : 47675579462624PROC : db2fm

INSTANCE: db2r3p NODE : 000

FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32

DATA #1 : Hexdump, 4 bytes

0x00007FFF562DFFBC : 73EC FFFF

Please suggest is there any way to bring db up.

Regards,

Nallasivam.D

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

db2nodes.cfg file entries were modified. I corrected it and then it start working.

Regards,

Nallasivam.D