Partitioning data in DB2 for z/OS – so many choices!

Wednesday, 14 June, 2017 - 10:00 - 11:00
z/OS Track
Steve Thomas

The ability to partition DB2 tables has been available in DB2 since the very earliest releases, but over the past 10 years or so the number of choices available to DBA’s has exploded. During that time we’ve seen increases in the number of partitions, Table based rather than Index based partitioning, Data Partitioned Secondary Indexes, UTS objects which are partitioned by Growth or Range, and now in DB2 12 for z/OS Relative Page Numbering and the capability to create enormous objects. It’s got to the point where almost all DB2 tables are partitioned in one way or another – you just have to decide which option to choose. This session will run through all the options in turn, highlighting the benefits and drawbacks of each. We’ll provide hints and tips on how to get the best performance while minimizing Management and will highlight things you might need to watch out for when managing partitioned objects in your systems.



SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020