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.
In addition ...
Do your users connect to your database(s) using shared memory? If so, copy bin/zOldTRXDetails.shx to bin/zOldTRXDetails.sh. This script will run when the zOldTRXDetails alert enhancer runs. It will try to dump a stack trace for the process holding the old transaction and include it in the alert sent to the ProTop Portal. Please take a look at Alert Configuration for more details.