IDUG NA 2025: Full Schedule

arrow_back View All Dates

10:20am EDT

E6 | Db2 for z/OS Utilities – Best Practices for Maximizing Availability and Performance

Tuesday June 10, 2025 10:20am - 11:20am EDT

This session provides an indepth overview of the best practices in running Db2 for z/OS Utiliites. We will discuss various tips and recommendations on how to minimize application impacts and optimizing utility performance for each of the core utilities, using the latest functionalities delivered in Db2 13 up to level FL506.

Speakers

Ka Chun Ng

Db2 for z/OS Development, IBM

Ka Chun Ng is a Senior Technical Staff Member in Db2 for z/OS based at the IBM Silicon Valley Laboratory in San Jose, California. He is the technical lead for Db2 Utilities and has over 20 years of experience in the design, development and service work in Db2 for z/OS, focusing... Read More →

Tuesday June 10, 2025 10:20am - 11:20am EDT
Inman

Technical Session, Db2 Solutions Utilities and Tools

Audience All
Subject z/OS

11:30am EDT

E7 | Explain EXPLAIN

Tuesday June 10, 2025 11:30am - 12:30pm EDT

Inman

There are many sessions about the EXPLAIN facility in Db2 LUW, but they all lack the concise statements to find the right SQL queries, set everything up, do the EXPLAIN and draw the right conclusions by examples and working statements to copy–and–paste.
This is a back–to–basics session, enhanced with experiences from real situations and best practices.
The material was used for internal training of colleagues.

Speakers

Roland Schock

Principal, tasdevil Consulting

Roland is installing, using and tuning Db2 on distributed since 1993 or Version 2.1 for OS/2. After working for 25+ years for ARS Computer und Consulting GmbH as a Db2 expert he is now an independent consultant.His expertise and engagement for the community allowed him to become IBM... Read More →

Tuesday June 10, 2025 11:30am - 12:30pm EDT
Inman

Technical Session, Db2 Solutions Utilities and Tools

Audience All
Subject z/OS, LUW

2:00pm EDT

E8 | BMC Db2 AMI Utilities To The Rescue – What's New !!

Tuesday June 10, 2025 2:00pm - 3:00pm EDT

Inman

Quickly and Easily solve your most demanding Db2 utility challenges using the latest capabilites available in the BMC AMI Db2 utilities. This presentation covers the latest enhnacements in the BMC utilities for Db2 zOS. Come learn how BMC customers solve their hardest operational problems every day using the Db2 utilities from BMC. Gain deep insights on the advanced performance, useability and automation features available today in the BMC Db2 Utilities that set us apart from the competion.

Speakers

Michael Cotignola

Db2 Solution Engineer, BMC Software

Michael Cotignola is a Principal Software Consultant supporting BMC's DB2 Mainframe Solutions. In this role, he helps his clients maximize the value they receive from BMC's DB2 products. Michael has worked in IT since 1975 in numerous IT disciplines, including operations, application... Read More →

Tuesday June 10, 2025 2:00pm - 3:00pm EDT
Inman

Technical Session, Db2 Solutions Utilities and Tools

Audience All
Subject z/OS

4:30pm EDT

E9 | Db2 Automatic Statistics Deep Dive

Tuesday June 10, 2025 4:30pm - 5:30pm EDT

Inman

Accurate catalog statistics are the lifeblood of the Db2 query optimizer. Db2 has had automatics statistics support since version 8.2 and real–time statistics were introduced in version 9.5. Automatic statistics collection is enabled by default for new databases and is the recommend best practice. So if you are still hesitant to use them, attend this session to gain a deeper understanding of how they work and why you can trust them to simplify your DB administration and improve overall query performance. In addition to providing details on the automatic statistics architecture, this presentation will provide details on ways to monitor and control automatic statistics collection so that it works well for any type of Db2 system.

Speakers

John Hornibrook

Senior Technical Staff Member, IBM

John is a Senior Technical Staff Member responsible for relational database query optimization on IBM's distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS), IBM Db2 Analytics Accelerator... Read More →

Tuesday June 10, 2025 4:30pm - 5:30pm EDT
Inman

Technical Session, Db2 Solutions Utilities and Tools

Audience All, Beginner
Subject z/OS, LUW