Hi All,

When i'm running the db2start i'm getting following error message. But when i ran it for second time m able to start successfully.
Can you please tell me what could be the issue for the first run. This is happening everytime when i start database manager. Please let me know if i'm missing something.

$ ./db2 db2start
SQL1042C An unexpected system error occurred. SQLSTATE=58004
$ ./db2 db2start
DB20000I The DB2START command completed successfully.

--
Thanks & Regards,
Mallik
post reply

db2start is not a CLP command; it is a program. You will probably find more information about the error in db2diag.log.

Hi,

Thanks for your reply. I'm getting the same issue when i ran from db2 prompt ie below.

=>START DATABASE MANAGER

Also the below log shows the snapshot of db2diag.log. I have seen some fix to do a ipclean when we run the command. But, for that every time i need to run the command before starting database manager. Please let me know what can i do to resolve this issue.

FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection refused"
CALLED : OS, -, connect OSERR: ECONNREFUSED (111)
DATA #1 : String, 32 bytes
Unable to connect socket on path
DATA #2 : socket, 4 bytes
6
DATA #3 : sockaddr, 36 bytes
0x00000000431198C0 : 0100 2F68 6F6D 652F 6461 7375 7372 312F ../home/dasusr1/
0x00000000431198D0 : 6461 732F 746D 702F 6461 736E 616D 6564 das/tmp/dasnamed
0x00000000431198E0 : 7069 7065 pipe
DATA #4 : File name, 34 bytes
/home/dasusr1/das/tmp/dasnamedpipe

2008-10-24-18.07.59.864223-300 E260605E813 LEVEL: Error (OS)
PID : 6969 TID : 1125267792 PROC : db2acd
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection refused"
CALLED : OS, -, connect OSERR: ECONNREFUSED (111)
DATA #1 : String, 32 bytes
Unable to connect socket on path
DATA #2 : socket, 4 bytes
6
DATA #3 : sockaddr, 36 bytes
0x00000000431198C0 : 0100 2F68 6F6D 652F 6461 7375 7372 312F ../home/dasusr1/
0x00000000431198D0 : 6461 732F 746D 702F 6461 736E 616D 6564 das/tmp/dasnamed
0x00000000431198E0 : 7069 7065 pipe
DATA #4 : File name, 34 bytes
/home/dasusr1/das/tmp/dasnamedpipe

2008-10-24-18.09.59.915438-300 E261419E813 LEVEL: Error (OS)
PID : 6969 TID : 1125267792 PROC : db2acd
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection refused"
CALLED : OS, -, connect OSERR: ECONNREFUSED (111)
DATA #1 : String, 32 bytes
Unable to connect socket on path
DATA #2 : socket, 4 bytes
6
DATA #3 : sockaddr, 36 bytes
0x00000000431198C0 : 0100 2F68 6F6D 652F 6461 7375 7372 312F ../home/dasusr1/
0x00000000431198D0 : 6461 732F 746D 702F 6461 736E 616D 6564 das/tmp/dasnamed
0x00000000431198E0 : 7069 7065 pipe
DATA #4 : File name, 34 bytes

--
Thanks & Regards,
Mallik

If you have to run ipclean every time, it probably means that you are not shutting down DB2 properly. And I don't think the log entries you've shown are related to db2start.