tag:blogger.com,1999:blog-6666038.post-23268541895595875712007-11-14T12:00:00.001-05:002007-11-14T12:00:02.130-05:00<p>When you create an instance using db2icrt you may not have the TCP/IP portion automatically enabled.&nbsp; To enable it type in the following in your DB2 command prompt:</p> <p><tt>db2set DB2COMM=TCPIP<br></tt><tt>db2 update dbm cfg using SVCENAME db2c_DB2</tt></p> <p>Make sure you have the following line in your etc\services file.&nbsp; The db2c_DB2 corresponds to the one on the update dbm cfg.</p> <p><tt>db2c_DB2 50000/tcp</tt></p> <p>Then restart your database instance.&nbsp; If all goes well you should see</p> <blockquote> <p>SQL1063N&nbsp; DB2START processing was successful.</p></blockquote> <p>If not you may see</p> <blockquote> <p>SQL5043N&nbsp; Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully. </p></blockquote> <p>I sometimes have to use db2icrt because sometimes my laptop crashes and the DB2 instance gets corrupted to the point that it is no longer recoverable.</p> Archimedes Trajanohttp://www.blogger.com/profile/15993184075121538415noreply@blogger.com