Finding invalid DB2 packages

You can find invalid DB2® packages and then rebind them

Before you begin

Be connected to a DB2 database.

About this task

You can list invalid packages at the database level or an individual schema level. You can also find the invalid packages for Users, Groups, and Roles folders, as well as for the individual user, group (if applicable), or role objects within those folders.

Procedure

To find invalid DB2 packages that need to be rebound:

  1. From the Data Source Explorer, right-click on one of the following objects:
    • On Schemas to list all of the packages in the database that are invalid or inoperative.
    • On an individual schema name, such as DB2USER, to list invalid packages for that particular schema.
    • On Users, Groups, or Roles folders as well as an individual user, group (if applicable), or role objects within any of those folders.
  2. Select Find Invalid Packages. A list of invalid packages is displayed.

  3. Select one or more packages that you want to rebind and click Next.
  4. Enter or select any rebind command options for the package in Rebind Options. These options are used to rebind all selected packages. To see a description of the Rebind command options that you can enter in the Rebind Options field:
    • For DB2 V9.7 for Linux, UNIX, and Windows, see the REBIND command to learn what options you can specify.
    • For DB2 V9.1 for z/OS, see the REBIND PACKAGE command to learn what options you can specify.
  5. Click Finish to rebind the package.

Feedback