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.

Related Information

TCP/IP Ports Required for IBM i Access and Related Functions

[{"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

Was this topic helpful?

Document Information

Modified date:
22 December 2021

UID

nas8N1012436

Tips