IBM Support

IT13266: COMPILED TRIGGERS NOT FIRING AFTER UPGRADE FROM VERSION 9.7 TO 10.1 OR 10.5

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After an upgrade to DB2 Version 10.1 or 10.5 from Version 9.7,
    some compiled triggers might appear not to activate.  The
    triggers are in fact activating, but some SQL statements inside
    the trigger body do not run.
    
    The triggers work correctly in Version 9.7.  The issue is not
    caused by the upgrade itself, but by an inconsistency introduced
    into the system catalogs when a compiled trigger is invalidated
    and revalidated in Version 9.7.  The subsequent database upgrade
    exposes the problem.
    

Local fix

  • The following query can be run after updating to DB2 Version
    10.1 or 10.5, to identify triggers affected by this APAR.
    Dropping and recreating the triggers will correct the issue.
    
    db2 "select name, schema, lib_id from sysibm.systriggers where
    lib_id is not null and lib_id not in (select lib_id from
    sysibm.syscodeproperties)"
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 10.1 Fix Pack 6                               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 10.1 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT13266

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-01-20

  • Closed date

    2017-03-02

  • Last modified date

    2017-03-02

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

    IT12741

  • 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

  • RA10 PSN UP

       FIX

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 March 2017