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.
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);