OVERRIDE_QAQQINI procedure

The OVERRIDE_QAQQINI procedure creates and modifies a temporary version of the QAQQINI file.

The temporary QAQQINI file will be created in QTEMP. It inherits all query options that are already in place for the job. The OVERRIDE_QAQQINI procedure can be called multiple times to establish job specific QAQQINI settings.

The procedure can also be called to discard the temporary customization settings.

Read syntax diagramSkip visual syntax diagram OVERRIDE_QAQQINI ( OVERRIDE_OPTION =>  override-option , OPTION_NAME =>  option-name , OPTION_VALUE =>  option-value )
The schema is QSYS2.
Authorization: For most QAQQINI options, none is required. For the following three options, *JOBCTL or QIBM_DB_SQLADM function usage is required. These options are more restrictive because they can affect the performance of other jobs.
  • QUERY_TIME_LIMIT when the option-value is not 0.
  • STORAGE_LIMIT
  • PARALLEL_DEGREE
override-option
An integer value that indicates the function to perform.
1
Create the QAQQINI override file. A procedure call with this override-option value must be run before option 2 can be used to change QAQQINI options.
2
Set a QAQQINI option to the specified value. See QAQQINI query options for the list of options and values.
3
Discard the temporary QAQQINI file.
option-name
A character or graphic string expression that identifies the name of the QAQQINI option to be changed.
option-value
A character or graphic string expression that identifies the value to assign to the QAQQINI option identified by option-name.

Example

  • Establish the temporary override for QAQQINI. The job's current QAQQINI values will be used as the initial values.
    CALL QSYS2.OVERRIDE_QAQQINI(1, '', '');
  • Temporarily override three QAQQINI values. 
    -- Avoid UDF timeout
CALL QSYS2.OVERRIDE_QAQQINI(2, 'UDF_TIME_OUT', '*MAX');
-- Force full opens of cursors 
CALL QSYS2.OVERRIDE_QAQQINI(2, 'OPEN_CURSOR_THRESHOLD', '-1');
-- Force any saved access plans to be rebuilt 
CALL QSYS2.OVERRIDE_QAQQINI(2, 'REBUILD_ACCESS_PLAN', '*YES');
  • Discard the temporary QAQQINI file and revert to using the job's version of the QAQQINI file.
    CALL QSYS2.OVERRIDE_QAQQINI(3, '', '');