No SQL Text for -302 error

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

 Trying to view the SQL call text of -302 sql error  through the Detector SQL Error Detail Display, no data was displayed. It appears that a dynamic SQL statement is causing the -302 error codes, which might 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

Release : 20.0

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