cancel
Showing results for 
Search instead for 
Did you mean: 

db2 command error: SQL5005C System error, because of "Reset Configuration"

Former Member
0 Kudos

hello

In db2ca i klik "Configure"->"Reset Configuration"

It is "Solution menager 4.0" on Windows 2003

Now command db2 get error "SQL5005C System error"

I heve backup but I cannot use it because of db2 command.

Can I repair it ?

command:

db2 -> SQL5005C System error

db2ilist -> DB2SOL

db2admin -> DB2DAS00

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

command:

db2set -all

nothing return

db2set DB2COMM=tcpip -g

db2set -all

nothing return

db2diag.log - http://www.sosna.pw.edu.pl/db2diag.log

sample error in db2diag.log

2008-04-21-15.04.30.002000+120 I9735956H349 LEVEL: Warning

PID : 5744 TID : 2948 PROC : javaw.exe

INSTANCE: DB2SOL NODE : 000

FUNCTION: DB2 UDB, Client Config, cfgNode::Catalog, probe:32

MESSAGE : NODE:

DATA #1 : Hexdump, 8 bytes

0x0C3EFB78 : 495F 4E31 5F53 4F4C I_N1_SOL

2008-04-21-15.04.30.018000+120 I9736307H296 LEVEL: Error

PID : 5744 TID : 2948 PROC : javaw.exe

INSTANCE: DB2SOL NODE : 000

FUNCTION: DB2 UDB, trace services, sqlt_logerr_string, probe:0

MESSAGE : Sqlcode

DATA #1 : String, 10 bytes

SQL -1018

2008-04-21-15.04.40.049000+120 I9736605H315 LEVEL: Error

PID : 5744 TID : 6832 PROC : javaw.exe

INSTANCE: DB2SOL NODE : 000

FUNCTION: DB2 UDB, common communication, sqlcctcpconnr, probe:110

MESSAGE : DIA3202C The TCP/IP call "connect" returned an errno="10061".

2008-04-21-15.04.40.049000+120 I9736922H310 LEVEL: Error

PID : 5744 TID : 6832 PROC : javaw.exe

INSTANCE: DB2SOL NODE : 000

FUNCTION: DB2 UDB, base sys utilities, sqledscvr_getinfo, probe:20

MESSAGE : DIA3013E DB2 function "sqleatin" failed: rc = "-30081".

Edited by: Maciej Podstawka on Apr 24, 2008 3:51 PM

Former Member
0 Kudos

Hi,

Did you see any errors in db2dump?

Regards,

Sam