Customer identified that more segments are allocated in V11 for UTS tablespace after several updates.

The reason is that update module in V11 doesn’t update spacemap entry correctly. For overflow records, update could move the overflow record from original overflow page to another overflow page. After the original overflow record is deleted from the original page, this original page should’ve been marked as empty(‚2‘) in spacemap page if the original overflow record is the only record in the original page. While in V11, those empty pages are marked as ‚3‘ in the spacemap page.

If all the pages in one segment are empty pages, the whole segment could be marked as pseudo new segment and might be available to be reused before allocating a new segment. While in V11, segment would not be marked as pseudo new correctly as all pages in the segment are marked as ‚3‘ rather than ‚2‘.