DB2 startup problem

[mohsin_m3]

Hi,

while starting DB2 I am getting below error

hostname:db2sid 35> db2start

12/29/2012 12:30:04     0   0   SQL5043N  Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully.

SQL1063N  DB2START processing was successful.

hostname:db2sid 36>

***************************************************************************************

hostname:/db2/db2sid/sqllib # grep -i SVCE /etc/services

hostname:/db2/db2sid/sqllib # grep -i db2 /etc/services

ibm-db2          523/tcp                # IBM-DB2

ibm-db2          523/udp                # IBM-DB2

questdb2-lnchr  5677/tcp                # Quest Central DB2 Launchr

questdb2-lnchr  5677/udp                # Quest Central DB2 Launchr

sapdb2sid       5912/tcp        # SAP DB2 Communication Port

DB2_db2sid      5914/tcp

DB2_db2sid_1    5915/tcp

DB2_db2sid_2    5916/tcp

DB2_db2sid_END  5917/tcp

hostname:/db2/db2sid/sqllib #

hostname:db2sid 36> db2 get dbm cfg | grep SVCE

TCP/IP Service name                          (SVCENAME) =

SSL service name                         (SSL_SVCENAME) =

***************************************************************************************

Retrans -d

4 ETW000  [	dev trc,00000]  *** ERROR in DB6Connect[dbdb6.c, 1866] CON = 0 (BEGIN)	33  7.846606
4 ETW000  [	dev trc,00000]  &+	DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30081N  A communication error has been detected. Communication
4 ETW000	55  7.846661
4 ETW000  [	dev trc,00000]  &+	protocol being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location where the error was detected: "
4 ETW000	41  7.846702
4 ETW000  [	dev trc,00000]  &+	146.215.108.46".  Communication function detecting the error: "connect".  Protocol specific error code(s): "79", "
4 ETW000	47  7.846749
4 ETW000  [	dev trc,00000]  &+	*", "*".  SQLSTATE=08001

Thanks and Regards

Mohsin

[mohsin_m3 · Accepted solution]

Hi,

db2 update dbm cfg using SVCENAME sapdb2QA2

Issue resolved with above command

Thanks and Regards

Mohsin

[Former Member · Accepted solution]

Hi Mohsin,

Did you check the diag log after the above command

db2 update dbm cfg using SVCENAME sapdb2QA2 

Check once and also test db2licm -l to check the db2 license

Regards

Anuj

[jens_reppe2 · Accepted solution]

Hi,

I had the same problem and had to reboot the machine after applying parameter SVCENAME. The diaglog said the port was in use.

Regards,

Jens

[Former Member · Accepted solution]

Hi Mohsin,

Kindlu update the SYSADM group by DNSTADM

db2 get dbm cfg | grep -i sys

Check with any System which has DB2 installed , you will understand more about DNSTADM.

Regard,

Dipak