IBM Support

Ports That Must Be Open to Make an ODBC, Data Transfer, OLE DB, ADO.Net, or JDBC Connection through a Firewall

Troubleshooting


Problem

This document contains a list of TCP/IP ports must be open to make a connection to the database host server through a firewall.

Diagnosing The Problem

Execute the command:
NETSTAT *CNN
...and then <F15> to Subset the connection list. Set the 3rd and 4th parameters:
Local port range:                     
  Lower value  . . . . . . . .   8470 
  Upper value  . . . . . . . .   8476 
Note the "Idle Time" on each of the listening ports. When the IBM i receives a SYN frame on one of those ports, the idle timer is reset.
Executing cwbping (ACS Windows and Linux application packages) or the IBM Toolbox for java utilities.JPing against the IBM i in question will cause the idle timers to be reset. If they are not reset, then the SYN packets never made it to the IBM i.

Resolving The Problem

The following is a list of standard ports that will be used for a standard internet (TCP/IP) or TLS (Transaction Layer Security) connection from clients that use the database host server (ODBC, JDBC, OLE DB, ADO.Net and data transfer). The following functions may be used depending upon the client and whether conversion tables need to be added: Server Mapper, License Management, Sign-On Verification, Database Access.
 
PC Function Port (non-TLS) TLS Port
Server Mapper 449 449
License Management (see Note) 8470 9470
RPC/DPC (Remote Command) 8475 9475
Sign-On Verification 8476 9476
Database Access 8471 9471

Note: License Management is required for data transfer.

These port numbers (other than the Server Mapper) can be configured and, while the defaults are listed above, the actual values on a system may vary. The ports are retrieved from the service table. Determine these ports using the WRKSRVTBLE command on the system in question to determine if the ports have been modified from the default values.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHZAA2","label":"Data Access"}],"ARM Case Number":"TS007707636","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]

Historical Number

553811727

Document Information

Modified date:
22 December 2021

UID

nas8N1012436