How to get more rows for SQL codes.

Article Id: 131377

Status: Published

Updated On: 22-05-2019 08:16

Products:

CA Bind Analyzer for DB2 for z/OS , 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

Issue/Introduction:

Is there a possibility to raise the amount for all SQL codes not for one individual single SQL error that is reported?.
If the total of SQL codes saved is changed to maybe 400 from the default 200, to what extent is it needed to raise the total SQL per interval?
Can the amount for one SQL error code for example a -305, be set?

Environment:

z/os
DB2

Resolution:

The current option is just to raise the amount for all SQL codes, you cannot set a specific limit for one individual single SQL error.