Create an IBM DB2 connection

To access your data stored on an IBM DB2 database, you will need to know the server and database name that you want to connect to, and you must have access credentials. Once you have created a connection to an IBM DB2 database, you can select data from the available tables and then load that data into your app or document.

In Qlik Sense, you connect to an IBM DB2 database through the Add data dialog or the Data load editor.

In QlikView you connect to an IBM DB2 database through the Edit Script dialog.

Setting up the database properties

Database property Description Required
Host name Host name to identify the location of the IBM DB2 database. yes
Port Server port for the IBM DB2 database. yes
Database The name of the IBM DB2 database. yes

Authenticating the driver

Qlik Sense: IBM DB2 authentication properties

Property Description
Username User name for the IBM DB2 connection.
Password Password for the IBM DB2 connection.
Name

Name of the IBM DB2 connection.

The default name will be used if you do not enter a name.

QlikView: IBM DB2 authentication properties

Property Description
Username User name for the IBM DB2 connection.
Password Password for the IBM DB2 connection.

Miscellaneous properties

Property Description
Query timeout Amount of time before a data load query times out. Can be set from 30 seconds to 65535 seconds. Default = 30 seconds

Using Advanced options

Option Description Required

Name

Name of additional properties.

You can add more than one additional properties.

no
Value

Value of additional properties.

You can add more than one additional properties.

no
When you connect to an IBM DB2 database with the Data load editor or the Edit Script dialog, Test Connection enables you to test the connection before you attempt to create it.

Did this information help you?

Can you tell us why it did not help you and how we can improve it?

Thanks for helping us improve!