Mainframe Blog

IDUG 2023 EMEA Tech Conference in Prague: A Recap

4 minute read
Nick Mears

The International Db2 Users Group (IDUG), an independent, not-for-profit organization providing education, services, and conferences for the IBM® Db2® database, recently concluded its 2023 EMEA Db2 Tech Conference, held in Prague October 15–19. BMC was pleased to be a gold sponsor for the event, with several BMC team members participating in the event and leading multiple insightful presentations.


Reflecting on the conference, Ron Coleman, an advisory IDUG board member and director of BMC AMI Data product management (LinkedIn; BMC Community), summarized, “We had an outstanding experience at the conference in Prague. The conversations that began there about best practices and solutions for automating and optimizing the Db2 database for peak performance were genuinely energizing, and we look forward to carrying these on well after the conclusion of this conference.”


BMC’s Presentations

For those who might have missed the sessions, they were recorded and are now available via the IDUG site (registration required). Many of BMC’s IDUG presentations have also been made available on demand. Here’s a look back at some of the key presentations:

  1. The Basics of SQL Queries: From Fetches to getpages and I/Os
    In this foundational session, attendees dove into the intricacies of Db2 SQL queries within a typical Db2 for the IBM® z/OS® environment. Saurabh Pandey, Lead BMC Product Manager for Db2, explored various forms of queries, what could take place during a query, and the fundamental controls available. Session link
  2. Back to Basics: Real-Time Statistics: What are They and How Are They Used?
    Louise Comeaux, Lead Product Developer at BMC, took participants on an insightful journey into the world of real-time statistics (RTS), emphasizing their vital impact on database management and how they can be used to drive Db2 utility execution results and find the most efficient access path for processing objects to improve performance and CPU utilization. Session link
  3. Tackle Your Most Challenging Problems with the Newest Capabilities in BMC AMI Utilities for Db2
    Jim Kurtz, Advisory Software Consultant, highlighted the recent advancements in BMC AMI Utilities for Db2, focusing on how these solutions enable customers to address their most pressing operational challenges. Session link
  4. PSP—Let’s See Db2!—Observability with BMC AMI Data—Turning All That Noise Into Action!
    Amid today’s data-driven landscape, navigating through a barrage of statistics and metrics can be overwhelming. This session, presented by Saurabh and Frank Rhodes, R&D Solutions Architect, explained how BMC AMI Data transforms this overflow of data into meaningful, actionable insights. They walked through detailed examples of application analytics and the database DevOps pipeline, showing how to turn the daily metrics overload into actionable strategies. Session link
  5. Db2 13 for the ”Production” DBA
    Phill Baker, Senior Software Consultant], offered valuable insights for the busy production or development database administrator (DBA). Because it’s tough to explore new Db2 features before they’re needed in a project, Phil gave an overview of partition-by-growth (PBG) to partition-by-range (PBR) conversion and using DSN_PROFILE_TABLE for DDL break-ins. Instead of a how-to guide, his session provided a “how not to” perspective of the pitfalls and mistakes one can quickly encounter. Session link
  6. Back to Basics: DB2 Bufferpools
    Jim provided a comprehensive look into the basics of Db2 buffer pools, shedding light on every pertinent question. Session link
  7. PSP—From Recovery to Database Change Management—Shift-Left DBA and Developer Collaboration for Data-Driven DevOps Efficiencies
    In a current landscape fraught with ransomware, a resilient recovery strategy is essential. Chris Duellman, BMC Principal Solution Engineer, and Nilufer Osken, BMC Senior Solution Engineer, illuminated the importance of shifting recovery processes and database change management left. They highlighted the benefits of DBA and developer collaboration, promoting consistent solutions across development and production environments, and paving the way for maximized DevOps efficiencies. Session link
  8. The Art of War Against Bad SQL
    Ramon Menendez, Principal Solution Engineer at BMC, drew parallels between the ancient military tactics outlined in “The Art of War” and Db2 SQL performance strategies. Session link
  9. Tips and Hints for Application Developers and DBAs to Reduce Cost
    Marcus Davage, Lead Product Developer for BMC, shared valuable insights on optimizing cost-effectiveness within mainframe environments. Session link

The conference served as a platform for experts to share their knowledge and for attendees to enhance their understanding of the Db2 environment.


As we look forward to the next IDUG conference, the takeaways from the EMEA Db2 Tech Conference in Prague will continue to guide the BMC AMI Data set of solutions.


We hope that you find these sessions helpful and informative. If you have any questions about the topics covered or about our BMC AMI Data solutions, please visit the BMC AMI Data page on our website or reach out to us.

Enable High-Quality Database Changes in a CI/CD Pipeline

IT leaders in a recent IDC survey recognize the value of integrating mainframe database changes in a CI/CD pipeline. Learn about best practices organizations are taking to ensure agility and performance without increasing risk when adopting Database DevOps principles.

These postings are my own and do not necessarily represent BMC's position, strategies, or opinion.

See an error or have a suggestion? Please let us know by emailing

Business, Faster than Humanly Possible

BMC works with 86% of the Forbes Global 50 and customers and partners around the world to create their future. With our history of innovation, industry-leading automation, operations, and service management solutions, combined with unmatched flexibility, we help organizations free up time and space to become an Autonomous Digital Enterprise that conquers the opportunities ahead.
Learn more about BMC ›

About the author

Nick Mears

Nick Mears (new author) As Principal Solutions Marketing Manager at BMC Software, Nick leads global solutions marketing initiatives within BMC Software's AMI team for AI-driven and DevOps-focused data management and mainframe-centric SaaS and on-prem applications. In this role, Nick helps data management and software development organizations that feature AI, ML, and intelligent automation capabilities increase the efficiency, availability, stability, and release velocity of enterprise-grade data management and DevOps applications. Nick has over 15 years of experience supporting technology companies and enterprise-grade software with customer-oriented value.