without periodic commits, the program accumulates locks on every accessed row, which can exhaust the lock table and escalate to table-level locks, blocking other applications. (2) **Recovery** — if the program fails, DB2 must roll back all uncommitted work; a long-running unit of work leads to prolo