IBM Db2 is a relational database management system for enterprise-level data warehouse management, analytics, and transactional workloads. Db2 uses SQL for database updating and retrieval. Integrate Validio with your Db2 database to monitor, analyze, and validate your data assets.

To integrate with IBM Db2,

1. Create a service account in Db2 with the appropriate permissions for Validio. See Prerequisites.
2. Create a Validio credential to connect to the service account. See Add an IBM Db2 Credential.
3. Create a Validio source to monitor the tables in the Db2 database. See Add an IBM Db2 Source.

Prerequisites

Create a service account in Db2 with the appropriate permissions for Validio to read and validate your data. For more information about credentials in Validio, see Credentials.

The following SQL script provides steps for setting up a user with the necessary permissions for the source in Validio. Copy the script into a SQL worksheet and follow the steps:

-- Create a role.
CREATE ROLE VALIDIO_ROLE;
GRANT ROLE VALIDIO_ROLE TO USER validio_user;

-- Grant access to connect to the database server.
GRANT CONNECT ON DATABASE TO ROLE VALIDIO_ROLE;

-- Grant read access to the following system tables.
-- These permissions are required for Validio catalog functionality.
GRANT SELECTIN ON SCHEMA SYSIBM TO ROLE VALIDIO_ROLE;
GRANT SELECTIN ON SCHEMA SYSCAT TO ROLE VALIDIO_ROLE;

-- For data monitoring and profiling, grant read access to the schemas
-- containing any relevant tables and views.
GRANT SELECTIN ON SCHEMA <myschema> TO ROLE VALIDIO_ROLE;

Add an IBM Db2 Credential

To add a credential for IBM Db2,

1. Navigate to Credentials and click + New Credential.
2. Under Namespace, select a namespace where the resources will be created.
3. For Credential Type, select IBM Db2 Credential.
4. Fill in the credential parameter fields. Refer to the IBM Db2 Credential Parameters table.
5. Check Use for catalog and schema checks to automatically discover credentials and add them to the catalog page.
6. Click Create.

Validio will validate the connection to the Db2 account. If validation passes, Validio will automatically start fetching data. If validation fails, check that you provided the correct parameter values and try again.

Once the credential is created, you can add a source to monitor Db2 data.

IBM Db2 Credential Parameters

Add an IBM Db2 Source

To add a source for IBM Db2,

1. Navigate to Sources and click + New source.
2. Under Source type, select IBM Db2.
3. Under Config,
   1. Select the valid Credential or create a new credential to authenticate your connection to the data warehouse.
   2. You have two options for specifying the dataset and tables to monitor:
      1. Select an existing table -- Enter the Database, Schema, and Table to specify where the data comes from. Selecting more than one table will create a new source for each table. Refer to the Source Configuration Parameters table.
      2. Use Custom SQL -- Write a valid SQL query to specify the tables to monitor.
   3. Set the Polling schedule, which is how frequently the validators on the source will check for changes.
4. Under Schema, click Continue to automatically infer the schema fields from the tables you selected. If you select many tables, this operation can take a few minutes to complete.
5. Under Source details,
   1. Add Tags to help group related sources or to use for routing notifications.
   2. Add an Owner who will be the contact for incident notifications.
   3. Assign a Priority, which indicates the importance of incidents detected on this source.
6. Click Continue to create the source. Source names are generated automatically and will be displayed when the source creation completes. If there are more than 5 sources, you will see the names for the first five and a count of the remaining sources.

IBM Db2 Source Configuration Parameters