Unable to see SQL Error Host Variables within Detector

Products

• Detector for DB2 for z/OS

Issue/Introduction

Collection options are setup as follow:

SQL collection options:
Standard Activity ==> Y (Y/N)
Dynamic SQL Stats ==> N (Y/N) (Requires profile)
View By Keys ==> N (Y/N) (Requires profile)
Dynamic Exceptions ==> Y (Y/N) (Requires profile)
Static Exceptions ==> N (Y/N) Exception cache size ==> 4000
SQL Errors ==> Y (Y/N) (Requires profile)
SQL Error Text ==> N (Y/N)
Host variables ==> Y (Y/N) (applies to all options)

But cannot display the Host Variables for SQL errors within Detector for Db2 for z/OS (PDT).

Resolution

To display SQL error Host Variables, the SQL Error Text flag needs to be turned on. Without it the Host Variables will not display even though the Host Variables flag is on.
For the Modify command, the parm to turn on SQL Error Text collection is SQT(Y).