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