Home > IT Answers > Capture Port connections on iSeries
Bggas400
160 pts.
 Capture Port connections on iSeries
AS400 iseries, JDBC AS400, iSeries connections
Hello, I am in need of some monitoring. I need to know all JDBC / ODBC connections coming into our iSeries on Port 9471 (Database Access – SSL). Does anyone know of any way to capture this info? Thanks for any assistance! bgg

ASKED: Feb 9, 2012  3:47 PM GMT
UPDATED: February 27, 2012  9:06:27 PM GMT
RELATED QUESTIONS
Bggas400
160 pts.
Answer Wiki:
Last Wiki Answer Submitted:  Feb 9, 2012  3:47 PM (GMT)  by  Bggas400   160 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

At i 7.1, I suppose you could use the Sockets accept() API Exit Program.

More likely, though, you’d want the QIBM_QZDA_INIT exit point. When the connection is made, your exit program will be called. Your exit program would call the List Network Connections (QtocLstNetCnn) API to list connections using port 9471. You can then call the Retrieve Network Connection Data (QtocRtvNetCnnDta) API for those connections to see if any return the name of the current job of your exit program.

Not very straightforward, but it’s a pretty specific request you’re after.

Tom

TomLiotta
 66,925 pts.
 

Thanks Tom… should have mentioned but we’re not quite at 7.1.

Bggas400
 160 pts.
 

Then your most direct path is the QIBM_QZDA_INIT exit point program.

Tom

TomLiotta
 66,925 pts.