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 a

 

GRANT execute to schema.CONX???? to PUBLIC

where

schema is the target schema (default = NULLID)

???? is the package suffix as documented in CONNX and 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.