What is the maximum limit for Max SQL errors retained for a single SQLCODE field in the Detector Collection Profile

Products

• Detector for DB2 for z/OS

Issue/Introduction

What is the maximum limit for Max SQL errors retained for a single SQLCODE field in the Detector for Db2 for z/OS (PDT) Collection Profile?

Resolution

The Max SQL errors retained for a single SQLCODE count allows a value that is less than or equal to the Max SQL errors retained in a collection interval count.
For example, if the Max SQL errors retained in a collection interval is 999999 (which is the maximum value that Detector allows in this field):

 

Rnn.n      ------- DETECTOR View/Modify SQL Error Group

Profile ID ==> CPROFILE                                  Profile SSID ==> DB2
-------------------------------------------------------------------------------
Max SQL errors retained in a collection interval ==> 999999

 

The Max SQL errors retained for a single SQLCODE count can also be 999999:

Rnn.n      ------- DETECTOR View/Modify SQL Error Group
 
Profile ID ==> CPROFILE                                  Profile SSID ==> DB2
-------------------------------------------------------------------------------
Max SQL errors retained for a single SQLCODE  ==> 999999