IDUG NA 2025

This half–day hands–on workshop is designed to provide you with all the details you need to know for a successful SSL/TLS deployment for Db2 LUW and on–going certificate maintenance.  Encrypting network communications is essential in today’s security conscious world and is a complex task with many moving parts.  That complexity is confirmed by the number of cases Db2 support and development see asking for help configuring TLS.  This workshop builds on those years of experience to give you the knowledge you need to set things up correctly and securely.  The workshop will start with the very basics of asymmetric cryptography, which form the foundation of certificates and turn the discussion to trust and the role it plays.  From there, we will turn to hands on exercises configuring the Db2 server, followed by Db2 clients/drivers allowing encrypted client/server communication.  Topics such as certificate creation, keystore management, and hostname validation will be discussed and practiced.  The steps required for certificate renewal will be demonstrated.  Advanced topics such as TLS with HADR will be discussed, showing how the practiced knowledge of setting up client/server TLS will follow through to HADR.  While not necessary to attend the workshop and learn something, the hands on–portions will require you to bring your own laptop and be able to establish an SSH connection to the public IBM Cloud.

Are your DB2 queries slowing down your applications? Are you struggling to meet performance SLAs? It's time to take control of your database performance with expert query tuning techniques.
This session will delve into the essential principles and best practices for optimizing DB2 queries. You'll learn how to:
 * Identify Performance Bottlenecks: Discover powerful tools and techniques to pinpoint the root causes of query slowdowns.
 * Leverage Explain Plans: Understand the execution plan of your queries to identify inefficiencies and opportunities for optimization.
 * Optimize Query Structure: Learn how to rewrite queries to improve their performance, including techniques like indexing, partitioning, and query hints.
 * Utilize DB2 Performance Tools: Explore the suite of DB2 performance monitoring and tuning tools to gain valuable insights into your database behavior.
 * Implement Effective Monitoring Strategies: Establish a robust monitoring framework to proactively identify and address performance issues.
By attending this session, you'll gain the skills and knowledge to significantly improve the performance of your DB2 queries, leading to faster response times, reduced system load, and enhanced overall database efficiency.

As the Data Lakehouse model revolutionizes data stores, it has become crucial to integrate vital IBM Z data within them. Experience how easy it can be to synchronize your vital IBM Db2 z/OS and VSAM data directly into Iceberg tables in Cloud Object Storage. With Data Gate for watsonx, get the power of the Open Lakehouse leveraging the most important data in your enterprise! 
Make sure to bring your own device to complete the lab exercises, and pre–create an IBM ID.

Both an overview and a deep dive of recently shipped / announced Db2 content, and then a look into what is coming soon.

For work I try to stick to a rule: "Never do something three times!". I do it once, the second time I'm annoyed and for the third time I try to automate it.As I'm currently managing around 40 RHEL servers with nearly 700DBs on it, automation, conventions and rules are key.
In this session I want to show the audience general commands and constructs within shell programming. Givng a method at hand how to fast develop shell scripts and oneliners and some tricks to get around some possible pitfalls on the way.

Waaaaay back in 2006 I first held a RUNSTATS Master class where everything that RUNSTATS does to help, and hinder(!), us is explained. After 18 years it has now become an adult and has been updated right up until the last RUNSTATS change in Db2 13 FL500 with all the changes that have happened since 2006.
This session will show you how RUNSTATS works, when to, and not to, use it and how to use it as good as you can.

Having been a DBA from 1985 to 1995, followed by working in the field with Db2 customers around the world for 30 years, I have come face–to–face with many trials and tribulations. Join this session to experience some of the most interesting battles and learn how partner solutions can augment and complement native Db2 features. You will leave inspired with new ideas to apply in your environment.

Are you revising, enhancing, or establishing an effective Db2 application performance management strategy? Join this session to benefit from over 30 years of experience in the field. We will discuss key processes, important factors to consider, and essential data to collect for successful performance management.

IBM provides us number of solution to achieve multisite HA/DR for PureScale clusters. Those include technologies like HADR Replication for PureScale Clusters, Geographically Dispersed PureScale Clusters, GPFS replication for PureScale Clusters, Q Replication for PureScale Clusters.
 In the presentation we will describe alternative approach, where replication across 2 sites is provided by Storage Array Layer, which allows us to achieve additional benefits like consistency groups going beyond single GPFS filesystem used by the PureScale, optimized network utilization where Storage Array replication happens on SAN Fiber, additional HA layer where filesystem can be cross mounted across sites which gives additional redundancy layer for storage availability.
  
 We implement solution by deploying Synchronic Storage Replication across 2 sites, where SAN fabric provides us NSD multi path connections from each side. This way on each side we have collection of NSD disks that are local to given side, and also connection to remote NSD disks from DR side. On both sites we install standalone PureScale clusters, independent from each, therefore failure of any of those clusters does not impact other side counterpart. Having 2 clusters we designate one as primary by creating PureScale managed GPFS on top of Storage Array Layer, and on top of that create Database with its' associated paths. Next we use gpfssync capabilities to export primary GPFS filesystem , and next mount the same on DR site. This allows us to mimic primary cluster on DR site, and next attach those synchronized mount points to TSAMP cluster on secondary site. Later on, we just move application connection to DR site, which can handle further ongoing workloads.
  
 Proposed solution is active–passive deployment, when at any given time only one cluster has connection to synchronized storage array. We achieve this by protections on each layer (NSD disks active on one site only, GPFS mounts online on one site only, database cataloging on one site only). This is crucial to ensure only one side has active writes to the cluster, so that we prevent any corruption of the data. In the presentation we provide procedures to setup such deployment, along with failover procedures where we move storage attachment from primary to secondary, and reverse. We also provide testing results where we verify solution, by forcing failover and more failure scenarios while processing application workload.

