PDT Real time storage and CPU impact of increasing default values for Max SQL error
Article ID: 212142
Updated On:
Products
Issue/Introduction
What is the impact for real time memory/storage and CPU if Max SQL errors retained in a collection interval and Max SQL errors retained for a single SQLCODE default values below are increased to 15000 and 500:
Max SQL Errors retained in a collection interval==>003000
Max SQL Errors retained for a single SQLCODE==>000200.
Environment
Release : 20.0
Component : CA Detector for DB2 for z/OS
Resolution
Increasing " Max SQL errors retained in a collection interval ' will use more storage but there is no way of knowing how much. The storage used for SQL errors will be increased, however, after the data have been written to the Datastore, the storage will be freed at the end of the interval. Increasing "Max SQL errors retained for a single SQLCODE" has not much impact.
Feedback
