On the 'DETECTOR SQL ERROR Summary Display' screen, the total error count value for the SQLCODE is displayed under ERRORCNT column:
Is the total error count value in the ERRORCNT column unloaded to the Detector DB2 Tables?.
Release : 20.0
Component : Detector for DB2 for z/OS
The ERRORCNT value is not present on the Detector PDT_SQLERROR table. The ERRORCNT count value displayed on the 'SQL ERROR Summary Display' screen is in a field that is not unloaded by PDTBATCH Job along to the Detector DB2 Tables.
If you want to calculate the ERRORCNT value in the Detector DB2 Tables you could change the SQL errors collection via:
Collection Profile SQL Error Exclusion Group
to collect all SQL errors.
The PDT_SQLERROR table contains one row for each SQL error, whether Dynamic or Static, the counts can only be accessed by using the SQL DB2 COUNT function, so you can run the following query:
SELECT COUNT(*), SQLCODE FROM xxx.PDT_SQLERROR_nnn
GROUP BY SQLCODE
If you do begin to collect all SQL errors, this may impact the size of the DTR003 datastore and the PDT_SQLERROR table.