DB2 and DB2 for MVS CDD Import Security Requirements

CONNX Data Integration Suite 14.7.0 | Operations Guide | Working with Database Objects in CONNX | CONNX and DB2 | DB2 and DB2 for MVS CDD Import Security Requirements

During CONNX import procedures, your user ID requires read-only (SELECT) access to the following system metadata views:

SYSIBM.SYSTABLES

SYSIBM.SYSPROCEDURES

SYSIBM.SYSINDEXES

SYSIBM.SYSKEYS

SYSIBM.SYSPACKAGE

SYSIBM.SYSROUTINES

SYSIBM.SYSPARMS

To retrieve column descriptor information for tables and views, your user ID must be authorized to issue a DYNAMIC PREPARE of the following SQL statement:

SELECT * from owner.table

where owner.table is the table/view selected for importing into the CDD.