DB2 UDB Dynamic SQL Package Security
To build the dynamic SQL packages required by CONNX and DB2, your UDB user ID requires write access to the target schema (default = NULLID), plus the Create Package and GRANT privileges. The last step in the package-building logic is
GRANT execute to schema.CONX???? to PUBLIC
where
schema is the target schema (default = NULLID)
???? is the package suffix as documented in CONNX Db2 Dynamic SQL Packages.
The default administrator ID created during the DB2 UDB 5.x and 6.x installation process (db2admin) has the required authority.