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?
Release : 20.0
Component : Detector for DB2 for z/OS
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).