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

Date: 
Wednesday, 14 lipanj, 2017 - 10:00 - 11:00
Program: 
z/OS Track
Speaker: 
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.

 

sqladria

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

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023