Creating an IBM Db2 integration

  The IBM Db2 integration is available only for technology preview, and is not for production usage.

Adding an IBM® Db2® integration enables your organization to store incident data in a Db2 database. The incident data can then be included in custom dashboards and reports that are created in IBM Cognos® Analytics.

Prerequisites

You need the following information to create an IBM Db2 integration:

  • Data source type
  • Name of the IBM Db2 database
  • Hostname or IP address at the database
  • Port number for incoming client connections
  • Username and password to access the database

Note: The IBM Db2 integration is only supported on Red Hat® OpenShift® Container Platform clusters. IBM Db2 integration is not supported on IBM Cloud Pak for AIOps on Linux.

Creating an IBM Db2 integration

To create an IBM Db2 integration, complete the following steps:

  1. Log in to IBM Cloud Pak for AIOps console.

  2. Expand the navigation menu (four horizontal bars), then click Define > Integrations.

  3. On the Integrations page, click Add integration.

  4. From the list of available integrations, find and click the IBM Db2 tile.

  5. On the side-panel, review the instructions and when ready to continue, click Get started.

  6. On the Add integration page, define the general integration details:

    • Name: The display name of your integration. You cannot use spaces or special characters in the display name. Use only alphanumeric characters.

    • Description (optional): Optionally, enter a description of the integration.

    • Data source type: From the drop-down menu, select the type of IBM Db2 database.

    • Database hostname or IP address: Enter the fully qualified hostname or IP address of the IBM Db2 database, for example, myserver.abc.com or 192.0.2.24.

    • Database port (1024 - 65535): Enter the database port number.

    • Database name: Enter the name of the IBM Db2 database.

      IBM Db2 integration
      Figure. Add IBM Db2 integration

    • Username: Enter the username to access the IBM Db2 database.

    • Password: Enter the password for the IBM Db2 database username.

    • Schema qualifier (optional): Enter the schema qualifier for the database objects to be accessed. If blank, the username is used.

    • Maximum pool size (0 - 100000): Enter the maximum number of connections allowed within a single connection pool. The default value is 0, which indicates that connection pooling is switched off for the integration server.

    • Additional database parameters (optional): Enter additional database parameters in the format name1=value1;name2=value2.

      IBM Db2 integration
      Figure. Add IBM Db2 integration

  7. Click Done. You are redirected to the IBM Db2 integration page.

    Your new integration is listed in the table on the page. The integration has an initial status of Initializing. After a few minutes, the status changes to Running if your integration is successful.

Create a policy to populate a dashboard or report

Once an IBM Db2 integration is set up and running, you can create a policy to send alerts or incidents from Cloud Pak for AIOps to populate a dashboard or report in IBM Cognos® Analytics. For more information, see Populate a dashboard or report.

Editing an IBM Db2 integration

After you create your integration, you can edit the integration. To edit an integration, complete the following steps:

  1. Log in to IBM Cloud Pak for AIOps console.

  2. Expand the navigation menu (four horizontal bars), then click Define > Integrations.

  3. Click the IBM Db2 integration type on the Manage integrations tab of the Integrations page.

  4. On the IBM Db2 integration page, click the name of the integration that you want to edit. Alternatively, you can click the options menu (three vertical dots) for the integration and click Edit. The integration configuration opens.

  5. Edit your integration as required. Click Save when you are done editing.

Your integration is now edited.

Deleting an IBM Db2 integration

If you no longer need your integration and want to delete it entirely, you can delete the integration from the console.

To delete an integration, complete the following steps:

  1. Log in to IBM Cloud Pak for AIOps console.

  2. Expand the navigation menu (four horizontal bars), then click Define > Integrations.

  3. Click the IBM Db2 integration type on the Manage integrations tab of the Integrations page.

  4. On the IBM Db2 integrations page, click the Delete icon for the integration that you want to delete.

  5. Enter the name of the integration to confirm that you want to delete your integration. Then, click Delete.

    Your integration is deleted in IBM Cloud Pak for AIOps.