---
title: "Connecting to IBM DB2"
description: "In order to connect Ignition to IBM DB2 you must have a Translator, a Driver, and a Database Connection."
---

# Connecting to IBM DB2

> In order to connect Ignition to IBM DB2 you must have a Translator, a Driver, and a Database Connection.

## IBM DB2 Connection Requirements 

The Translator and Driver only need to be configured once. You can make as many connections as you want to any compatible IBM DB2 database.

## Connect to IBM DB2

1. On the Gateway Webpage, go to the **Connections** section.
2. Select **Databases > Connections**.

    ![" "](ibmDatabases-Connections.png)

3. The Database Connections page is displayed. Click on **Create Database Connection +**

    ![" "](ibmCreate-New-Database-Connections.png)

4. Select the **IBM DB2** JDBC Driver from the Driver Selection tab, and click **Next**.

    ![" "](ibmDriver.png)

    :::note
    For more information, see [JDBC Drivers and Translators](platform\database-connections\connecting-to-databases\jdbc-drivers-and-translators\jdbc-drivers-and-translators.md#common-third-party-drivers) for instructions on obtaining the requisite JAR file, and then follow the steps for [Upgrading a JDBC Driver](platform\database-connections\connecting-to-databases\jdbc-drivers-and-translators\jdbc-drivers-and-translators.md#upgrade-a-jdbc-driver) before continuing with these instructions.
    :::

5. On the Database Setup tab, enter the following information:
   * Name: **IBM_DB2**
   * Username: **your_username** 
   * Password: Select your password type, and fill in as needed.
   * Connect URL: **jdbc:db2://localhost:25000/SAMPLE** 

    :::info
    If on Db2 Version 11.5.5 and older, the default port number is 50000.
    If on Db2 Version 11.5.6 and newer, the default port number is 25000.
    :::

![" "](ibmUsername-Password.png)

6. At the bottom of the Create Database Connection window, click **Create Database Connection**. 
Your connection is now created. The Database Connections page is displayed and will show the status of Reconnecting, then Valid.

![" "](ibmConnection-Success.png)

## Troubleshooting
### Troubleshooting Tools

[IBM DOC - Troubleshooting Tools](https://www.ibm.com/docs/en/db2/11.5?topic=techniques-troubleshooting-tools)

### Installation Issues

DB2 installation fails to create instance and DAS: [IBM DOC - DB2 installation fails to create instance and DAS](https://www.ibm.com/support/pages/db2-installation-fails-create-instance-and-das)

### Other Issues

|Error Code|Error Description|Resources|
|---|---|---|
|SQL30081N|Various TCP/IP communication errors. Each error has its own definition and action plan.|[SQL30081N TCP/IP communication errors](https://www.ibm.com/docs/en/db2/11.5?topic=errors-sql30081n-tcpip-communication)|
|SQL1092N|“USERID does not have the authority to perform the requested command or operation”|[SQL1092N Error](https://www.ibm.com/docs/en/baw/19.x?topic=tic-db2-log-file-error-sql1092n-userid-does-not-have-authority-perform-requested-command-operation)|  

## JDBC Drivers and Translators

In some cases, you may need to add your own JDBC Driver, or configure a Translator. More information on configuring these can be found on the [JDBC Drivers and Translators](platform\database-connections\connecting-to-databases\jdbc-drivers-and-translators\jdbc-drivers-and-translators.md) page. However, you may need to check the JDBC driver's documentation for information on how to configure them.