{"id":1092,"date":"2011-06-08T03:18:58","date_gmt":"2011-06-07T21:18:58","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=1092"},"modified":"2016-01-07T11:31:06","modified_gmt":"2016-01-07T05:31:06","slug":"receiving-sql5043n-and-spm0438","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=1092","title":{"rendered":"Receiving SQL5043n and SPM0438 ?"},"content":{"rendered":"<p><span style=\"font-family: georgia, palatino; font-size: medium;\">What you gonna do when you recieve SQL5043n ? \u00c2\u00a0<\/span><span class=\"Apple-style-span\" style=\"font-size: medium; font-family: georgia, palatino;\">If you see the error on the diaglog or get this when you initiate a connection to DB2, \u00c2\u00a0it means DB2 hasn&#8217;t started the communication protocols. \u00c2\u00a0According to IBM&#8217;s manual :<\/span><\/p>\n<p><span class=\"Apple-style-span\" style=\"font-weight: bold; line-height: 18px; font-family: georgia, palatino; font-size: medium; color: #ffcc00;\">SQL5043N:Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino; font-size: medium;\">I could mean either the tcpip communication parameter is not turned or the port that db2 needs to listen is not mentioned. Check if you have set the following.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino; font-size: medium;\">1. &#8220;db2set -all&#8221; should show DB2COMM=tcpip. If not, then you will need to run &#8220;db2set DB2COMM=tcpip&#8221;. Then run db2stop and db2start.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino; font-size: medium;\">2. SVCENAME parameter in dbm cfg. You may run &#8220;db2 get dbm cfg|grep SVCENAME&#8221; to find the port number or service name. If its blank or wrong, then update the database base configuration by issuing \u00c2\u00a0the following command with the appropriate port number or service name &#8220;db2 update dbm cfg using SVCENAME &lt;port number\/service name&gt;&#8221; t. If you are using the service name, ensure the service name is specified on the \/etc\/services file on a Unix\/Linux server.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino; font-size: medium;\">In both cases you need to recycle the db2 instance. \u00c2\u00a0<\/span><\/p>\n<p>If the SQL5043 is followed by a SPM0438, then it means your sync point manager log might be bad.<\/p>\n<p><span style=\"color: #ffcc00;\"><strong>SPM0438 The Sync point manager recovery log is bad<\/strong><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino; font-size: medium;\">To resolve the SPM0438 error:<\/span><\/p>\n<p>1. Stop the instance.<br \/>\n2.\u00c2\u00a0Turn off SPM by setting SPM_NAME in dbm cfg to NULL.<br \/>\n3.\u00c2\u00a0Remove everything in the sqllib\/spmlog directory (and all directories underneath) .<br \/>\n4. Start the instance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What you gonna do when you recieve SQL5043n ? \u00c2\u00a0If you see the error on the diaglog or get this when you initiate a connection to DB2, \u00c2\u00a0it means DB2 hasn&#8217;t started the communication protocols. \u00c2\u00a0According to IBM&#8217;s manual : SQL5043N:Support for one or more communications protocols failed to start successfully. However, core database manager [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[3],"tags":[943,640,639,642,644,638,641,643],"class_list":["post-1092","post","type-post","status-publish","format-standard","hentry","category-db2","tag-db2","tag-db2comm","tag-spm0438","tag-spm_name","tag-sql-5043","tag-sql5043n","tag-svcename","tag-sync-point-manager-recovery-log"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1092","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1092"}],"version-history":[{"count":13,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1092\/revisions"}],"predecessor-version":[{"id":1111,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1092\/revisions\/1111"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}