StarQuest Technical Documents

How to Enable DRDA over TCP/IP for OS/400 V4R2 and later

Last Update: 26 June 2008
Product: StarSQL
Versions: 5.x
Article ID: SQV00SQ020


This technical document explains how to configure your AS/400 to accept DRDA requesters, such as StarSQL, over TCP/IP.


To configure the DDM TCP/IP server:

  1. Logon to your AS/400.
  2. Change the DDM TCP/IP Attributes to autostart using the command:


  3. Start TCPIP DDM Server using the command:


To verify which port your AS/400 is listening for remote DRDA requests:

  1. Logon to your AS/400.
  2. Work with service table entries using this command:


  3. Look for the DRDA entry with the port number 446.

Or, you can also use the following commands:

  1. Work with TCPIP status using the command:


  2. Choose option 3, "Work with TCP/IP connection status".
  3. Find the entry with port "drda" and press "F14=Display port numbers".


The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization.  The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.