DB_DATABASE_START_FAILED sqlCode 5043

Technote (troubleshooting)


Problem(Abstract)

ANR9999D_1438116997 RdbStartInstance message received when starting the Tivoli Storage Manager server.

Symptom

The following messages are logged on server startup :


ANR4726I The ICC support module has been loaded.
ANR0990I Server restart-recovery in progress.
ANR0151W Failure starting database manager.
ANR9999D_1438116997 RdbStartInstance(rdbinst.c:1057) Thread<0>: Add codes to
msg DB_DATABASE_START_FAILED sqlCode 5043.

Cause

Unable to connect to TCPIP Port for the DB2 Server.

Diagnosing the problem

The sqlcode 5043 reported in the ANR9999D message translates to the following text :


Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully.

1. Verify the db2diag.log for errors similar to the following during DB2 startup:

2011-04-07-18.30.26.144000-240 E5056F506 LEVEL: Error
PID : 4212 TID : 3412 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 3412 EDUNAME: db2sysc
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.

2. Verify the c:\windows\system32\drivers\etc\services file to find out which port is listed for DB2. For example :

# <service name> <port number>/<protocol> [aliases...] [#<comment>]
DB2_TSM1 50000/tcp #DB2 Server port.


3. Verify the DB2 configuration for the value of SVCENAME. From a DB2 command window, run the following commands :

set db2instance=server1
db2 connect to tsmdb1
db2 get dbm cfg | find /i "svcename"

Output from the last command shows :

TCP/IP Service name (SVCENAME) =


Resolving the problem

In this instance, the error occurs because the SVCENAME value is empty. The DB2 SVCENAME value must match the value specified in the Windows services file. Follow the steps below to resolve this.


1. Open a DB2 command window.
Start --> Programs --> IBM DB2 --> DB2TSM1 (Default) --> Command Line Tools --> Command Window - Administrator

2. Connect to the Tivoli Storage Manager database TSMDB1.
db2 connect to tsmdb1[

3. Display the current setting for SVCENAME.
db2 get dbm cfg | find /i "svcename"

4. Change the SVCENAME value to the value listed in the c:\windows\system32\drivers\etc\services file.
db2 update dbm cfg using SVCENAME DB2_TSM1
Note: The SVCENAME value can be different depending on what was configured.

5. Stop DB2 with the following command :
db2stop

6. Start the Tivoli Storage Manager server instance.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager
Server

Software version:

6.1, 6.2, 6.3, 6.4

Operating system(s):

Windows

Software edition:

All Editions

Reference #:

1496190

Modified date:

2013-05-13

Translate my page

Machine Translation

Content navigation