The ERRORCNT field on the CA Detector SQL ERROR Summary Display exceeds the "Max SQL errors retained in a collection interval" and the "Max SQL errors retained for a single SQLCODE" count within the Collection Profile.

book

Article ID: 20060

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

The ERRORCNT field on the CA Detector SQL ERROR Summary Display exceeds the "Max SQL errors retained in a collection interval" and the "Max SQL errors retained for a single SQLCODE" count in the Collection Profile. Are the Collection Profile SQL Error limits honored?

Solution:

The ERRORCNT field on the CA Detector SQL ERROR Summary Display panel gives an accurate count of how many times the errors occurred during the interval. It is not limited to the Collection Profile error settings or the number of errors that are actually captured on the SQL Error Detail Display. Rather, it provides the actual error counts so that adjustments can be made within the Collection Profile settings if needed.

Environment

Release:
Component: PDT