ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to get more rows for SQL codes.

book

Article ID: 131377

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS 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.