IBM Support

IC65281: INSTEAD OF TRIGGER UPDATE ON VIEW DID NOT RUN CORRECTLY ON UPDATABLE SDS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • INSTEAD OF trigger update on view did not run correctly on
    updatable SDS.  The sql below was first run on the primary.
    
    create table tab01 (col01 varchar(10), col02 varchar(10));
    create view view01 (col01, col02 ) as select col01, col02 from
    tab01;
    create trigger tab01_upd_trig instead of update
               on view01 referencing old as o new as n
                      for each row
                             (
                                   update tab01 set
                                      tab01.col01 = n.col01 ,
                                 tab01.col02 = n.col02
                            where
                               col01 = o.col01
                          );
    
    insert into tab01 (col01, col02) values ('11111', 'aaaaa');
    insert into tab01 (col01, col02) values ('22222', 'bbbbb');
    insert into tab01 (col01, col02) values ('33333', 'ccccc');
    update view01 set col01 = '44444' where col01 = '11111';
    select * from view01;
    
    The results show that the update was completed.
    
    col01      col02
    
    44444      aaaaa
    22222      bbbbb
    33333      ccccc
    
    However, if the sql below is run on an updatable SDS, the update
    was not completed.
    
    update view01 set col01 = '55555' where col01 = '44444';
    select * from view01;
    
    result:
    44444      aaaaa  <-- not updated.
    22222      bbbbb
    33333      ccccc
    
    This was tested on 11.50.FC5W4 and 11.50, running on both AIX
    5.3 and Solaris 9 with buffered and unbuffered
    logging and the results were the same.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users with instead of trigger defined                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When a view has an instead of trigger defined, the server    *
    * executes the trigger action instead of the actual DML. In    *
    * the case of an update from secondary, the instead of         *
    * triggers are not getting executed correctly.                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.50.xC7 and above.                              *
    ****************************************************************
    

Problem conclusion

  • Problem is first fixed in 11.50.xC7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC65281

  • Reported component name

    IBM IDS ENTRP E

  • Reported component ID

    5724L2304

  • Reported release

    B15

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-12-22

  • Closed date

    2010-10-01

  • Last modified date

    2010-10-01

  • 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

    IBM IDS ENTRP E

  • Fixed component ID

    5724L2304

Applicable component levels

  • RB15 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 October 2010