IBM Support

IT02978: ADMIN_MOVE_TABLE MAY FAIL TO DROP UDI TRIGGERS FROM SOURCE TABLE DURING SWAP OPERATION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During SWAP operation, all the objects created by
    ADMIN_MOVE_TABLE during startup, will be cleaned. We can end up
    in a situation, where the drop UDI trigger operations on the
    source table are rolled back due to a -911 RC 68 SQL error. All
    the other objects like staging table are removed successfully,
    which leaves the UDI triggers in state inoperative on the new
    target table. The SQL911 error is never reported back to the end
    user, thus the SWAP operation finishes with success.
    

Local fix

  • Manually drop the ADMIN_MOVE_TABLE UDI triggers from the target
    table after the SWAP operation finished successfully.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 10.                      *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 10.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT02978

  • 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

    2014-07-04

  • Closed date

    2014-12-09

  • Last modified date

    2014-12-09

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

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

    IT03099 IT03100

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       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:
09 December 2014