title: AS/400 DDM service not running
body: <p>I wanted to make a ODBC connection from Windows PC to AS/400 DB2 server and I wrote a VBA program. But I got the following error. </p>
  
  <pre><code>Remote port could not be resolved
  </code></pre>
  
  <p>Then, I checked the status of server with <strong><code>CWSPING</code></strong> and got the result below:</p>
  
  <pre><code>I - Verifying connection to system 192.168.1.2...
  I - Successfully connected to server application: Central Client
  I - Successfully connected to server application: Network File
  I - Successfully connected to server application: Network Print
  I - Successfully connected to server application: Data Access
  I - Successfully connected to server application: Data Queues
  I - Successfully connected to server application: Remote Command
  I - Successfully connected to server application: Security
  E - CWBCO1011 - Remote port could not be resolved
  E - CWBCO1008 - Unable to connect to server application DDM, returned 8407
  I - Successfully connected to server application: Telnet
  W - CWBCO1015 - Connection verified to system 192.168.1.2, but there were warnings
  </code></pre>
  
  <p>This means <code>DDM</code> service is not working on the server. ODBC connection requires <code>DRDA</code>, which runs upon <code>DDM</code> service, so I think running <code>DDM</code> service is the key to make ODBC connection. So I tried <strong><code>STRTCPSVR *DDM</code></strong> command but got the result below</p>
  
  <pre><code>*DDM not valid for parameter SERVER
  </code></pre>
  
  <p>And also tried <strong><code>CHGDDMTCPA  AUTOSTART(*YES)  PWDRQD(*YES)</code></strong> command, but got an error and I got stuck.</p>
  
  <pre><code>Command CHGDDMTCPA in library *LIBL not found
  </code></pre>
  
  <p>Does anyone have an idea of enabling <code>DDM</code> server on AS400?</p>
  
  <ul>
  <li>Server: IBM AS400</li>
  <li>OS version: V4R1</li>
  </ul>