StaticBinder utility, as used for client optimization

With the StaticBinder utility, you can create and bind DB2® packages that contain the SQL statements in your pureQueryXML files. You can also choose to create DBRM files that you can later transfer to a z/OS® data set and use to create DB2 packages. XML schema validation can also be performed on the input pureQueryXML files.
The privilege set of the user that invokes the utility must include one of the following authorities:
  • SYSADM authority
  • DBADM authority
  • If the package does not exist, the BINDADD privilege, and one of the following privileges:
    • CREATEIN privilege
    • DB2 for z/OS: PACKADM authority on the collection or on all collections
    • DB2 Database for Linux, UNIX, and Windows: IMPLICIT_SCHEMA authority on the database if the schema name of the package does not exist
  • If the package exists:
    • DB2 for z/OS: The BIND privilege on the package
    • DB2 Database for Linux, UNIX, and Windows: ALTERIN privilege on the schema and BIND privilege on the package
The user also needs all privileges that are required to compile any static SQL statements in the application. Privileges that are granted to groups are not used for authorization checking of static statements.

DB2 Database for Linux, UNIX, and Windows: If the user has SYSADM authority, but no explicit privileges to complete the bind, the DB2 database manager grants explicit DBADM authority automatically.

Usage notes

The following information applies to applications enabled with pureQuery client optimization the run SQL statements statically:

Feedback