Unable to see SQL ERROR HOST VARIABLES

book

Article ID: 50766

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

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 can't display the host variables for SQL error. What's wrong.

Solution:

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).

Environment

Release:
Component: PDT