IBM Support

The db2start command might return errors SQL5043N and SPM0438

Technote (troubleshooting)


The DB2 product has a database configuration parameter SPM_NAME which is set for most instance types by default when an instance is created (the db2icrt command).


On some systems, you might receive SQL5043N while running the db2start command. In addition, you might see the following in the db2diag.log file:

2013-08-23- I23137E365 LEVEL: Severe

PID : 13174 TID : 140737127638784PROC : db2sysc

INSTANCE: db2inst1 NODE : 000

APPHDL : 0-6

EDUID : 17 EDUNAME: db2spmrsy

FUNCTION: DB2 UDB, syncpoint manager, sqlcspm_readlog, probe:10

MESSAGE : SPM0438 The Sync point manager recovery log is bad.


This problem might be caused by a missing IP address in the systems hosts database. The missing IP address can be /etc/hosts or DNS or similiar setup.

Diagnosing the problem

Check if there is an IP address configured for the hostname so that the hostname can be resolved. Check your local /etc/hosts or DNS configuration depending on how your system is configured.

Resolving the problem

Ensure that an IP address is available for the hostname in your hosts database (/etc/hosts).
Then remove the SPM logs under sqllib/spmlog and restart the instance of the DB2 product.

Document information

More support for: DB2 for Linux, UNIX and Windows
Connectivity - Other

Software version: 9.5, 9.7, 9.8, 10.1, 10.5

Operating system(s): AIX, HP-UX, Linux, Solaris

Reference #: 1649398

Modified date: 12 September 2013

Translate this page: