The db2start command might return errors SQL5043N and SPM0438
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-22.214.171.124689+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.
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.
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: