Thursday, May 05, 2005

SPM0438 The Sync point manager recovery log is bad

You might also see the following message when starting DB2

SQL5043N Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully.

or
with the following message and db2 will not start.

SQL5042N One of the communication protocol server support processes failed to start up.


Solution:
  • Stop the instance
  • Delete/move all the spm logs located in sqllib/spmlog/SPMLOGSD
  • Also del/move SPMLOG.LCF located in sqllib/spmlog
  • start the instance. Should starup without any error messages.