Joined: 06 Sep 2007 Posts: 788 Location: Chennai, India
When a privilege that is required by a plan or package is revoked, the plan or package is invalidated.
If an index is dropped that is used by a package, that is marked as invalid.
When an invalid package is executed, DB2 does an automatic rebind so that DB2 can determine a new access path. If the rebind fails (for example, if a referenced table, view or column is missing) the package is marked as inoperative.