Connect AS400 through firewall(JDBC will require ports: 449, 8470, 8471, and 8476)
What TCP ports are used by ODBC to connect to the DB2/400? 8471/9471
http://search400.techtarget.com/answer/What-TCP-ports-are-used-by-ODBC-to-connect-to-the-DB2-400
Windows: netstat
AS400:NETSTAT *CNN
enter Shift + F2
TCP/IP Ports Required for Access for Windows and Related Functions
http://www-01.ibm.com/support/docview.wss?uid=nas8N1019667
Server ports used
http://www-03.ibm.com/systems/power/software/i/toolbox/faq/ports.html
iSeries
Access Through a Firewall
http://www.mcpressonline.com/security/ibm-i-os400-i5os/iseries-access-through-a-firewall.html
http://www.jguru.com/faq/view.jsp?EID=799495
Start Host Server (STRHOSTSVR)Start Host Server (STRHOSTSVR)Start Host Server (STRHOSTSVR)Start Host Server (STRHOSTSVR)
http://www-01.ibm.com/support/knowledgecenter/#!/ssw_ibm_i_71/cl/strhostsvr.htm
STRHOSTSVR *ALL
*CENTRAL
*DATABASE
*DTAQ
*FILE
*NETPRT
*RMTCMD
*SIGNON
*SVRMAP
WRKACTJOB SBS(QSERVER)
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Frzaii%2Frzaiistrhostsvrex.htm
You can use the WRKSRVTBLE command to display the service names and their associated port numbers.
+--------------------------------------------------------------------------------+
| Work with Service Table Entries |
| System: AS400597 |
| Type options, press Enter. |
| 1=Add 4=Remove 5=Display |
| |
| Opt Service Port Protocol |
| _ _______________________________ ____________ _________________________ |
| _ as-central 8470 tcp |
| _ as-database 8471 tcp |
| _ as-dtaq 8472 tcp |
| _ as-file 8473 tcp |
| _ as-netprt 8474 tcp |
| _ as-rmtcmd 8475 tcp |
| _ as-signon 8476 tcp |
| _ as-svrmap 449 tcp |
| . |
| . |
| . |
| |
+--------------------------------------------------------------------------------+
