75 ways to demystify DB2: #5: Tech Tip:Have you encountered a lock wait during online reorg TRUNCATE phase ?
Myna 270007DJT1 Visits (6868)
The following explains the "Truncated" state of a reorg and why applications might have a LOCK WAIT on reorg : Online reorg holds an S lock on the table during the process of table truncation. While online reorg holds an S lock on the table, no insert/update/delete activity can occur on the table. During the online reorg process rows are moved to pages closest to the start of the table. While this is going on, rows inserted into the table may end up close to the end of the table and online reorg may not see these rows depending... [More]