Are Host Variables (Parameter Marker values) for active SQL displayed by Detector
Article ID: 13063
Updated On: 05-22-2023
Products
Issue/Introduction
Are Host Variables (Parameter Marker values) for active SQL displayed by Detector for Db2 for z/OS (PDT)?
SQL call text for exception SQL requests can be viewed for the SQL call that is currently being executed by the active thread.
SQL call text is available only for threads that are currently executing. The actual values of the host variables are provided with
the SQL call request. The parameter markers are listed in consecutive order as they appear in the SQL call request.
These values appear only for SQL calls that contain host variable data.
Resolution
When the Host Variable collection option is enabled, Detector displays Host Variables for Active & Historical collections.
However, they are displayed only for Exceptions and SQL Errors. They are not displayed for Standard Activity collections
not captured as an exception.
Additional Information
Feedback
