Articles & Content


E03 - The 3 "P"s of Triggers - Performance, Pitfalls and PL/SQL

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2016

Triggers have now been with us since Version 6 of DB2 (1999!) so it is perhaps time for a refresher.
This presentation starts with a recap of the different types of trigger (including the new INSTEAD OF variety) before looking at how they are used.
We'll look at some performance aspects of triggers and understand why they should not be used indiscriminately.
Finally, we'll finish with some basic examples of triggers

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.