RC/Query : DROP IMPACT does not list some PLANS. Why are some PLANS not listed in this report?
Article ID: 25533
Updated On:
Products
Issue/Introduction
Sometimes the DROP Impact Report does not list PLANS that are clearly present in the catalog and associated with the object in question. Why are some PLANS not listed in this report?
Environment
Release: R20
Component: RCQ
Resolution
The DROP IMPACT(DI) command in RC/Query is used to advise the user about the expected catalog impact that a DROP of a given object will have on the dependant objects.
The DI reports only list a PLAN in the report when it has been marked as invalid as per the IBM DB2 Administration Manual. If the plan is bound without packages and a DBRM of the PLAN references a dropped object, then the PLAN will be listed.
If the plan consists of packages then the Plan is never considered invalid when package dependent objects are dropped.
See the DB2 Application Programming and SQL Guide, V12, Section "Automatic rebinding" which contains a list of reasons why Plans and Packages can be marked Invalid and rebound later if autobind is enabled.
See also the DB2 Administration Guide V12, Section Altering your database design.
Attention: The DROP statement has a cascading effect. Objects that are dependent on the dropped object are also dropped. For example, all authorities for those objects disappear, and packages that reference deleted objects are marked
invalid by DB2.
Additional Information
Feedback
