IDUG Brazil 2026

In the world of Db2 for z/OS, "set it and forget it" is a recipe for performance degradation and wasted storage. As data volumes explode and batch windows shrink, traditional housekeeping—REORG, RUNSTATS, and IMAGE COPY—must evolve from manual chores into a streamlined, automated strategy. This deep-dive workshop (not a hands-on lab) provides a comprehensive blueprint for modern Db2 maintenance. We will move past the basics to explore how to balance object availability with optimal performance. Attendees will learn how to leverage the latest utility enhancements to reduce CPU consumption, manage multi-terabyte objects, and ensure that the optimizer always has the "ground truth" through intelligent statistics collection.

In the world of Db2 for z/OS, "set it and forget it" is a recipe for performance degradation and wasted storage. As data volumes explode and batch windows shrink, traditional housekeeping—REORG, RUNSTATS, and IMAGE COPY—must evolve from manual chores into a streamlined, automated strategy. This deep-dive workshop (not a hands-on lab) provides a comprehensive blueprint for modern Db2 maintenance. We will move past the basics to explore how to balance object availability with optimal performance. Attendees will learn how to leverage the latest utility enhancements to reduce CPU consumption, manage multi-terabyte objects, and ensure that the optimizer always has the "ground truth" through intelligent statistics collection.

In the world of Db2 for z/OS, "set it and forget it" is a recipe for performance degradation and wasted storage. As data volumes explode and batch windows shrink, traditional housekeeping—REORG, RUNSTATS, and IMAGE COPY—must evolve from manual chores into a streamlined, automated strategy. This deep-dive workshop (not a hands-on lab) provides a comprehensive blueprint for modern Db2 maintenance. We will move past the basics to explore how to balance object availability with optimal performance. Attendees will learn how to leverage the latest utility enhancements to reduce CPU consumption, manage multi-terabyte objects, and ensure that the optimizer always has the "ground truth" through intelligent statistics collection.

Experience the new features of SQL Data Insights Pro, including unstructured text support, model training offloading to IDAA, and incremental retraining. SQL Data Insights Pro combines unsupervised deep learning with traditional SQL queries, allowing you to run similarity, dissimilarity, clustering, analogy, and commonality AI queries on your Db2 for z/OS data.

In this hands-on lab, learn how to train models using both structured and unstructured data to gain deeper insights from your enterprise data. With the new option to run model training on IDAA, you gain greater flexibility while saving valuable system resources. You will also learn how incremental retraining can save time and resources when updating models with new data.

With these capabilities, you can uncover hidden relationships across tables and views in your Db2 data, quickly gain actionable insights to address business problems as they arise, and confidently make better business decisions. In this lab, you will see how AI SQL queries can be applied to industry-specific domains to identify similarities, segment customers, and detect outliers within relational data.

Please bring your laptop and have your IBM ID ready to access the hands-on lab.

Experience the new features of SQL Data Insights Pro, including unstructured text support, model training offloading to IDAA, and incremental retraining. SQL Data Insights Pro combines unsupervised deep learning with traditional SQL queries, allowing you to run similarity, dissimilarity, clustering, analogy, and commonality AI queries on your Db2 for z/OS data.

In this hands-on lab, learn how to train models using both structured and unstructured data to gain deeper insights from your enterprise data. With the new option to run model training on IDAA, you gain greater flexibility while saving valuable system resources. You will also learn how incremental retraining can save time and resources when updating models with new data.

With these capabilities, you can uncover hidden relationships across tables and views in your Db2 data, quickly gain actionable insights to address business problems as they arise, and confidently make better business decisions. In this lab, you will see how AI SQL queries can be applied to industry-specific domains to identify similarities, segment customers, and detect outliers within relational data.

Please bring your laptop and have your IBM ID ready to access the hands-on lab.

Experience the new features of SQL Data Insights Pro, including unstructured text support, model training offloading to IDAA, and incremental retraining. SQL Data Insights Pro combines unsupervised deep learning with traditional SQL queries, allowing you to run similarity, dissimilarity, clustering, analogy, and commonality AI queries on your Db2 for z/OS data.

In this hands-on lab, learn how to train models using both structured and unstructured data to gain deeper insights from your enterprise data. With the new option to run model training on IDAA, you gain greater flexibility while saving valuable system resources. You will also learn how incremental retraining can save time and resources when updating models with new data.

With these capabilities, you can uncover hidden relationships across tables and views in your Db2 data, quickly gain actionable insights to address business problems as they arise, and confidently make better business decisions. In this lab, you will see how AI SQL queries can be applied to industry-specific domains to identify similarities, segment customers, and detect outliers within relational data.

Please bring your laptop and have your IBM ID ready to access the hands-on lab.