Subscribe for news about the latest Db2 for z/OS enhancements and new capabilities, from the IBM experts who design, build, test, and support Db2. Subscribers are notified of new blog posts. To subscribe, sign in with your IBMid and click "Follow this community."
The Db2 for z/OS development team manages this blog, following the IBM social computing guidelines. For comments or suggestions, contact email@example.com. You can also follow @Db2zLabNews on Twitter.
In the past, Db2 blocked REORG unload/reload partition parallelism when converting a classic partitioned table space to a partition-by-range (PBR) universal table space (UTS). This lack of parallelism meant that conversions toPBR UTS would run for significantly longer than normal reorganizations of the table space.
We recently enhanced the REORG utility in Db2 11 and Db2 12 so that it can now take advantage of unload/reload parallelism when converting a classic partitioned table space to a PBR UTS table space. Of course, the chosen degree of parallelism may vary, but this enhancement delivers a major performance improvement when you want to convert to the strategic UTS table space type.
Note that this improvement also applies to customers converting from PBR with absolute page numbering to PBR with relative page numbering in Db2 12.
To take advantage of these changes, apply the relevant PTF, based on your version of Db2:
Db2 12: APAR PI72455
Db2 11: APAR PI71930
Haakon Roberts is a Distinguished Engineer at the IBM Silicon Valley Laboratory in San Jose, California and the chief technical architect and strategist for Db2 for z/OS Utilities and Tools.
Emily Alameida is a technical writer for Db2 for z/OS.
Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe