Qlik Replicate Source IBM DB2 for iSeries port connection

[lguevara]

Hi,
I have a connection source in replicate using IBM DB2 for iSeries, and use these connection properties with IP address,
Is posible configure the IP address and especified a port number to connection?

thanks,

[john_wang]

Hello @lguevara ,

Yes, you can connect to DB2 for iSeries using either the hostname or the IP address.

As for the port number — on a typical AS/400 (IBM i) system, the port is fixed and managed by the system, which is different from most other RDBMS platforms. Therefore, you typically do not need to specify a port number explicitly when connecting.

A sample:

Hope this helps.

John.

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[lguevara]

HI @john_wang ,

In this case environment production DB2 for iSeries use another port.
Is there any way to configure the port on the connection?

thanks,

[john_wang · Accepted solution]

Hello @lguevara ,

The port number for DB2 on iSeries is fixed by default, and I’m not aware of any systems configured to use a different port - unless SSL is enabled, in which case a separate port may be used.

See IBM Docs port numbers which are used in DB400.

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

Regards,

John.

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[lguevara]

Hi @john_wang,

Perhaps it's another reason.
I want to validate the connection from the Linux server that has IBM-iAccess configured.
How do I build a connection string to IBM DB2 for iSeries, or how does Qlik Replicate create this connection string?

thanks,

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[john_wang]

Hello @lguevara ,

Could you please elaborate on the system setup and the port numbers being used?

Regarding Qlik Replicate, it can either generate the connection string automatically or use an existing 64-bit ODBC DSN. You may configure an ODBC DSN and test the connectivity using "isql". If the connection is successful, you can then use the same DSN in Replicate.

Regards,

John.