Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - Installation Guide

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

SQL Options

Optimization Options

 

Related Documents