Identifying invalidated packages

You can identify packages that will become invalidated when certain changes are made to objects.

About this task

Certain changes to objects invalidate packages. By identifying these invalidated packages before you make the changes, you can prepare necessary rebind operations accordingly.

Procedure

To identify all packages that will be invalidated by a change to a specific object, run the following query:

SELECT   DISTINCT DCOLLID, DNAME, DTYPE
FROM     SYSIBM.SYSPACKDEP
WHERE    BQUALIFIER = object_qualifier
  AND    BNAME      = object_name
  AND    BTYPE      = object_type
ORDER BY DCOLLID, DNAME;

object_qualifier: The qualifier of the object
object_name: The name of the object
object_type: The type of object

Results

The query returns a table that contains package information based on the selected values in the query. For details about the selected values, see SYSPACKDEP catalog table.