PDT Real time storage and CPU impact of increasing default values for Max SQL error

book

Article ID: 212142

calendar_today

Updated On:

Products

CA Detector for DB2 for z/OS CA Database Management for DB2 for z/OS - Performance Suite CA Database Management for DB2 for z/OS - SQL Performance Suite

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.