Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bediehau
Partner
Partner

How to use the native IBM DB2 connector in Qlik Sense to connect to DB2 on iSeries

In the latest versions of Qlik Sense, a native connector for IBM DB2 is included.

I have been unsuccessful in making it work.

The 50000 port does not work with DB2/400, but I haven't been able to figure out which port to use.

I would love to get rid of the OLEDB and ODBC drivers from client access as they are such a hassle.

Does anyone know if and how they can be used?

Or is this only for Universal DB2 (Linux, Windows, ...)

Rob?

Many thanks.

1 Solution

Accepted Solutions
rawoeste
Contributor II
Contributor II

I've set up the connector with our V7R1 and it seems to work just fine ... (not as fast as the client access-driver though).

This documentation did help me... the port number in particular

IBM Test connect to DB2 AS/400 suing Data Direct ODBC Driver fails - United States

View solution in original post

5 Replies
isainfissi
Contributor
Contributor

I also tried witouth success.

Anyway i found this information.

From here:

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Introduction/ODBC-conn...

you can see that only the latest versions of DB2 are compatible: 10.5, 10.1, 9.5.

In client acces, from command line you can display the release version of DB2 with these command:

GO LICPGM.

option 10 - Display installed licensed programs.

hen the list of programs appears, press F11

And if you want to see the open port in AS400 you can use the command WRKSRVTBLE.

bediehau
Partner
Partner
Author

The current and latest release of IBM i is V7R3. DB2 has the same release version.

So it seems that this is only for UDB, or as it is now called DB2 LUW (Linux, Unix, Windows) - often pronounced 'DB2 love'.

Well, it looks like we're stuck with ODBC/OLEDB for a while longer...

rawoeste
Contributor II
Contributor II

I've set up the connector with our V7R1 and it seems to work just fine ... (not as fast as the client access-driver though).

This documentation did help me... the port number in particular

IBM Test connect to DB2 AS/400 suing Data Direct ODBC Driver fails - United States

View solution in original post

bediehau
Partner
Partner
Author

What configuration did you use exactly?

I just followed the information in the document, and that showed me port 446.
The ping and telnet showed me it was reachable and open.

But configuring the IBM DB2 with the data connector that is included with Sense April 2018, using that specific port number ends up in time-out.

I tried both with and without explicitly naming the database.

IBM DB2 connection.png

bediehau
Partner
Partner
Author

wait up!

after repeatedly trying, it now works...

not sure if it will be very reliable though.

But saying it is slow, that is just being polite...
Although that may be related to how many resources the DRDA has been given access on the iSeries.