search cancel

DETECTOR SQL ERROR Summary Display - ERRORCNT value

book

Article ID: 240757

calendar_today

Updated On:

Products

Detector for DB2 for z/OS

Issue/Introduction

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

Environment

Release : 20.0

Component : Detector for DB2 for z/OS

Resolution

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.