DB2 UDB for Windows and Linux CDD Import Security Requirements
During CONNX import procedures, your user ID requires read-only (SELECT) access to the following system metadata views:
SYSCAT.INDEXES
SYSCAT.PACKAGES
SYSCAT.PROCEDURES
SYSCAT.PROCPARMS
SYSCAT.TABLES
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 schema.table
where schema.table is the table/view you are importing into the CDD.