IBM Support

The db2start command might return errors SQL5043N and SPM0438

Troubleshooting


Problem

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).

Symptom

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-14.46.19.204689+120 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.

Cause

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.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Connectivity - Other","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF027","label":"Solaris"}],"Version":"9.8;9.7;9.5;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21649398