EGL Development User Group

  • 1.  ports used

    Posted Thu September 10, 2020 12:12 PM
    can someone tell me what ports/protocols are used when communicating with the iseries (sql statements, program calls, etc).

    ------------------------------
    nick jones
    ams
    englewood cliffs NJ
    ------------------------------


  • 2.  RE: ports used

    InnerCircle
    Posted Fri September 11, 2020 03:04 PM
    Are you trying to connect to iSeries DB2 using  Datasource from RBD client? The properties should be selected when you define a connection. By default the port number is 446.
    and the jdbc connection url comes out to be jdbc:db2://host:446/database:retrieveMessagesFromServerOnGetMessage=true;

    If this does not answer your query, please be specific. What are you trying to do and what is blocking?

    ------------------------------
    Dev Banerjee
    ------------------------------



  • 3.  RE: ports used

    Posted Fri September 11, 2020 08:59 PM
    here is my string:
    jdbc:as400:ibmiseries;prompt=false;naming=system;date format=usa;transaction isolation=none;autocommit=off;

    Here's what happening. We are moving the Tomcat server (9.0) off the iseries to a windows PC located on the DMZ. I was asked which ports/protocols would be needed opened so that the dmz pc can communicate with the iseries (sql  and program calls.).

    I cant find any documenation on what ports/protocols EGL uses.

    Hope that makes sense.

    ------------------------------
    nick jones
    ams
    englewood cliffs NJ
    ------------------------------



  • 4.  RE: ports used

    InnerCircle
    Posted Mon September 14, 2020 08:05 AM
    Let me see if I understand your scenario.
    - you have RBD generated applications deployed on Tomcat
    - previously they were deployed on a Tomcat Server on IBM i, now they are moved to DMZ PC.
    - the applications access datasources that are still on IBM i, so the application need to connect to the IBM i database remotely.
    - IBM i admin need to open up the ports so that they can be accessed.
    - you need to know what ports EGL uses

    If this is correct, be aware that RBD/EGL does not dictate the port numbers, and will use what is configured to it.
    Typically the IBM i port number for sql remote access would be 446, and could be different if secure connection (SSL/TLS) are used.
    IBM i admin would know. Once that is determined, you would configure the DB options for the connection into the build descriptor for the applications.

    If you need more assistance, please open a ticket for RBD support and we will be glad to help.

    ------------------------------
    Dev Banerjee
    ------------------------------



  • 5.  RE: ports used

    Posted Mon September 14, 2020 08:13 AM
    Hello Dev,

    You hit the nail on the head. I am the IBM I admin, but dont know since i never had to consider using anything but defaults. I'm guessing using SSL/TLS will be required between the DMZ pc and the iseries.

    How do i open a ticket? Can you provide a link?

    ------------------------------
    nick jones
    ams
    englewood cliffs NJ
    ------------------------------



  • 6.  RE: ports used

    InnerCircle
    Posted Mon September 14, 2020 10:23 AM
    Hi Nick,
    I think you would open 446 for non-secure db2  access and 448 for SSL encrypted access.
    https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/ddp/rbal1ports.htm    has some relevant info.

    After setting this up, the RBD user must set up the connection properties accordingly.

    Hope this helps.

    ------------------------------
    Dev Banerjee
    ------------------------------



  • 7.  RE: ports used

    Posted Mon September 14, 2020 10:41 AM
    ahh...so it uses ddm? I didnt know that. Never had a reason to open the hood.

    I already had a self cert set up on the iSeries for client access, so i just changed the jdbc connection string as follows:
    sqlValidationConnectionURL="jdbc:as400:ibmiseries;prompt=false;naming=system;libraries=qs36f,files,coll;secure=true;"
    sqlDB="jdbc:as400:ibmiseries;prompt=false;naming=system;date format=usa;transaction isolation=none;autocommit=off;secure=true;"

    That should use the secured port, no?

    Thanks again.

    ------------------------------
    nick jones
    ams
    englewood cliffs NJ
    ------------------------------



  • 8.  RE: ports used

    InnerCircle
    Posted Mon September 14, 2020 11:30 AM
    It looks correct to me. The port used in this case (using jdbc driver from AS/400 Toolbox for Java) should use port 446 and 448 depending on whether secure=true is set. The ports are provided by the PortMapper class

    ------------------------------
    Dev Banerjee
    ------------------------------