Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    kualaumpur
    Posts
    33

    Question Unanswered: Questions related to Invalid Packages !!

    Dear All,

    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.


    TIA

    Trinmoy

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •