IDUG India 2024
Sessions, Speakers & Abstracts | Bengaluru & Mumbai
9:00 AM | IDUG Welcome
9:15 AM | Keynote / Featured Speaker
9:50 AM | Spotlights
Db2 for z/OS – Trends & Directions from the Lab
Haakon Roberts, IBM Silicon Valley Lab
For the past four decades, Db2 for z/OS has gained a reputation for rock solid stability and groundbreaking innovation. It has come to underpin much of the world’s economy and is depended upon by many of the largest corporations, enterprises and government agencies across the world. This session will look at the fundamental principles that have governed innovation from the start. We will assess where we are today with version 13 of Db2 and look to the future to make Db2 for z/OS the system of record for the next forty years.
Db2 for LUW – Trends & Directions from the Lab
Satya Krishnaswamy, IBM US
In this kick-off session we will go through an overview and a deep dive of recently shipped / announced db2 content including Db2 11.5.9, Db2 Warehouse on Cloud Gen 3, Next Generation Warehousing capabilities and our new Cloud Rack for Db2. We will also take a peak ahead on what clients can expect to see coming through 2024.
11:05 AM | Session #1
Db2 for z/OS – Application Development Made Easy (z/OS)
Sowmya Kameswaran, IBM Silicon Valley Lab
Interacting with Db2z on you host can be fast and easy wherever your code. Join us as we show you an example through both COBOL application development and using Python to illustrate how powerful and easy it is to do real work and accomplish your goals with Db2z in your chosen programming language.
Back to Basics – Triggers and Advanced Triggers (AppDev / a la Carte)
Jaspreet Kaur Dhoad & Pradip Wagh, BMC
Triggers move the business rule application logic into the database, which results in faster application development and easier maintenance. The business rule is centralized to the triggers and is no longer repeated in several applications. In Db2 12 for z/OS with new function mode activated, IBM enhanced support for triggers and introduced the object as an Advanced Trigger. IBM continues to support existing triggers from previous releases and refers to them as Basic Triggers.
Prior to Db2 version 12, Basic Triggers supported a limited set of SQL statements because of which the trigger text had to call a stored procedure to provide this additional capability. As a result, it took increased time to develop and deploy applications. Calling a stored procedure in the trigger text can be inefficient. This increases the cost of using Db2 for z/OS, degrades the application performance for CPU and elapsed time, and increases the maintenance cost to manage more objects and corresponding code.
Restrictions of Basic Trigger has been overcome by Advanced Trigger which provides support for complex and logical SQL/PLs such that, with Advanced Triggers, users can now directly use SQL/PL statements in the text instead of calling native SQL stored procedures. Advanced Triggers also provides enhancements like - ability to define and maintain multiple “Versions”, allowing users with debugging capabilities and to better align itself with the DB2 family and SQL standards.
We will also cover in this presentation the following topics:
• Introduction to Triggers and Event Driven Triggers
• Trigger Types and Differences (Basic and Advanced Trigger)
• Why Should you Care About Advanced Triggers?
• Advanced Trigger Operations, Syntax and Trigger Options
• Advanced Trigger Ordering and Versioning
• Trigger Restrictions, Considerations and Cascading Concepts
• Advanced Trigger Example
Note: Presentation History: Presented at GSE UK 2023
Analyzing EXPLAIN information with tips on how to improve Query Performance (LUW)
Calisto Zuzarte, IBM Canada
Query Performance and tuning is as relevant today as it was 30 years ago. While hardware, query optimizers and query performance efficiency in database system have had significant advances over many years, so has data volume increases, query complexities, workload increases, and user expectations. This presentation goes through constructs and information in query execution plans to identify potential bottlenecks. It provides tips on how one might use this information to tune for better query performance. In addition, we also look ahead at some optimization technology that we are considering to improve performance.
12:05 PM | Lunch
1:05 PM | Session #2
Scared of Conversion to Universal Tablespaces? Learn from Success Stories! (z/OS)
Rahul Bajaj, Broadcom
Are you still planning the migration to Universal tablespaces (UTS)? Are you scared of what can go wrong? Do you want to learn more from other users' experience? Then make sure to attend this session where we will go through several successful real life scenarios in detail. The main focus will be on single table and multi table segmented tablespaces conversions to Partition by Growth tablespaces (PBGs).
- Understand and Prepare for the Process of Migration to Universal Tablespaces (UTS)
- Address concerns related to UTS Migration
- Learn about conversion of Single and Multi-Table Segmented Tablespaces to Partition by Growth Tablespaces (PBGs)
Virtualize your IBM Z Data for Hybrid Cloud with IBM Data Virtualization Manager for z/OS (AppDev / a la Carte)
Vishal Gupta, IBM India
Data from IBM Z enterprise applications has become the lifeblood of new cloud, analytics, and mobile initiatives. Organizations embracing digital transformation are using this enterprise data to immediately embed business insights. The traditional way of ETL the data to data-lakes or data-warehouses introduces latency, and redundancy and makes data stale. In this session, we will talk about how the data on IBM Z including Db2 for z/OS can be accessed in place, real-time by hybrid cloud applications using IBM Data Virtualization Manager for z/OS.
IN BENGALURU ONLY | IBM watsonx Code Assistant for Red Hat Ansible Lightspeed (LUW)
Prasun Mahapatra, Consultant
In straightforward terms, Ansible is a user-friendly IT automation tool designed to assist with setting up infrastructure, installing software, and streamlining application automation with advanced workflows.
Using Ansible automation can simplify routine tasks, enhance security and compliance measures, manage system patches, and facilitate the sharing of automation processes across your organization. With Ansible, you can automate both z/OS applications and IT infrastructure, ensuring a reliable and standardized approach to enterprise automation strategies.
IN MUMBAI ONLY | Aggregation in Db2 (LUW)
Calisto Zuzarte, IBM Canada
This session looks at all the various forms of aggregation including regular aggregation, window aggregation and super aggregation. We look at the technology behind the aggregation operations and use cases. A good part of the session is devoted to performance considerations and tips on how one could improve the performance of queries involving aggregation on large volumes of data.
2:15 PM | Session #3
Db2 for z/OS Utilities – What’s New (z/OS)
Haakon Roberts, IBM Silicon Valley Lab
Kiran Seela, Rocket Software
There is a lot of excitement about the new utility history table in the Db2 catalog. In addition to that, Db2 for z/OS Utilities development continues to deliver other new availability, usability and performance enhancements. This session will cover what you need to know about utility history and the other features, many of which you can take advantage of today.
Recognizing Db2 for z/OS SMF Records and Their Significance (AppDev / a la Carte)
Hardik Chawda & Vishal Suryawanshi, BMC
The System Management Facility (SMF) is a logging function included into the IBM z/OS mainframe operating system that captures precise information about every operation that occurs within the system. This includes system-level information, application information, security information and events, transaction information, database information, and virtually anything else pertaining to the system's working environment. SMF data is likely the most comprehensive source of operational and security information on the mainframe.
In this beginner-level lesson, we'll look at the various forms of Db2 SMF data and their structure. This session will also demonstrate how SMF data may be used to perform audit checks and identify incompatible SQLs.
Optimizing Hash Join: Game-Changing Strategies (LUW)
Ajith Krishnan, IBM India
This presentation delves into the improvements implemented in the db2 columnar engine's hash join execution, with the primary objectives of reducing memory usage and optimizing overall performance. The session will cover key drivers, background information, the proposed solution, and performance metrics comparing the feature-enabled and disabled scenarios. Real-world examples and case studies will be used to illustrate the positive impact of these changes on hash join query execution. Whether your focus is on the enhancements made to the db2 columnar engine or on the broader improvements to hash join execution, this session will guide you through the significant enhancements that lead to substantial memory and performance improvements for hash join operations.
3:25 PM | Session #4
Watsonx.data and Db2 for z/OS data (z/OS)
Jonathan Sloan, Solution Architect
Transactional data is essential to understanding business performance and customer behavior. This data offers the greatest predictive value for AI applications and should be incorporated as part of a data lakehouse strategy. Why companies need a data lakehouse, what is their architecture, why IBM built an open data lakehouse and how Db2 Data Gate provides data to watsonx.data.
Database Availability. with. Pacemaker Implementation in Db2 (AppDev / a la Carte)
Vaisakh Gopal & Sanjay Rana, IBM India
Pacemaker is an open-source, high availability cluster manager software integrated with Db2® Advanced Edition and Db2 Standard Edition on Linux®.It provides high availability and disaster recovery capabilities for on-premises deployments and non-container cloud environments, such as Amazon Web Service (AWS). Today's session will go through installation , configuration of a simple clustered environment consisting of two nodes and setup of a HADR Db2 database within it. Also will illustrate the workings of Pacemaker and HADR with different scenario.
IN BENGALURU ONLY | Unified Insights: Harnessing the Power of IBM Watsonx.data and IBM Db2 (LUW)
Prasun Mahapatra, Consultant
IBM watsonx.data is an open, hybrid, governed data store optimized for all data, analytics, and AI workloads, built on a data lakehouse architecture. This system is built to make the most of two powerful tools called Parquet and Iceberg, which help store data efficiently on cloud storage. In recent years, the way we store and process data has changed. Now, we can separate where we store data from where we process it, and we can easily switch between different ways of processing it. With watsonx.data, we can use different processing methods without getting tangled up in managing the data itself.
With Db2 Database and watsonx.data, you can take data from your Db2 database, mix it with new data, and get fresh insights using a special setup called a data lakehouse. This setup helps you use artificial intelligence (AI) on a large scale. By moving data from Db2 to Db2 Warehouse or storing it in places like AWS S3 or IBM Cloud Object Storage, many people can share and use the data together with watsonx.data. This means everyone can work with the same data across different tools and systems, like data science and data visualization tools. With watsonx.data, you can use different ways to analyze your data, like Presto, Spark, Db2, and Netezza. This gives you more options for running your analytics and AI tasks in the way that works best for your needs.
In MUMBAI ONLY | Backup and Restore options with performance tuning of backup/restore in various Db2 Offerings (LUW)
Kanishka Mandal, IBM India
A database can become unusable because of hardware or software failure, or both. Protect your data against the possibility of loss by having a well rehearsed recovery strategy in place. In this presentation we will go through various backup /restore options and also some hints on performance tuning of backups and restore.
4:45 PM | Session #5
Inside Db2 for z/OS Indexes : Structure Demystified (z/OS)
Karthikeyan Dhanapal, BMC
"Indexes plays a pivotal role in optimizing the query performance and data retrieval"
Getting bored of hearing this statement repeatedly! and wondering about the magic behind database indexes?
In this session, we will be diving into the heart of it and will see about the internal structure of Db2 for z/OS indexes, how the Binary tree (Balanced) used in index management, and walk through on a scenario in which we can get the understanding the organization of index pages and how it lead to be the cause of slow performing queries?
With the journey through Db2 for z/OS index pages and leaf nodes, we can get a comprehensive and detailed insight into the foundational elements that impact the efficiency and effectiveness of database operations and this understanding would serve as a compass in navigating the complex terrain of database performance.
Introducing Amazon RDS for Db2 (AppDev / a la Carte)
Satya Krishnaswamy, IBM and Manish Punjabi, AWS
Customers use IBM Db2 to run some of the most mission critical workloads on the planet. These are the world’s largest banks & financial institutions, healthcare providers and insurers, car makers and manufacturers, multi-channel retailers, government agencies with some of strictest security standards – all trust Db2 every single day to keep their businesses & institutions going. It’s safe to say that Db2 is the invisible workhorse that powers the modern economy. Our customers count on us to continuously innovate, and enable them to accelerate their own innovation engines, like building the next generation of cutting-edge cloud & AI apps. And those customers expect us to make it ever easier to take advantage of the decades of innovation that’s built into Db2. We recently announced the availability of Amazon RDS for Db2. This brand-new offering makes it easy to run a fully-managed Db2 database on AWS via the RDS platform, with one-click create, built-in compute & storage scaling, backup/restore, high availability, out-of-box security, and consumption-based pricing model.
Cloud-Powered Db2 - Innovation Meets Scalability (LUW)
Rahul Prasad, IBM India
Db2 Warehouse NextGen is a high performant new offering that uses native cloud object storage. This session will do a deep-dive into the new architecture that reduces the cost at the same time enhances performance considerably. This will cover the thought processes that went into making what it is, the rationale and alternate ideas that were considered. Performance test run results that demonstrate and verify the solution will be presented as well. If you are looking to uptake the new Db2 offering, then this session will give a good idea of the product. Additionally how these changes dovetails nicely Into hosting this on Db2 on AWS RDS will also be explained. The added capabilities, advantages and familiarisation of Db2 on AWS RDS including a small demo shall also be presented.
6:00 - 7:30 PM | Exams