06-25-04, 04:17 #1Registered User
- Join Date
- Nov 2003
Unanswered: Questions related to Invalid Packages !!
I have created few Stored Proc's which have internally created db2 packages ,
this packages needed to be granted execute permission/s if the sp's are called by any other users (also the SP's to be granted permissions).
I have noted that some times this packages become invalid and I need to apply 'rebind' when its cannot accessable by the user.
My question is , in what are the possible circumstances this packages become invalid? (do dropping a constraints for a table (used by sp and packages )
can be one of the reason ? )
Require all of ur view/s in this regard.
06-25-04, 04:35 #2Registered User
- Join Date
- May 2003
If any dependencies of the package are dropped or changed, the package will be marked as invalid. An invalid package will automatically have a rebind performed by DB2 the next time the package is executed. If the rebind fails again (during the automatic rebind), the package will be marked as inoperative, and an explicit rebind will be necessary.M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390