Short text
Activation of the so-called “FAIR Lock” option for DB2 for IBM i (queue for database lock queries) on the main connection.
Parameter Description
This activation triggers the implementation of the “FAIR lock” option for DB2 for IBM i and thus replaces the QAQQINI parameter PREVENT_ADDITIONAL_CONFLICTING_LOCKS = *YES.
Keep in mind that the parameter only affects connections to the ABAP database schema, not secondary connections that were defined using transaction DBCO. Normally, this is not of concern since accesses via secondary connections generally do not require any exclusive locks. Should this be desired, however, the parameter must be maintained – as up to now – through QAQQINI, and its location must be included as the AS4_QAQQINILIB parameter in the definition of the secondary connection.
For information on the requirements for the use of the new parameter and details on the “FAIR lock” option, see SAP Note 1952271.
Application Area
Database
Default Value
1
Who is permitted to make changes?
DB administrator
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Are other parameters affected or dependent?
If you set this parameter, the dbs/db4/parallel_alter_tables parameter described in SAP Note 960392 becomes superfluous. We generally recommend that you no longer use this.
It is also no longer necessary to set the QAQQINI-Parameter PREVENT_ADDITIONAL_CONFLICTING_LOCKS = *YES. Check your QAQQINI strategy.
Values allowed
L 0 1 OFF ON NO YES FALSE TRUE
