IBM DB2 LUW

Learn how to integrate IBM DB2 LUW with Cloudera Data Lineage (formerly Octopai).

Tool Permissions Prerequisites

  • DB2 ODBC driver installed on the machine running the Octopai Client
  • Microsoft Visual C++ Redistributable - Visual Studio 2013 (VC++ 12.0) - 64X, installed on the machine running the Octopai Client
  • Open Server Port for each DB2 Database Connection
  • Existing/New DB2 user(OCTOPAI_USER) for each connection with:
    • Grant connect on DATABASE ;
    • Grant Execute on function SYSPROC.ENV_GET_INST_INFO;
    • Grant Execute on function SYSPROC.MON_GET_CONTAINER;
    • Grant select permission for the following dictionary tables:
      • SYSIBM.SYSTABAUTH;
      • SYSIBM.SYSCOLAUTH;
      • SYSIBM.SYSDBAUTH;
      • SYSIBMADM.DBMCFG;
      • SYSIBMADM.DBCFG;
      • SSYSIBM.SYSDBAUTH;
      • SYSCAT.PACKAGEAUTH;
      • SYSCAT.TBSPACEAUTH;
      • SSYSCAT.DBAUTH;
      • SYSCAT.SEQUENCEAUTH;
      • SYSCAT.INDEXAUTH;
      • SYSCAT.TABLES;
      • SYSIBM.SYSSCHEMAAUTH ;
      • SSYSIBM.SYSTABAUTH;
      • SYSCAT.LIBRARYAUTH;
      • SYSCAT.TABAUTH;
      • SYSIBM.SYSROUTINEAUTH;
      • SYSIBM.ROUTINES;
      • SYSCAT.INDEXES;
      • SSYSCAT.SCHEMAAUTH;
      • SYSCAT.PACKAGES;
      • SYSCAT.VIEWS;
      • SYSCAT.TRIGGERS;
      • SYSCAT.PASSTHRUAUTH;
      • SYSCAT.ROUTINEAUTH;
      • SYSCAT.TABLESPACES;
      • SYSCAT.SEQUENCES;
      • SYSCAT.ROUTINES;
      • SYSCAT.INDEXES;
      • SYSCAT.PACKAGES;
      • SYSCAT.SCHEMATA;
      • SYSCAT.TRIGGERS;
      • SYSCAT.TABLES;
      • SYSCAT.VIEWS;
      • SYSCAT.ROUTINES;

Setting up IBM - DB2 Metadata Source

Metadata Sources are set on the Octopai Client

Figure 1. New Metadata Source Wizard

Verify extraction results

After a successful run, confirm the metadata archive in the target folder. See Verify extracted metadata files.

Troubleshoot

If an error occurs during the extraction, see Troubleshoot connector extraction failures.