DB2 9.7 - Find rows inserted by a specific trigger We are auditing a table TRANSACTIONS that inserts a row in HISTORY_TRANSACTIONS when specific columns are changed. These inserts happen through a number of triggers defined on TRANSACTIONS table. Is it possible to find out which trigger inserted a specific record in HISTORY_TRANSACTIONS ? (seems impossible, but I wanted to confirm that no system tables could achieve this as well?)
You are correct in your assumption – there is nothing done at the database level that would track the source of a row.  You would need to modify your history table definition and trigger logic to add this kind of tracking.