Db2 and Db2 for z/OS 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.