I am Using DB2 Ver 8.2 Workgroup Server Edition on Windows 2000. While Restarting the database, I am getting SQL5043n. Remote clients cannot access the Db.

I checked SVCENAME parameter in Database manager config, it is db2c_DB2.
Also, i checked /WINNT/system32\driver\etc\Services file.
It is having db2c_DB2 50000/tcp

I am using tcpip protcol . DB2COMM=TCPIP

In Control Centre, Instances , Click 'SetUp communications' . Select TCP/IP Properties. It is displaying correct host name and service name. In port number now it is blank. Previously it is having value - 50000.

I haven't get any message like 'TCP/IP successfully started ' on db2diag.log.

I changed the Diaglevel to 4 and following error shows in db2diag.log file.


2005-10-19-10.29.00.046000+480 I29055H415 LEVEL: Error
PID : 1920 TID : 1388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr, probe:5
MESSAGE : DIA3201E The service name "db2c_DB2" specified in the database
manager configuration file cannot be found in the TCP/IP services
file.

2005-10-19-10.29.01.046000+480 E29472H787 LEVEL: Event
PID : 1920 TID : 1136 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 124 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.7.445", "s040812", "WR21342", FixPak "7".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT BN Service Pack 4 5.0 x86 Family 15, model 2, stepping 9
CPU: total:4 online:4
Physical Memory: total:3072 free:2621 available:1909
Virtual Memory: total:7008 free:6645
Swap Memory: total:3936 free:4024


Please any one help me..


Thanks.

Prabhakar