No SQL text for -302 error capture by Detector
search cancel

No SQL text for -302 error capture by Detector

book

Article ID: 234054

calendar_today

Updated On:

Products

Detector for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Attempting to view the SQL call text of -302 SQL error through the Detector for Db2 for z/OS (PDT) SQL Error Detail Display, no data was displayed.
It appears that a Dynamic SQL statement is causing the -302 error codes, which may be the reason why the text cannot be displayed.
Curious if anything can be done to view the SQL statement that is causing the -302?

Environment

Component : Detector for DB2 for z/OS

Resolution

The problem was caused by not turning on the SQL error text (SQT). SQT(Y/N) specifies whether to enable more SQL text collection for SQL error data.
When Y is specified also specify SQE(Y) or SQE(A).