Catalog Source Configuration > IBM Db2 for LUW
  

IBM Db2 for LUW

IBM Db2 for LUW is a relational database management system (RDBMS) designed by IBM to store, analyze, and retrieve data from for Windows, Linux and Unix operating systems.
Configure an IBM Db2 for LUW catalog source to extract metadata from an IBM Db2 for LUW database hosted on a dedicated server, or from an Amazon RDS for Db2 database.

Objects extracted

The metadata extraction service extracts the following objects from an IBM Db2 for LUW source system:
Note: To extract the following schemas, you must define include filters:

Prerequisites for configuring the IBM Db2 for LUW catalog source

Use the Db2 for LUW Database Ingestion connector to connect to IBM Db2 for LUW source system. For information about configuring a connection in Administrator, see Connections in the Cloud Common Services help.

Configure permissions or access to IBM Db2 for LUW

This section addresses permissions for configuring IBM Db2 for LUW connection. The following table lists the schema objects and system tables on which you configure SELECT permissions for the IBM Db2 for LUW database user account:
Schema Objects
System Tables
  • - Tables
  • - Views
  • - Procedures
  • - Functions
  • - Databases
  • - select on syscat.COLUMNS
  • - select on syscat.FUNCTIONS
  • - select on syscat.NICKNAMES
  • - select on syscat.PROCEDURES
  • - select on syscat.PROCPARMS
  • - select on syscat.TABLES
  • - select on syscat.VIEWS
  • - select on syscat.SCHEMATA
  • - select on syscat.TABCONST
  • - select on syscat.REFERENCES
  • - select on syscat.KEYCOLUSE

Data classification for IBM Db2 for LUW objects

Configure data classification for IBM Db2 for LUW catalog sources to classify and organize data in your organization. You can view the data classification results in Data Governance and Catalog.

Connection properties

When you configure a connection to the IBM Db2 for LUW source system in Administrator, you can view the connection properties for that connection on the Registration page in Metadata Command Center.
The following table describes the IBM Db2 for LUW connection properties:
Property
Description
Connection Name
Name of the connection.
Type
Type of connection. Select Db2 for LUW Database Ingestion from the list.
Runtime Environment
The execution platform that runs tasks. The runtime environment is either a Secure Agent or a serverless runtime environment.
User Name
The name of the user account that connects to IBM Db2 for LUW database.
Password
The password to use for connecting to IBM Db2 for LUW database.
Host
The fully qualified host name of the machine where IBM Db2 for LUW database is hosted.
Port
The port number for the IBM Db2 for LUW database.
Database Name
TheIBM Db2 for LUW database name that is used to access metadata.
Advanced Connection Properties
Advanced properties for the Progress DataDirect JDBC DB2 driver that you use to connect to the IBM Db2 for LUW source system.
You can specify the following advanced connection properties:
  • - Specify the path to the SSL certificate. For example, EncryptionMethod=SSL;TrustStore=/data/sslCertificates/DB2_ssl/mydbserverssl.jks;TrustStorePassword=Infa@123.
  • - If you enable credential protection without enabling full encryption, specify the following property: AuthenticationMethod=encryptedUIDPassword
    • Note: If you don't specify the property, Test Connection fails.
  • - If you use an Amazon RDS for Db2 database, specify the following properties: EncryptionMethod=requestDBEncryption;AuthenticationMethod=encryptedUIDPassword
    • Note: If you don't specify the properties, Test Connection fails.

Referenced source systems

If the source system references another source system, create a connection assignment in Metadata Command Center to view data lineage with endpoints. To create a connection assignment, create a connection based on the referenced source system, and then assign the connection to the catalog source.
Note: You can view the lineage with reference objects without creating a connection assignment. After connection assignment, you can view the actual objects.
You can assign an IBM Db2 for LUW source system as a referenced source system. To create a connection assignment, the catalog source must belong to the Schema class type.

Data Profiling for IBM Db2 for LUW

You can run data profiles and data quality tasks for IBM Db2 for LUW assets. Configure data profiling to run profiles on the metadata extracted from an IBM Db2 for LUW source system. You can view the profiling statistics in Data Governance and Catalog.
You can run data profiles on the following IBM Db2 for LUW objects:
Sampling type
Determine the sample rows on which you want to run the data profiling task.
You can choose one of the following sampling types for an IBM Db2 for LUW catalog source:
Data types
The data profiling task runs profiles on the following data types: