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.

A cloud native resource without monitoring (or with a very complex monitoring setup) is like driving a car without a dashboard – you wouldn't know if you are speeding or low on fuel! Db2 needs a concise and simplified monitoring solution that gives a bird eye's view on the performance metrics and Db2 diagnostics. We present here a solution that is available in AWS, Azure, Google Cloud and IBM Cloud while running Db2 with a Infrastructure as a Service model.
The speaker will cover her experience of collaboration with all cloud vendors, Db2 development and customers like SAP. The session will share the findings from that reserach and development project and it is based on the cloud native monitoing solutions currently available. The solution consists of a smart combination of Db2 monitoring capabilities, Operating System scheduling and Cloud logging functionality resulting in an out–of–the–box Db2 monitoing solution.
The solution has the following features:

Displays the most important metrics (based on customer data) of a database instance namely, Bufferpool quality, Activities per second, Activity wait time and Logging performance.
Information regarding Db2 Diagnostics by providing the count of increasing errors that can be easily extended for a comprehensive diagnostic analysis. 
Whether or not the database is alive.

This solution introduces the Monitoring as a Service infrastructure and ables you to build your own cloud native monitoring solution with a few fingertips.

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.

Join our treasure hunt to uncover vital tips and tricks for maximizing your investment in Broadcom tools! In this session, discover effective strategies for managing deprecated objects, navigating UTS conversions, and ensuring recovery compliance. Equip yourself with practical tools to tackle immediate challenges and enhance your Db2 subsystem performance. With real-world case studies to guide you, you'll leave with actionable insights ready for immediate implementation. Don’t miss this opportunity to elevate your Db2 maintenance approach!

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.

Databases keep growing.  Many applications do not need the older data at certain age, which could vary from a few days to a few years.  Reducing the DB size can not only save storage, but also the backup/restore time, and more importantly improves the database performance, in most cases.  But, DELETE/REORG has always been a nightmare to DBAs, specially on large databases.  This presentation demonstrates a working system which purges the older data from DB2 databases, FAST (in seconds/minutes), with NO System down, NO DELETE/REORG involvement, which is pretty much independent of the database size.  The system also provides the option of old–data–archive before purging.

Managing distributed connections to Db2 and preventing rogue threads from causing issues has become a significant challenge for DBAs. Join this session to learn how to use profile tables to effectively monitor distributed threads and take proactive measures to mitigate the impact of potential threats. We will explore an innovative customer application of profiles that controls JDBC connections and redirects specific connections to the appropriate Db2 for z/OS release.

In the DevOps era, managing database schema as code is essential for agility and scalability. A key requirement is a streamlined method for provisioning Db2 schema with Ansible®, utilizing RESTful Db2 DevOps APIs for automation in CI/CD pipelines. By adopting this approach, organizations can modernize database operations and improve collaboration between developers and database administrators. In this session, you will learn to configure and execute an Ansible playbook to automate the deployment of Db2 schemas.

Learn how to use ansible playbooks to backup, restore Db2 databases locally or cross–node and automate all post–restore checks and validations.

If you are interested in Db2 Managed Services on the Cloud this is a great session to attend to get the very latest information. This session will review some of the recent updates to our Db2 managed services and in particular it will dive deeper into our upcoming managed Db2 cloud services on Azure. It will go over features, but also review the technical architecture behind a new SaaS deployment model which allows you to get the benefits of a managed service while hosting the infrastructure in your own cloud account.

This session will explore multiple strategies for enabling API access to your Db2 data. We will examine both direct API connections to Db2 and alternative mechanisms for accessing Db2 data through z/OS–enabled APIs. Attendees will gain insights into optimizing data accessibility and enhancing integration capabilities, empowering their applications to interact seamlessly with Db2 resources. Join us to explore practical approaches and best practices for leveraging APIs effectively in your Db2 environment.

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!