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.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21649398