IBM Support

IC63749: TRANSFER OWNER FAILS WHEN DEPENDENT OBJECT IS IN AN INVALID STATE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Transfer owner can fail when a dependent object is an invalid
    state.   For example:
    
    Consider an SQL procedure that references a table X.T1.    If
    X.T1 is dropped, then the underlying db2 package is invalidated.
    If a TRANSFER is attempted on the SQL procedure to another user,
    this transfer will fail when evaluating privileges on dependent
    objects held by the transferee.   Since the table that the
    package depends on no longer exists, this lack of privilege will
    block the transfer.
    
    With this APAR fix, we will no longer consider the package's
    dependencies since it is already an invalid object
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users using DB2 V9.7 FP3a and below                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * In a stored procedure, transfer owner can fail when a        *
    * dependent object is an invalid state.                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to DB2 V9.7 FP4 to avail a fix for this APAR. *
    ****************************************************************
    

Problem conclusion

  • Problem is fixed in DB2 V9.7 FP4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC63749

  • 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

    2009-10-15

  • Closed date

    2011-04-29

  • Last modified date

    2011-04-29

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

    IC63651

  • 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

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 April 2011