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.

Authorization: For most QAQQINI options, none is required. For the following three options, the caller must have *JOBCTL special authority or be authorized to the QIBM_DB_SQLADM function usage ID. 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
Read syntax diagramSkip visual syntax diagram OVERRIDE_QAQQINI ( OVERRIDE_OPTION =>  override-option ,OPTION_NAME => option-name,OPTION_VALUE => option-value )
The schema is QSYS2.
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.
Start of changeThis parameter is required when override-option is 2. For options 1 and 3, it can be omitted or passed as the empty string.End of change
option-value
A character or graphic string expression that identifies the value to assign to the QAQQINI option identified by option-name.
Start of changeThis parameter is required when override-option is 2. For options 1 and 3, it can be omitted or passed as the empty string.End of change

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);
  • Improve the chances that you can acquire an exclusive lock for a database file. Multiple calls to the procedure can be used to change more than one QAQQINI value.
    CALL QSYS2.OVERRIDE_QAQQINI(2, 'PREVENT_ADDITIONAL_CONFLICTING_LOCKS', '*YES');
  • Discard the temporary QAQQINI file and revert to using the job's version of the QAQQINI file.
    CALL QSYS2.OVERRIDE_QAQQINI(3);