IDUG NA 2025: Full Schedule

arrow_back View All Dates

10:20am EDT

C10 | Automatic Fast DB Size Reduction, NO DELETE, NO REORG, NO System Down

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

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.

Speakers

Farid Hosseini

Tech Lead Database Engineer, Freddie Mac

Farid Hosseini is a former IBMer at DB2 Lab in late 90s and early 2000s, working as a DB2 consultant for decades with multiple mission critical organizations, resolved tough issues and currently working at Freddie Mac as a Tech lead Database Engineer.

Wednesday June 11, 2025 10:20am - 11:20am EDT
Spring

Technical Session, Operations & Automation

Audience Advanced
Subject LUW

11:30am EDT

C11 | Fear no Threads: Secure and Monitor Db2 Connections with Profile Tables

Wednesday June 11, 2025 11:30am - 12:30pm EDT

Spring

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.

Speakers

Toine Michielse

Manager, Client Services Consultants, Broadcom

I have been working with Db2 for z/OS ever since V1. In my career I have worked as COBOL/IMS/DB2 programmer, IMS/DB2 DBA and DB2 system engineer. I have also worked a number of years as a Db2 Lab advocate, supporting IBM customers worldwide. Before joining Broadcom I worked at SwissRe... Read More →

Wednesday June 11, 2025 11:30am - 12:30pm EDT
Spring

Technical Session, Operations & Automation

Audience All
Subject z/OS

2:00pm EDT

C12 | Provisioning Db2 Schema as Code – Using Ansible and DevOps APIs

Wednesday June 11, 2025 2:00pm - 3:00pm EDT

Spring

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.

Speakers

Sridhar Pratik Shanmugam

Staff Software Engineer, Broadcom

Sridhar Shanmugam has over 11 years of experience in designing and building Db2 for z/OS administration products. At Broadcom, he focuses on delivering high-quality products that support mission-critical applications. His expertise lies in quality assurance, automation, and leveraging... Read More →

Wednesday June 11, 2025 2:00pm - 3:00pm EDT
Spring

Technical Session, Operations & Automation

Audience All
Subject z/OS

4:30pm EDT

C13 | Automated Db2 Restores with Ansible Playbooks

Wednesday June 11, 2025 4:30pm - 5:30pm EDT

Spring

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

Speakers

Mohan Saraswatipura

Aish Khare

Infra Admin Engineer, Pru

Aish is the member of the CPC and IBM Champion.

Wednesday June 11, 2025 4:30pm - 5:30pm EDT
Spring

Technical Session, Operations & Automation

Audience Intermediate
Subject LUW