News
Abstract
Fair lock option - PREVENT_ADDITIONAL_CONFLICTING_LOCKS
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > Fair lock option - PREVENT_ADDITIONAL_CONFLICTING_LOCKS
Challenge: Frequent DML activity blocks DDL request
Response: Add PREVENT_ADDITIONAL_CONFLICTING_LOCKS QAQQINI control
Benefit: Improved ability to transform data model in production
Support: Applies to ALTER TABLE (Add, Alter or Drop Column), CREATE TRIGGER, LOCK TABLE, & RENAME TABLE
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
11 April 2021
UID
ibm11167904