Trying to figure out the ins and outs of Db2 Log Space Management?  Spent too much time trying to figure out what settings are best for your environment?  With the introduction of Advanced Log Space Management the time has come to unleash it's potential.  Fully supported, the journey has begun in making log space management more autonomic.  This presentation will introduce you to some of the concepts and principles behind it all.  We will do a deep dive into the technology and transformation behind making log space management more hands off, which in the end will make life simple for you and your organization.

Join this session to gain insights on best proactices for using Broadcom Db2 utilities and explore traditional and emerging use cases, such as intelligent housekeeping, DevOps, test data management, and recovery compliance. You will learn how to get the most value out of the technology you have in your hands.

This session is meant to be a HADR beginners session (101. back to basics, however you want to call it). Showing what HADR is, how it works in general and how you get it started. Additionally I'll explain the most common configuration parameters, their purpose and possible trip wires on the way to a running HA cluster.
This session will NOT cover any cluster autmation like TSA or Pacemaker.

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.

This is a back–to–basics session that will cover the fundamentals of Db2 Large Objects (LOBs), their structure, different LOB types, how they are implemented, considerations for daily management and how it is possible to Improve application performance transforming standard lobs to Inline Lobs.
Db2 LOBs enable you to store large amounts of data in a single column. The data can be structured in nature, but more often contain unstructured data such as images or audio data. LOB implementation requires auxiliary objects to be created, which increases the complexity of object administration, space utilization, and utility processing.
This session provides an overview of Db2 LOBs, things to watch out for, and tips for tuning and space allocation.
Objectives:1.    Provide an overview of LOB types, and how they are structured and implemented.2.    Provide tips for performance tuning and space utilization using the Inline Lobs.3.    How to avoid LOB data corruption scenarios and ensure data integrity.

Creating backups of and recovering your data are essential tasks performed by the IBM Db2 utilities.  This presentation will cover the basics – the different types of backups and recovery options – for the COPY, RECOVER, REBUILD INDEX, BACKUP SYSTEM, RESTORE SYSTEM utilities, and more, including a peek at new and future enhancements.

Thinking about your availability and recovery strategy shouldn't give you sleepless nights.  When issues do come up, you want to make sure you have the tools needed to solve problems and ensure you get the most out of your investment in Db2.  This presentation will give you some context and insight into the top questions we see from our customers the most in the areas of backup, restore, crash recovery, locking, logging, transaction management and high availability and disaster recovery.  The questions and answers discussed here could save you when an unexpected outage arises and/or better prepare you to avoid an outage in the future.

Automated process of page fix removes the manual efforts which are required for DBA's and System programmers to determine if page fixing buffer pools is a possibility in their environment and how to most effectively use the real storage resources on the LPAR to that end.In this beginner–level session, we will see how the best candidate for page fixing is determined. How the availability of real storage on LPAR is being determined.

See how IBM SQL Data Insights combines unsupervised deep learning with traditional SQL queries to allow you to run similarity, dis–similarity, cluster, analogy, and commonality queries on your Db2 z/OS data. You can easily uncover the hidden relationships across tables and views in your Db2 data, quickly gain actionable insights for solving your business problems as they arise, and confidently arrive at better business decisions. We will explore tables containing mutual funds financial data, home insurance underwriting data, and food nutrition data. You will experience how AI SQL queries can be applied to industry specific domains to find similarities, segment customers, and find outliers among relational data.
Make sure to bring your own device, and pre–create an IBM ID!

The Db2 community constantly welcomes new database administrators or application developers that access Db2. One of the reasons – Db2 is known as a robust and reliable database management system and a perfect match for private and public cloud environments.
However, sometimes you might face database related issues. The session will cover the first steps in the process of problem determination and problem source identification (PD/PSI). The session gives hands–on examples and practical examples for the strategy and process to encircle and find the problem by asking the right questions and will share best practices for the first occurrence data capture (FODC) tools available for the DBA.