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

[manumohandas82]

Hi Mohsin ,

Please update your dbm cfg as follows

db2 update dbm cfg using  SVCENAME sapdb2sid

Restart the database and try .

Check whether any service is blocking the port 5912 .  You may restart the server if the issue still persists

Thanks ,

Manu

[Former Member]

Hi Team,

When ever any DBM ( Instance level) and DB (Database level) parameters are updated we can

cross check whether recycle required or not by using the below method.

db2 attach to DBSID

db2 get dbm cfg show detail |grep -i SVCENAME

if the current value and delayed vaules are same no need to recycle and if they are not same we

need to recycle to make them effect.