Identifying invalidated packages
You can identify packages that will become invalidated when certain changes are made to objects.
About this task
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