Oct
12
2023 Posted by Carol Davis-Mann

Table Partitioning: The Good, the Bad and the Ugly – Live at IDUG EMEA 2023

Do you want to learn about the benefits, potential pitfalls, and how to make the most out of the Db2 feature, Table Partitioning? If so, then you won’t want to miss Damir Wilder’s presentation at IDUG EMEA 2023 in Prague, where he’ll delve into the world of Table Partitioning and guide you through the good, the bad, and the ugly aspects of this powerful tool.

Originally intended to be delivered by Mark Gillis, the inspiration for this presentation stems from Mark’s widely read Triton blog of 2019, titled “Table Partitioning: The Good, the Bad and the Ugly.” Now, Damir Wilder takes the reins, bringing his unique insights and expertise to offer you an updated and highly informative session on Table Partitioning.

When: Thursday, 19th October 2023, 9:40 am – 10:40 am

Where: Room C16

Session Number: 16

Presentation Abstract

Table Partitioning has been a game-changer in database management since V9.7. It can significantly enhance performance and streamline data archiving. However, like any tool, it can go awry when mismanaged. Damir Wilder’s presentation will shed light on the world of Table Partitioning, offering practical guidance and real-world examples to help you navigate its intricacies successfully.

 

Objectives

  • Overview: Understanding Table Partitioning and its implementation.
  • Benefits (the Good): Exploring the advantages of Table Partitioning.
  • Gotchas (the Bad): Recognising the potential pitfalls and challenges.
  • Where it can go seriously wrong (the Ugly): Avoiding common mistakes.
  • How to convert existing tables into Partitioned: Practical tips for a seamless transition.
  • How to manage admin and housekeeping on your Partitioned tables: Efficient housekeeping strategies.

 

Suitable Audience:

  • Application Developers
  • Data Architects
  • Database Administrators
  • Experience Level: Beginner / Intermediate

 

If you’re looking to enhance your database management skills, optimise performance, and avoid common pitfalls in Table Partitioning, then mark your calendar for Damir Wilder’s presentation.

Don’t miss this opportunity to learn, connect with fellow professionals, and expand your expertise. We look forward to seeing you at IDUG EMEA in Prague!

Check out this year’s line-up.

« | »
Have a Question?

Get in touch with our expert team and see how we can help with your IT project, call us on +44(0) 870 2411 550 or use our contact form…