Are Host Variables (Parameter Marker values) for active SQL displayed by Detector
search cancel

Are Host Variables (Parameter Marker values) for active SQL displayed by Detector

book

Article ID: 13063

calendar_today

Updated On:

Products

Detector for DB2 for z/OS

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

SQL Error Detail and SQL Error Call Text

View Exception SQL Collection Activity

View/Modify Global Defaults