IBM Db2 11.1 Certification Guide

The REBIND Utility

This utility command can be used to recreate a package stored in the database without the need for a bind file. The basic command syntax for REBIND is this:

    REBIND <PACKAGE> [PackageName] <VERSION [VersionID]> <APREUSE [YES | NO]>
    <RESOLVE [ANY | CONSERVATIVE]> 
    <REOPT [NONE | ONCE | ALWAYS] >
  

Consider the following:

• PackageName: Identifies the name to assign to the package to rebind
• VersionID: Identifies a specific version of the package to be rebound

If you want to REBIND the package DEMO.PACKAGE to the database, you can use the following command:

    REBIND PACKAGE demo.package;

If you create any new indexes in a table that the DEMO.PACKAGE relies on, you should rebind the package to make use of the newly created indexes. ...