News
Abstract
On IBM i 7.6, the data-change-table support for DELETE and UPDATE (SQL) statements opens the door to parallel execution.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > Parallel execution of UPDATE and DELETE (SQL) statements
On IBM i 7.6, the data-change-table support for DELETE and UPDATE (SQL) statements opens the door to parallel execution.
To leverage this support, the connection needs to be using commitment control, where the transaction isolation level is set to something other than *NONE or *NC.
IBM i Access Client Solutions (ACS) includes examples showing how to leverage parallel DELETE and parallel UPDATE.
Figure 1. ACS Insert from Examples for Parallel DELETE and UPDATE
[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.6.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
10 December 2025
UID
ibm17229616