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/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem 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.