IBM Support

IC73421: SQL0880 WHEN CREATING SQL STORED PROCEDURE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The error below may be returned when creating a SQL stored
    procedure whose package has been invalidated because one or more
    dependent objects (e.g. table, index) used by the SQL stored
    procedure has been dropped or altered.
    
    
    
    SQL0880N  SAVEPOINT "SYSDB2BINDING_SAVEPOINT" does not exist or
    is invalid in  this context.  LINE NUMBER=75.  SQLSTATE=3B001
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v9.7 Fixpack 5.                               *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in v9.7 Fixpack 5.  At minimum the fix
    should be applied to the server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC73421

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-12-21

  • Closed date

    2012-01-02

  • Last modified date

    2012-01-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

  • R970 PSN

       UP

  • R980 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC73421

Modified date: 02 January 2012