There's nothing specific to SQL Triggers in the SQL Performance Center.
If you create a Plan Cache Snapshot and then select the Analyze function on that Snapshot, you'll find a Program Summary report on the Actions pull-down menu of the Analyze window. That Program Summary report would include the SQL statements executed by the SQL Trigger program.
Another good way to ensure efficient SQL Trigger performance is to help Db2 generate as efficient code as possible when it generates the C program object for your SQL trigger. The "Improving performance of SQL Procedures, Triggers, & Functions" paper offers some recommendations in this area. That paper can be found at: ibm.biz/db2iPapers
------------------------------
Kent Milligan
------------------------------
Original Message:
Sent: Tue February 15, 2022 03:28 PM
From: Amy Vozza
Subject: SQL Trigger Performance
How can you determine the performance of an SQL trigger? Is there something in the SQL Performance Center or some other way to monitor those?
------------------------------
Amy Vozza
------------------------------
#SQL