Controlling queries dynamically with the query options file QAQQINI
The query options file QAQQINI support provides the ability to dynamically modify or override the environment in which queries are executed. This modification is done through the Change Query Attributes (CHGQRYA) command and the QAQQINI file. The query options file QAQQINI is used to set some attributes used by the database manager.
For each query that is run the query option values are retrieved from the QAQQINI file in the schema specified on the QRYOPTLIB parameter of the CHGQRYA CL command and used to optimize or implement the query.
Environmental attributes that you can modify through the QAQQINI file include:
- ALLOW_ADAPTIVE_QUERY_PROCESSING
- ALLOW_ARRAY_VALUE_CHANGES
- ALLOW_TEMPORARY_INDEXES
- APPLY_REMOTE
- ASYNC_JOB_USAGE
- CACHE_RESULTS
- COLLATE_ERRORS
- COMMITMENT_CONTROL_LOCK_LIMIT
- DETERMINISTIC_UDF_SCOPE
- FIELDPROC_ENCODED_COMPARISON
- FORCE_JOIN_ORDER
- IGNORE_LIKE_REDUNDANT_SHIFTS
- LIMIT_PREDICATE_ OPTIMIZATION
- LOB_LOCATOR_THRESHOLD
- MATERIALIZED_QUERY_TABLE_REFRESH_AGE
- MATERIALIZED_QUERY_TABLE _USAGE
- MEMORY_POOL_PREFERENCE
- MESSAGES_DEBUG
- NORMALIZE_DATA
- OPEN_CURSOR_CLOSE_COUNT
- OPEN_CURSOR_THRESHOLD
- OPTIMIZATION_GOAL
- OPTIMIZE_STATISTIC_LIMITATION
- PARALLEL_DEGREE
- PARAMETER_MARKER_CONVERSION
- QUERY_TIME_LIMIT
- REOPTIMIZE_ACCESS_PLAN
- SQLSTANDARDS_MIXED_CONSTANT
- SQL_CONCURRENT_ACCESS_RESOLUTION
- SQL_DECFLOAT_WARNINGS
- SQL_FAST_DELETE_ROW_COUNT
- SQL_MODIFIES_SQL_DATA
- SQL_PSEUDO_CLOSE
- SQL_STMT_COMPRESS_MAX
- SQL_STMT_REUSE
- SQL_SUPPRESS_WARNINGS
- SQL_TRANSLATE_ASCII_TO_JOB
- SQL_XML_DATA_CCSID
- STAR_JOIN
- STORAGE_LIMIT
- SYSTEM_SQL_STATEMENT_CACHE
- TEXT_SEARCH_DEFAULT_TIMEZONE
- UDF_TIME_OUT
- VARIABLE_LENGTH_OPTIMIZATION
