The db2start command might return errors SQL5043N and SPM0438

Technote (troubleshooting)


Problem(Abstract)

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.

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows
Connectivity - SynchPopint Manager (SPM)

Software version:

9.5, 9.7, 9.8, 10.1, 10.5

Operating system(s):

AIX, HP-UX, Linux, Linux iSeries, Linux pSeries, Linux zSeries, Solaris

Reference #:

1649398

Modified date:

2013-09-12

Translate my page

Machine Translation

Content navigation