CONNX Data Integration Suite 14.8.0 | Operations Guide | Working with Database Objects in CONNX | CONNX and DB2 | Import and Connect-Time Security Requirements
 
Import and Connect-Time Security Requirements
Security must be established before connection can be made to any of the DB2 databases used by CONNX.
DB2/400 CDD Import Security Requirements: Access to QSYS2 metadata
During CONNX import procedures, your user ID requires read-only (SELECT) access to the following metadata views:
*QSYS2.SYSCOLUMNS
*QSYS2.SYSTABLES
*QSYS2.SYSPROCS
*QSYS2.SYSINDEXES
*QSYS2.SYSKEYS
*QSYS2.SYSPACKAGE
*QSYS2.SYSPARMS