Modifying the maximum number of Detector SQL errors collected for a single SQLCODE

Products

• Detector for DB2 for z/OS

Issue/Introduction

How to modify the limit on the maximum number of errors Detector for Db2 for z/OS (PDT) collects for a single SQLCODE.

Resolution

This is accomplished within the PDT Collection Profile by:

1. Choosing option 4, View/modify profile.
   
   
2. Choosing option 1, View Collection Profiles.
   
   
3. Selecting the appropriate profile.
   
   
4. Specifying 'X' in the View Group Type field.
   
   
5. Specifying the desired number in these fields:
   Max SQL errors retained in a collection interval
   Max SQL errors retained for a single SQLCODE
   
   
6. Hitting PF3 to save this update in the profile.
   
   
7. Use the 'L' line command next to the updated profile on the collection profiles Display Screen and this should then load the modified profile
   and from that point forward, the new options take over.