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:

  • Start of changeACTIVE_JOBSEnd of change
  • ALLOW_ADAPTIVE_QUERY_PROCESSING
  • ALLOW_ARRAY_VALUE_CHANGES
  • Start of changeALLOW_DDL_CHANGES_WHILE_OPENEnd of change
  • Start of changeALLOW_EVI_ONLY_ACCESSEnd of change
  • ALLOW_TEMPORARY_INDEXES
  • APPLY_REMOTE
  • ASYNC_JOB_USAGE
  • CACHE_RESULTS
  • COLLATE_ERRORS
  • COMMITMENT_CONTROL_LOCK_LIMIT
  • Start of changeCONCURRENT_ACCESS_BEHAVIOREnd of change
  • DETERMINISTIC_UDF_SCOPE
  • FIELDPROC_ENCODED_COMPARISON
  • FORCE_JOIN_ORDER
  • IGNORE_LIKE_REDUNDANT_SHIFTS
  • Start of changeKEY_RANGE_ESTIMATE_TIMEOUTEnd of change
  • 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
  • PSEUDO_OPEN_CHECK_HOST_VARS
  • QUERY_TIME_LIMIT
  • REOPTIMIZE_ACCESS_PLAN
  • Start of changeSQE_NATIVE_ACCESSEnd of change
  • Start of changeSQE_NATIVE_ACCESS_POSITION_BEHAVIOREnd of change
  • SQLSTANDARDS_MIXED_CONSTANT
  • SQL_CONCURRENT_ACCESS_RESOLUTION
  • SQL_DECFLOAT_WARNINGS
  • SQL_FAST_DELETE_ROW_COUNT
  • SQL_GVAR_BUILD_RULE
  • SQL_MODIFIES_SQL_DATA
  • SQL_PSEUDO_CLOSE
  • SQL_STMT_COMPRESS_MAX
  • SQL_STMT_REUSE
  • Start of changeSQL_SUPPRESS_MASKED_DATA_DETECTIONEnd of change
  • SQL_SUPPRESS_WARNINGS
  • SQL_TRANSLATE_ASCII_TO_JOB
  • SQL_XML_DATA_CCSID
  • STAR_JOIN
  • STORAGE_LIMIT
  • SYSTEM_SQL_STATEMENT_CACHE
  • Start of changeSYSTIME_PERIOD_ADJEnd of change
  • TEXT_SEARCH_DEFAULT_TIMEZONE
  • UDF_TIME_OUT
  • VARIABLE_LENGTH_OPTIMIZATION