Cleans up DB2 catalog2017-01-19T11:42:04+00:00

Cleans up DB2 catalog

How to keep a clean and efficient DB2 catalog

Your needs

Packages, a new bind enhancement introduced in DB2* V2.3, provides the binding flexibility customers have been demanding for many years. Binding a package converts the pre-compiler DBRM into the DB2 interpretable format. The output unit of the BIND is called a package. A consistency token is copied from the DBRM to the package at this point. At execution time, this consistency token is checked against the consistency token of the load module.
Although packages were introduced many years ago, the problems of LOADLIB / DBRM and DB2 Package Management are not addressed by any standard DB2 utilities. In most enterprises, the problems remain totally unsolved or have been partially solved for internal use-only.


  • Cleans up the DB2 Catalog by discarding non-required packages.

  • Avoids all -805 / -818 potential problems by determining “inconsistency“ between DBRMs, packages and load modules.

  • Cleans up all “explain” tables for all users.


  • Eliminates superfluous DB2 collection package versions with no matching load module / CONTOKEN.


  • Detects DBRMs with no current DB2 package version, DBRMs with no valid executable load
    module and DB2 load modules without matching DBRM / package versions.

  • Create DBRM members or libraries from Catalog packages.
  • BIND Avoidance feature that test if a BIND is required by comparing the new DBRM to its last version.

What you can do