Can CA Detector collect information on CAF (Call Attach Facility) errors SQL-922 or SQL-923 due to revoking plan access?

Document ID : KB000024829
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

If the CAF (Call Attach Facility) fails on the authorization of a plan or package with a SQL-922 or SQL-923 error, will CA Detector for DB2 for z/OS (PDT) capture this type of failure?

 

Answer:

It is currently outside the design of CA Detector to collect SQL errors that do not occur as the result of the execution of an SQL statement.  This includes SQL errors such as SQL-922 and SQL-923 that result in the statement execution being suppressed.