How does this alert enhancer help me?
When an old transaction alert is triggered, and your alert definition includes the zOldTRXDetails enhancer in the actions list like this (default):
otrx num > 3600 "" "hourly" "Old Transaction &1 &2 &3" zOldTRXDetails,alert
The alert will arrive at the ProTop Portal with details you see in the image above.
If this is the first time you are seeing this alert you can enable client statement cache (CSC) for the user(s) listed and subsequent alerts may contain the line number and the procedure name that is causing the old transaction, under the Wait column:
NOTE: The client holding the old transaction has to be activily communicating with the database for this approach to enable CSC to work: