DB2 SQL5043N Error on start
December 9, 2009 – 2:00 pm05/15/2007 15:01:59 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.
look into db2diag.log:
2007-05-15-15.01.58.846394-420 E92034A447 LEVEL: Error
PID : 405708 TID : 1 PROC : db2sysc 0
INSTANCE: db2inst1 NODE :
000
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr, probe:50
MESSAGE : ADM7006E The SVCENAME DBM configuration parameter was not
configured. Update the SVCENAME configuration parameter using the
service name defined in the TCP/IP services file.
2007-05-15-15.01.59.901248-420 E92482A1028 LEVEL: Event
PID : 397514 TID : 1 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2
DBM
DATA #1 : Build Level, 152 bytes
Instance “db2inst1″ uses “64″ bits and DB2 code release “SQL09012″
with level identifier “01030107″.
Informational tokens are “DB2 v9.1.0.2″, “s070210″, “U810940″, Fix Pack “2″.
DATA #2 : System Info, 224 bytes
System: AIX fnl70 3 5 00CE3A8A4C00
The error is caused by a black SVCNAME in the database manager settings.
You can validate this by running the following command:
bash-3.00# db2 get dbm cfg | grep -i svc
TCP/IP Service name (SVCENAME) =
Find out what’s defined in /etc/services:
bash-3.00# 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
DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END 60003/tcp
To fix this, update the dbm cfg using that value in /etc/services; in this case DB2_db2inst1:
bash-3.00# db2 update dbm cfg using SVCENAME DB2_db2inst1
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
bash-3.00# db2stop
force
05/15/2007 15:31:57 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
bash-3.00# db2start
05/15/2007 15:32:02 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
This SOLVED the SQL5043N problem.
.pw.
You must be logged in to post a comment.