When you select a plan from the contents pane and select Show Related for that object, the Show Related dialog lists any objects with first-level dependencies on that plan. These objects can be: aliases, indexes, packages, synonyms, tables, table spaces, views. You can view second-level dependencies by selecting Show Related for each object with a first-level dependency.
A plan is the control structure produced during the bind process, used by DB2 to process SQL statements during statement execution.
If you drop an alias that was used in a plan, you need to rebind the plan.
When an index is deleted, its description is deleted from the catalog and any plans that reference the index become invalid.
If you drop a plan any packages within that plan are also dropped.
If you drop a table, any views and authorizations based on the table are dropped. Dropping or changing a table space invalidates plans that use the table space so that the plan needs to be rebound.
When you drop a view, DB2 invalidates application plans that are dependent on the view. Also, DB2 revokes the privileges of users who are authorized to use it. DB2 attempts to rebind the plan the next time it is executed, and you receive an error if you do not re-create the view.