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:
- 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.
- Select Find Invalid Packages. A list of invalid
packages is displayed.
- Select one or more packages that you want to rebind and
click Next.
- 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.
- Click Finish to rebind the package.