SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing, message pops up when we try to start DB2 (v9.7). While contacting the customer, I came to know that there was a VM restart and after that DB2 was not starting at all.<\/p>\n
Following was coming up during start command of the database,<\/p>\n
[root@<hostname> adm]# .\/db2start
\n02\/01\/2016 20:09:57\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0 0\u00a0\u00a0 SQL6048N\u00a0 A communication error occurred during START or STOP DATABASE MANAGER processing.
\nSQL1032N\u00a0 No start database manager command was issued.\u00a0 SQLSTATE=57019<\/p>\n
Resolution<\/strong><\/span><\/p>\n 1. Make sure that you have proper user rights to start the database.<\/p>\n 2. Make sure that hostname is defined properly in db2nodes.cfg file.<\/p>\n Navigate to <db2instancename>\/sqllib directory and then edit the db2nodes.cfg file with proper hostname.<\/p>\n [root@<hostname> adm]# cd \/home\/<db2instancename>\/sqllib\/ Make sure that the hostname is defined within 0 & 0. Dont delete the zeroes over there and edit the file with proper hostname. If FQDN is used as hostname, make sure that the same is used in the config file.<\/p>\n example: if my hostname is pi.middlewareprimer.com then your db2nodes.cfg file should have as below,<\/p>\n 0 pi.middlewareprimer.com 0<\/p>\n After editing the file, it resolved the issue and I was able to start the database.<\/p>\n IBM Technotes for reference,<\/p>\n http:\/\/www-01.ibm.com\/support\/docview.wss?uid=swg21221940<\/a><\/p>\n
\n[root@<hostname> sqllib]# vi db2nodes.cfg<\/p>\n