SQL Optimizer for DB2 ZOS 5.6.1 - Release Notes

Quota Options

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set quota options

1. Click .

2. Select Optimize SQL | SQL Rewrite | Quota

3. Review the following for additional information:

   Quota	Description
   Syntax Transformation Quota	Specify the maximum number of SQL statements generated by applying SQL transformation rules. This quota affects how many SQL statements are created by changing the SQL syntax. The default quota of 100 is normally sufficient for most of the complicated SQL statements. However, the quota can be increased to tackle exceptionally complicated SQL statements with very high levels of table joins or multiple levels of nested sub-queries.
   SQL Options Quota	Specify the maximum number of SQL statements to be generated by applying SQL options.
   Total Quota	This is a read-only field indicating the maximum number of SQL statements generated during SQL Rewrite. This figure consists of: Syntax Transformation Quota + SQL Options Quota.

Related Topics

Intelligence Options

SQL Options

Optimization Options