DB2 iSeries

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

Installation Steps

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

Post-installation Configuration

ODBC Data Source Configuration:

1. Access the ODBC Data Source Administrator by navigating through Control Panel > Administrative Tools > ODBC Data Sources (64-bit).
2. In the System DSN tab, click on Add to initiate the creation of a new data source. )Click the Add button to display the 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:
   1. Data source name – Enter any unique name to identify the ODBC data source. 
   2. System – Enter the hostname where LMi resides.
      
   3. 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
   4. Click OK.
5. 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.
      
   6. Click OK.
6. 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.

Finally, this is what we will see:

Setting up IBM Iseries Metadata Source in Octopai Client

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