Cloudera Docs

DB2 iSeries

Configure Cloudera Octopai Data Lineage to extract metadata from IBM DB2 iSeries, from client setup through ODBC configuration and required permissions.

Tool Permissions Prerequisites

  • Warning: Missing permissions could end up in broken lineages.
  • Microsoft Visual C++ Redistributable 2013 x64: Essential for running applications developed with Visual C++ on Windows systems. Download from this link.
  • IBM i Access Client Solutions: A suite for accessing and managing IBM iSeries systems.
  • Network Configuration: Ensure the server port is open for each DB2 iSeries database connection to facilitate communication.

Configuring ODBC Data Sources for DB2 iSeries

IBM i Access Client Solutions Installation:

  1. Navigate to the IBM website's login page, and log in using your IBM ID and password.
  2. Download the "ACS Windows App Pkg English (64bit)".
  3. Execute the installer located at IBMiAccess_v1r1_WindowsAP_English\Image64a\setup.exe to extract and install the ACS application.

Post-installation Configuration:

  1. Access the ODBC Data Source Administrator by navigating through Control Panel > Administrative Tools > ODBC Data Sources (64-bit).

    ODBC Data Sources (64-bit)

  2. In the System DSN tab, click on Add to initiate the creation of a new data source.

    Create New Data Source dialog

  3. Select iSeries Access ODBC Driver and click the Finish button. The General tab of the IBM i Access for Windows ODBC Setup dialog is displayed.

  4. Recommended Settings for the General tab:

    • Data source name – Enter any unique name to identify the ODBC data source.
    • System – Enter the hostname where LMi resides.
    IBM i Access for Windows ODBC Setup General tab

  5. Click the Connection Options button to display the Connection Options dialog. Recommended settings:

    • Default user ID – Use iSeries Navigator default
    • Sign-on dialog prompting – Prompt for SQL Connect if needed
    • Security – Use the same security as the iSeries Navigator connection

  6. Click OK.

  7. On the IBM i Access for Windows ODBC Setup dialog box, select the Server tab. Recommended settings:

    1. In the Naming convention combo box, select SQL naming convention (*SQL).
    2. Leave Default SQL Schema or Library blank.
    3. Leave the Library list blank.
    4. For the Connection type, select Use ODBC access mode.
    5. Leave Override default database with the following unchecked.
      IBM i Access for Windows ODBC Setup Server tab

    6. Click OK.

  8. On the IBM i Access for Windows ODBC Setup dialog box, select the Packages tab. Packages Tab Adjustment:

    In the Packages tab, it is crucial to ensure the 'Enable Extended Dynamic Support' checkbox is unchecked, deactivating other controls on the page.

    IBM i Access for Windows ODBC Setup Packages tab

Finally, this is what we will see:

ODBC Data Source Administrator final view

Setting up IBM Iseries Metadata Source in Cloudera Octopai Client

First, press "New Metadata Source," then fill in the relevant information for your new connection.

New Metadata Source wizard