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.