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
------------------------------

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
------------------------------

Original Message:
Sent: Thu September 10, 2020 12:11 PM
From: nick jones
Subject: ports used

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
------------------------------

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
------------------------------

Original Message:
Sent: Fri September 11, 2020 08:13 AM
From: Dev Banerjee
Subject: ports used

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

Original Message:
Sent: Thu September 10, 2020 12:11 PM
From: nick jones
Subject: ports used

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
------------------------------

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
------------------------------

Original Message:
Sent: Fri September 11, 2020 08:58 PM
From: nick jones
Subject: ports used

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

Original Message:
Sent: Fri September 11, 2020 08:13 AM
From: Dev Banerjee
Subject: ports used

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

Original Message:
Sent: Thu September 10, 2020 12:11 PM
From: nick jones
Subject: ports used

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
------------------------------

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
------------------------------

Original Message:
Sent: Mon September 14, 2020 08:04 AM
From: Dev Banerjee
Subject: ports used

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

Original Message:
Sent: Fri September 11, 2020 08:58 PM
From: nick jones
Subject: ports used

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

Original Message:
Sent: Fri September 11, 2020 08:13 AM
From: Dev Banerjee
Subject: ports used

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

Original Message:
Sent: Thu September 10, 2020 12:11 PM
From: nick jones
Subject: ports used

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
------------------------------

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
------------------------------

Original Message:
Sent: Mon September 14, 2020 08:12 AM
From: nick jones
Subject: ports used

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

Original Message:
Sent: Mon September 14, 2020 08:04 AM
From: Dev Banerjee
Subject: ports used

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

Original Message:
Sent: Fri September 11, 2020 08:58 PM
From: nick jones
Subject: ports used

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

Original Message:
Sent: Fri September 11, 2020 08:13 AM
From: Dev Banerjee
Subject: ports used

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

Original Message:
Sent: Thu September 10, 2020 12:11 PM
From: nick jones
Subject: ports used

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
------------------------------

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
------------------------------

Original Message:
Sent: Mon September 14, 2020 10:23 AM
From: Dev Banerjee
Subject: ports used

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

Original Message:
Sent: Mon September 14, 2020 08:12 AM
From: nick jones
Subject: ports used

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

Original Message:
Sent: Mon September 14, 2020 08:04 AM
From: Dev Banerjee
Subject: ports used

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

Original Message:
Sent: Fri September 11, 2020 08:58 PM
From: nick jones
Subject: ports used

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

Original Message:
Sent: Fri September 11, 2020 08:13 AM
From: Dev Banerjee
Subject: ports used

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

Original Message:
Sent: Thu September 10, 2020 12:11 PM
From: nick jones
Subject: ports used

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
------------------------------

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
------------------------------

Original Message:
Sent: Mon September 14, 2020 10:40 AM
From: nick jones
Subject: ports used

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

Original Message:
Sent: Mon September 14, 2020 10:23 AM
From: Dev Banerjee
Subject: ports used

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

Original Message:
Sent: Mon September 14, 2020 08:12 AM
From: nick jones
Subject: ports used

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

Original Message:
Sent: Mon September 14, 2020 08:04 AM
From: Dev Banerjee
Subject: ports used

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

Original Message:
Sent: Fri September 11, 2020 08:58 PM
From: nick jones
Subject: ports used

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

Original Message:
Sent: Fri September 11, 2020 08:13 AM
From: Dev Banerjee
Subject: ports used

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

Original Message:
Sent: Thu September 10, 2020 12:11 PM
From: nick jones
Subject: ports used

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
------------------------------