Whether you’re considering a bit of spring cleaning on your existing indexes or suiting up for hunting season, the evolutionary improvements in DB2 10.1 and 10.5 provide DBAs with a game-changing set of index management options.
In every new release of DB2 for z/OS, performance improvements are made. How much someone benefits from these improvements varies, depending on the features you use, the type of workload you run and the effort that you put into tuning in the previous releases of DB2 for z/OS.
DB2 10.5 is best known for BLU Acceleration, which is the new columnar store for tables. Organizing tables by column rather than row can lead to dramatic improvements in elapsed time for analytical queries.