IDUG AU 2025

IDUG AU 2025

Welcome to the 2025 IDUG AU Db2 Tech Conference! Enjoy two days full of technical sessions in both Sydney and Canberra as well as complimentary workshops in Sydney that are available to all attendees between the two cities.

8:30am AEDT

S01 | Trends and Directions from the Lab

Monday March 17, 2025 8:30am - 9:20am AEDT

TBD

Speakers

Haakon Roberts

IBM

Haakon Roberts is an IBM Distinguished Engineer based at the Silicon Valley Laboratory in San Jose, California. He is the Director of the Db2 for z/OS and Tools organization and CTO of IBM z Data & AI. He holds several patents and is a leading expert in database management, data integrity... Read More →

Monday March 17, 2025 8:30am - 9:20am AEDT
Sydney

Technical Session

Audience Intermediate, Advanced
Platform z/OS

8:30am AEDT

S02 | Db2 Strategy Update

Monday March 17, 2025 8:30am - 9:20am AEDT

Join the product management leadership and development leadership to get an update on the Db2 business and the overall investment strategy we have in place for Db2 as we now deliver our first big new version in 5 years with Db2 12.1

Speakers

Miran Badzak

Satya Krishnaswamy

Monday March 17, 2025 8:30am - 9:20am AEDT
Sydney

Technical Session

Platform LUW

9:25am AEDT

A01 | Banking on the API economy

Monday March 17, 2025 9:25am - 10:20am AEDT

In this presentation I will discuss the value of REST API and open source to operational scenario’s. I will give concrete, working examples of how the exploitation of available REST API can optimize efficiency and productivity of your operations staff and subject matter experts.

Speakers

Toine Michielse

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 worked a number of years as a Db2 Lab advocate, supporting IBM customers worldwide. Before joining Broadcom I worked at SwissRe... Read More →

Monday March 17, 2025 9:25am - 10:20am AEDT
Sydney

Technical Session

Platform z/OS

9:25am AEDT

B01 | Latest From the Lab

Monday March 17, 2025 9:25am - 10:20am AEDT

Join the Db2 architects as they cover an overview of this significant new version of Db2 – Db2 12.1.0 and planned ModPaks such as Db2 12.1.1 and Db2 12.1.2. In this session the key highlights of Db2 12.1 will be covered as well as a sneak peak on what is to come through 2025.

Speakers

Mike Springgay

IBM

Mike Springgay is the Db2 Overall Architect. Prior to that he was responsible for exending Db2's SQL Compatibility features, routine infrastructure, client server connectivity and warehouse engine.

David Kalmuk

IBM

David Kalmuk is a Senior Technical Staff Member & Master Inventor and Data Warehousing Architect for the Db2 family products. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well... Read More →

Monday March 17, 2025 9:25am - 10:20am AEDT
Sydney

Technical Session

Platform LUW

10:30am AEDT

A02 | Learning and Best Practices for Db2 Data Recovery

Monday March 17, 2025 10:30am - 11:20am AEDT

TBD

Speakers

Kavitha Murthy

Bendigo and Adelaide Bank

Hi, I am Kavitha Murthy, a Mainframe Db2 DBA for 20 years now. My work experience has mostly been in Banks and Financial Services. Primarily a Db2 DBA with occasional stints as IMS and Datacom DBA. Worked in India, Singapore and now in Australia from past 5 years.

Monday March 17, 2025 10:30am - 11:20am AEDT
Sydney

Technical Session

Platform z/OS

10:30am AEDT

B02 | Secure your data across the Db2 stack

Monday March 17, 2025 10:30am - 11:20am AEDT

Data today is dynamic, distributed and in high demand as data holds critical information to help organizations make informed business decisions, recommendations, and predications to stay competitive and to provide a better customer experience. All this information is stored in a data repository either on-premises or in the cloud, and native approaches to support security and compliance can be operationally complex and don’t ensure data confidentiality. In this presentation, we will take technical deep dive on how to accomplish automated data discovery, classification, real-time activity monitoring and machine learning analytics to understand, detect and respond to suspicious activity, and discuss the different scalable architectures for monitoring and protecting your data. The session will also emphasis on how you can protect your databases and data against insider and external attacks by understanding how to leverage capabilities such as alerting, blocking, and quarantining users and/or processes of suspicious behaviour. In addition, we will demonstrate how to help your organization support audit and compliance activities for APP, PCI DSS, SOX, HIPAA and many more. This session will be valuable for novice to seasoned experts that are looking to learn, design and implement a solid data protection model for data across the enterprise.

Speakers

Pirabu Pathmasenan

IBM

Pirabu Pathmasenan has over 15 years of experience in Data & Analytics, Cybersecurity, Customer Success, and Consulting services; focused on innovation and simplification to help customers achieve their business results. Pirabu currently leads the Security Sales Engineering for the... Read More →

Monday March 17, 2025 10:30am - 11:20am AEDT
Sydney

Technical Session

Platform LUW

11:25am AEDT

A03 | A Day in the life of a Db2 schema

Monday March 17, 2025 11:25am - 12:15pm AEDT

There is a lot of talk about DevOps and agile development and with good reason. But what does this mean for a Db2 for Z/OS database administrator? In this presentation I will provide an overview of how the process of schema management can be organized with well accepted processes and tools. This will help to optimize the time of scarce DBA resources while safeguarding or even improving the quality of deliverables.

Speakers

Toine Michielse

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 worked a number of years as a Db2 Lab advocate, supporting IBM customers worldwide. Before joining Broadcom I worked at SwissRe... Read More →

Monday March 17, 2025 11:25am - 12:15pm AEDT
Sydney

Technical Session

Platform z/OS

11:25am AEDT

B03 | Wrapping Up Db2 11.5

Monday March 17, 2025 11:25am - 12:15pm AEDT

Now that we have delivered Db2 12.1 to the market – it’s an excellent time to take a holistic look at the baseline of high value capabilities in place leading in to Db2 12.1. This includes capabilities to support a Lake House, new security capabilities, schema level administration capabilities, optimizations for variable data types, the technology preview of the AI optimizer, AI capabilities, multi-model capabilities and much more. This is an overall summary of 11.5.4 through 11.5.9 inclusively.

Speakers

Les King

IBM

Les King has impacted the vision for IBM’s Hybrid Data Management strategies, which includes Big Data, Analytics, Database and Cloud Data Services by acting as a trusted advisor both to clients and within IBM. He has held this post for four years however; Les has 25 years of experience... Read More →

Monday March 17, 2025 11:25am - 12:15pm AEDT
Sydney

Technical Session

Platform LUW

1:30pm AEDT

A04 | Db2 for z/OS Performance and Monitoring Updates

Monday March 17, 2025 1:30pm - 2:20pm AEDT

Db2 for z/OS continues to improve the performance and enhance performance monitoring. This session discusses the latest major performance updates, recommendation as well as key monitoring updates on Db2 13. It will also include the recommended set of data collections on the various situations.

Speakers

Akiko Hoshikawa

IBM

Akiko Hoshikawa is a Distinguished Engineer at IBM Silicon Valley Laboratory in San Jose. As a Db2 for z/OS architect she has overall responsibility for overall performance, product simplification, and strategic integration of AI capability within IBM Db2 for z/OS, including the... Read More →

Monday March 17, 2025 1:30pm - 2:20pm AEDT
Sydney

Technical Session

Platform z/OS

1:30pm AEDT

B04 | Modernize your Analytical Workload

Monday March 17, 2025 1:30pm - 2:20pm AEDT

It is time to modernize your analytical workload to meet the demands of your growing data volumes, price-performance requirements, or application modernization needs. This session will cover the new enhancements that have been made to Db2 warehouse solution and will also take a look at post v12.1 enhancements, which will further push the envelope on capabilities and performance in the warehouse space.

Speakers

Bryan Tang

Bryan Tang is the Senior Product Manager from IBM Hybrid Data Management team.He is responsible for the roadmap and prioritization for Db2 Core Engine and Db2 Warehouse on-premises deployment

Monday March 17, 2025 1:30pm - 2:20pm AEDT
Sydney

Technical Session

Platform LUW

2:25pm AEDT

A05 | Stay Ahead of Cyber Threats: Your Strategic Game Plan!

Monday March 17, 2025 2:25pm - 3:15pm AEDT

Manual

Speakers

Devanand Karunakaran

BMC

Devanand Karunakaran, Senior Solution Engineer at BMC Software. In this role, he helps customers maximize the value of BMC AMI Data Solutions. Dev has previous experience as a Database Administrator, managing Db2 and IMS databases for telecommunications and retail customers. He specializes... Read More →

Monday March 17, 2025 2:25pm - 3:15pm AEDT
Sydney

Technical Session

Platform z/OS

2:25pm AEDT

B05 | Achieving Success in Implementation, Migration, and Conversion: A Strategic Approach

Monday March 17, 2025 2:25pm - 3:15pm AEDT

Manual

Speakers

Pushpa Herath

Artists

B08 | Optimized Performance and Advanced Features

Monday March 17, 2025 2:25pm - 3:15pm AEDT
Sydney

Technical Session

Platform LUW

3:30pm AEDT

A06 | Db2 Analytics Accelerator: product updates, VNext, and customer experiences from the field

Monday March 17, 2025 3:30pm - 4:20pm AEDT

Manual

Speakers

Cünext Göksu

Monday March 17, 2025 3:30pm - 4:20pm AEDT
Sydney

Technical Session

Platform z/OS

3:30pm AEDT

B06 | Db2 Warehouse Update

Monday March 17, 2025 3:30pm - 4:20pm AEDT

Warehouse environments continue to be very much in use in many Enterprises in the Data Platform space. These environments need to provide the high performance requirements that are required of them, and in addition provide a cheaper, integrated option in the larger Data platform context. Learn what Db2 Warehouse has to offer in the on-prem and the SaaS space and how they expose these capabilities that are required of them.

Speakers

Mike Springgay

IBM

Mike Springgay is the Db2 Overall Architect. Prior to that he was responsible for exending Db2's SQL Compatibility features, routine infrastructure, client server connectivity and warehouse engine.

Monday March 17, 2025 3:30pm - 4:20pm AEDT
Sydney

Technical Session

Platform LUW

3:30pm AEDT

B06 | Db2 Warehouse Update

Monday March 17, 2025 3:30pm - 4:20pm AEDT

Warehouse environments continue to be very much in use in many Enterprises in the Data Platform space. These environments need to provide the high performance requirements that are required of them, and in addition provide a cheaper, integrated option in the larger Data platform context. Learn what Db2 Warehouse has to offer in the on-prem and the SaaS space and how they expose these capabilities that are required of them.

Speakers

Mike Springgay

IBM

Mike Springgay is the Db2 Overall Architect. Prior to that he was responsible for exending Db2's SQL Compatibility features, routine infrastructure, client server connectivity and warehouse engine.

Monday March 17, 2025 3:30pm - 4:20pm AEDT
Sydney

Technical Session

Platform LUW

4:25pm AEDT

A07 | Taking SQL Functions to the Next Level

Monday March 17, 2025 4:25pm - 5:15pm AEDT

SQL Functions enable customers to improved productivity, performance, enable cross platform porting, and encapsulate application logic in the database. Db2 for z/OS supports Built in Functions that Aggregate data, operate on scalar data, as well as materialize data as a table. Db2 also enables customers to create functions to in Host languages (such as COBOL or C/C++) or in SQL PL (The ANSI compatible SQL Procedures Language). Finally, Db2 13 also introduced SQL Data Insights which allows easy, function based AI, to be applied to customer data. This session will cover the basics, as well as dig deeper into how to exploit all the Function(al) capabilities of Db2 to take your SQL queries to new levels.

Speakers

Chris Crone

Broadcom

Chris is a Distinguished Engineer for Database Technology and a lead architectfor the Data Management portfolio within the Mainframe Division of BroadcomSoftware Group. He oversees strategy and architecture decisions for theBroadcom database products IDMS and Datacom, as well as for... Read More →

Monday March 17, 2025 4:25pm - 5:15pm AEDT
Sydney

Technical Session

Platform z/OS

4:25pm AEDT

B07 | One Data Movement Approach for all Mission Critical Workloads

Monday March 17, 2025 4:25pm - 5:15pm AEDT

Moving catalog objects and data can become complicated when handling big/little endian formats or row/columnar formats, source/destination differences, constituting object dependencies and managing data integrity. IBM Db2 Bridge is the outcome of our mission in alleviating the pain and making your life easier. Join us!

Speakers

Mike Springgay

IBM

Mike Springgay is the Db2 Overall Architect. Prior to that he was responsible for exending Db2's SQL Compatibility features, routine infrastructure, client server connectivity and warehouse engine.

David Kalmuk

IBM

David Kalmuk is a Senior Technical Staff Member & Master Inventor and Data Warehousing Architect for the Db2 family products. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well... Read More →

Monday March 17, 2025 4:25pm - 5:15pm AEDT
Sydney

Technical Session

Platform LUW

8:30am AEDT

S03 | Db2 for z/OS Utilities Update

Tuesday March 18, 2025 8:30am - 9:20am AEDT

TBD

Speakers

Haakon Roberts

IBM

Haakon Roberts is an IBM Distinguished Engineer based at the Silicon Valley Laboratory in San Jose, California. He is the Director of the Db2 for z/OS and Tools organization and CTO of IBM z Data & AI. He holds several patents and is a leading expert in database management, data integrity... Read More →

Tuesday March 18, 2025 8:30am - 9:20am AEDT
Sydney

Technical Session

Platform z/OS

8:30am AEDT

S04 | Db2 12.1 - Optimized Performance and Advanced Feature

Tuesday March 18, 2025 8:30am - 9:20am AEDT

Manual

Speakers

Ajay Patil

Tuesday March 18, 2025 8:30am - 9:20am AEDT
Sydney

Technical Session

Platform LUW

9:25am AEDT

A08 | Playing (with) FETCH

Tuesday March 18, 2025 9:25am - 10:20am AEDT

This session will delve into the many ways to get data out of Db2. These vary from SELECT INTO; to SELECT FROM FINAL TABLE; to FETCH FOR :N ROWS; to RESULT SETS. Db2 has evolved over the years and there are many ways to get data from Db2 - this session will be both a primer and a review.

Speakers

Chris Crone

Broadcom

Chris is a Distinguished Engineer for Database Technology and a lead architectfor the Data Management portfolio within the Mainframe Division of BroadcomSoftware Group. He oversees strategy and architecture decisions for theBroadcom database products IDMS and Datacom, as well as for... Read More →

Tuesday March 18, 2025 9:25am - 10:20am AEDT
Sydney

Technical Session

Platform z/OS

9:25am AEDT

B08 | Database AI Assistant

Tuesday March 18, 2025 9:25am - 10:20am AEDT

This session will introduce you to the new IBM DBA AI assistant, a new AI powered tool designed for DBAs that provides insights and smart recommendations through a natural language chat interface. Leveraging Large Language Models (LLMs) in combination with a wide knowledge base and telemetry from your database fleet, the assistant acts as a copilot that can streamline information retrieval and help you to quickly answer questions and troubleshoot problems on your database systems.

Speakers

David Kalmuk

IBM

David Kalmuk is a Senior Technical Staff Member & Master Inventor and Data Warehousing Architect for the Db2 family products. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well... Read More →

Shaikh Quader

IBM

Shaikh Quader is the AI architect at IBM Db2. His role involves developing product features to enhance database operations with AI and allow users in implementing AI solutions with Db2. Shaikh also manages research collaborations between IBM and Canadian universities. He and his team... Read More →

Tuesday March 18, 2025 9:25am - 10:20am AEDT
Sydney

Technical Session

Platform LUW

10:30am AEDT

A09 | Configuring Db2 on Z for SMF collection on very large systems

Tuesday March 18, 2025 10:30am - 11:20am AEDT

Working with some of the worlds largest banks I have come across unique issues which require a combination of ZPARM changes and software configuration. In this session I will give background on some of the issues I have experiences, and how these were solved.

Speakers

Pete Meers

21CS

Pete Meers has over 2 decades of experience with Db2 on IBM Z systems as a DBA, software designer, programmer. He has recently been working as Mainframe Data Scientist on IBM Z Performance and Capacity Analytics, where he creates algorithms to analyse SMF records for performance tuning... Read More →

Tuesday March 18, 2025 10:30am - 11:20am AEDT
Sydney

Technical Session

Platform z/OS

10:30am AEDT

B09 | SQL Extensions Db2 11 Onwards

Tuesday March 18, 2025 10:30am - 11:20am AEDT

Catchup on all the new SQL capabilities added to Db2 over the course of 11.1, 11.5, 12.1 GA and the recent mod packs. Take a sneak peak at up coming enhancements being considered for a future Db2.

Speakers

Mike Springgay

IBM

Mike Springgay is the Db2 Overall Architect. Prior to that he was responsible for exending Db2's SQL Compatibility features, routine infrastructure, client server connectivity and warehouse engine.

Tuesday March 18, 2025 10:30am - 11:20am AEDT
Sydney

Technical Session

Platform LUW

11:25am AEDT

A10 | z/OS Expert Panel

Tuesday March 18, 2025 11:25am - 12:15pm AEDT

Speakers

T

TBD

Tuesday March 18, 2025 11:25am - 12:15pm AEDT
Sydney

Technical Session

Platform z/OS

11:25am AEDT

B10 | LUW Expert Panel

Tuesday March 18, 2025 11:25am - 12:15pm AEDT

TBD

Speakers

T

TBD

Tuesday March 18, 2025 11:25am - 12:15pm AEDT
Sydney

Technical Session

Platform Cross Platform

1:30pm AEDT

A11 | Unlocking the Power of AI with Db2 for z/OS

Tuesday March 18, 2025 1:30pm - 2:20pm AEDT

Manual

Speakers

Akiko Hoshikawa

IBM

Akiko Hoshikawa is a Distinguished Engineer at IBM Silicon Valley Laboratory in San Jose. As a Db2 for z/OS architect she has overall responsibility for overall performance, product simplification, and strategic integration of AI capability within IBM Db2 for z/OS, including the... Read More →

Tuesday March 18, 2025 1:30pm - 2:20pm AEDT
Sydney

Technical Session

Platform z/OS

1:30pm AEDT

B11 | Db2 Datalake Tables and Integration with the Data Lakehouse

Tuesday March 18, 2025 1:30pm - 2:20pm AEDT

The use of object storage and open data and table formats, like Parquet, ORC, and Iceberg, are becoming common place in data management. Db2 has embraced this with the introduction of a new datalake table type, which allows Db2 table data to be stored outside of the database, using these open formats. In this session, you’ll learn more about datalake tables, including use cases, benefits, and how to create and work with them. Additionally, you’ll see how this and other new capabilities allow Db2 to tightly integrate with watsonx.data, IBM’s hybrid, open data lakehouse platform. The data lakehouse is the latest architecture in the evolution of data management, but rather than a replacement for enterprise data warehouses, the data lakehouse is poised to bring value by augmenting and optimizing them.

Speakers

Kelly Schlamb

Tuesday March 18, 2025 1:30pm - 2:20pm AEDT
Sydney

Technical Session

Platform LUW

2:25pm AEDT

A12 | Back to Basics Triggers and Advanced Triggers

Tuesday March 18, 2025 2:25pm - 3:15pm AEDT

Speakers

Frank Rhodes

BMC

Frank RhodesSenior Product Development Architect, DB2 Administration ProductsFrank Rhodes started with BMC Software in 1995. In his current role he works to promote cross product coordination between the Database Administration products and the other BMC DB2 products. The products... Read More →

Tuesday March 18, 2025 2:25pm - 3:15pm AEDT
Sydney

Technical Session

Platform z/OS

2:25pm AEDT

B12 | Db2 OLTP SaaS Update

Tuesday March 18, 2025 2:25pm - 3:15pm AEDT

Db2 has a wide range of services available across cloud providers like AWS, Azure and IBM Cloud. This session will provide a technical overview of some of the recent updates to these services and offerings as well as provide a sneak peak of what’s to come.

Speakers

Andrew Hilden

IBM

Andrew Hilden is the Chief Architect of Db2 SaaS. He is involved extensively in the development and architecture of several data-oriented cloud services in IBM. In the past 25 years he has worked in development, architectural and leadership roles in Db2 from SaaS to areas like appliances... Read More →

Tuesday March 18, 2025 2:25pm - 3:15pm AEDT
Sydney

Technical Session

Platform LUW

3:30pm AEDT

A13 | How to access Db2 for z/OS (and other Z oriented) data in the cloud

Tuesday March 18, 2025 3:30pm - 4:20pm AEDT

Manual

Speakers

Cüneyt Göksu

IBM

Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, Bachelor’s degree and PhD in ComputerScience. He has been working with Db2 for z/OS and IBM Z Platform... Read More →

Tuesday March 18, 2025 3:30pm - 4:20pm AEDT
Sydney

Technical Session

Platform z/OS

3:30pm AEDT

B13 | IBM Db2: A Database of AI, A Database for AI

Tuesday March 18, 2025 3:30pm - 4:20pm AEDT

IBM Db2 has introduced several AI features in recent years. These features fall into two categories: AI for database and database for AI. In the first category, Db2 has AI models in the database to optimize database operations. A key example is the AI query optimizer GA’d in v12. In the second category, Db2 has integrated machine learning algorithms into the database for users' AI use cases. It provides over 200 in-database AI stored procedures that allow users to develop and run ML pipelines within the database. Db2 also supports Python and R UDFs, enabling users to use their external Python and R models from Db2. These AI features improve database operations and simplify enterprise AI workflows. This session will explore Db2’s AI features from both categories and show how you can use them in developing modern data-driven applications and enterprise workloads.

Speakers

Shaikh Quader

IBM

Shaikh Quader is the AI architect at IBM Db2. His role involves developing product features to enhance database operations with AI and allow users in implementing AI solutions with Db2. Shaikh also manages research collaborations between IBM and Canadian universities. He and his team... Read More →

Tuesday March 18, 2025 3:30pm - 4:20pm AEDT
Sydney

Technical Session

Platform LUW

4:25pm AEDT

A14 | Partitioning Advances: PBR and PBR RPN

Tuesday March 18, 2025 4:25pm - 5:15pm AEDT

Manual

Speakers

Frank Rhodes

BMC

Frank RhodesSenior Product Development Architect, DB2 Administration ProductsFrank Rhodes started with BMC Software in 1995. In his current role he works to promote cross product coordination between the Database Administration products and the other BMC DB2 products. The products... Read More →

Tuesday March 18, 2025 4:25pm - 5:15pm AEDT
Sydney

Technical Session

Platform z/OS

4:25pm AEDT

B14 | Enhancing Uptime and Availability Like Never Before

Tuesday March 18, 2025 4:25pm - 5:15pm AEDT

In this session, we will deep dive the important Backup and Restore enhancements. Likewise, we will go through the pain point of Db2 users and how does the latest enhancement saves time and money for the mission critical applications. Intra-table-space Parallelism (ITP) for backup operations. Automatic Db2 backup enhancements. New Registry variable DB2_VALIDATE_LOG_ON_ARCHIVE. ZLIB compression for backup and log file compression. Offline backup requirement lifted, following a drop member topology change event. Support for database and table space restore involving dropped members in a Db2 pureScale environment. Support for database and table space rollforward through a drop member topology change event in a Db2 pureScale environment. Replication enhancement using the db2ReadLog API in a Db2 pureScale environment. Changes to LIST HISTORY, DB_HISTORY and b2HistoryData data structure.

Speakers

Shashank Kharche

Tuesday March 18, 2025 4:25pm - 5:15pm AEDT
Sydney

Technical Session

Platform LUW

8:30am AEDT

S05 | Trends and Directions from the Lab

Thursday March 20, 2025 8:30am - 9:20am AEDT

TBD

Speakers

Haakon Roberts

IBM

Haakon Roberts is an IBM Distinguished Engineer based at the Silicon Valley Laboratory in San Jose, California. He is the Director of the Db2 for z/OS and Tools organization and CTO of IBM z Data & AI. He holds several patents and is a leading expert in database management, data integrity... Read More →

Thursday March 20, 2025 8:30am - 9:20am AEDT
Canberra

Technical Session

Platform z/OS

8:30am AEDT

S06 | Db2 Strategy Update

Thursday March 20, 2025 8:30am - 9:20am AEDT

Join the product management leadership and development leadership to get an update on the Db2 business and the overall investment strategy we have in place for Db2 as we now deliver our first big new version in 5 years with Db2 12.1

Speakers

Miran Badzak

Satya Krishnaswamy

Thursday March 20, 2025 8:30am - 9:20am AEDT
Canberra

Technical Session

Platform LUW

9:25am AEDT

A15 | Banking on the API economy

Thursday March 20, 2025 9:25am - 10:20am AEDT

In this presentation I will discuss the value of REST API and open source to operational scenario’s. I will give concrete, working examples of how the exploitation of available REST API can optimize efficiency and productivity of your operations staff and subject matter experts.

Speakers

Toine Michielse

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 worked a number of years as a Db2 Lab advocate, supporting IBM customers worldwide. Before joining Broadcom I worked at SwissRe... Read More →

Thursday March 20, 2025 9:25am - 10:20am AEDT
Canberra

Technical Session

Platform z/OS

9:25am AEDT

B15 | Latest From the Lab

Thursday March 20, 2025 9:25am - 10:20am AEDT

Join the Db2 architects as they cover an overview of this significant new version of Db2 – Db2 12.1.0 and planned ModPaks such as Db2 12.1.1 and Db2 12.1.2. In this session the key highlights of Db2 12.1 will be covered as well as a sneak peak on what is to come through 2025.

Speakers

Mike Springgay

IBM

Mike Springgay is the Db2 Overall Architect. Prior to that he was responsible for exending Db2's SQL Compatibility features, routine infrastructure, client server connectivity and warehouse engine.

David Kalmuk

IBM

David Kalmuk is a Senior Technical Staff Member & Master Inventor and Data Warehousing Architect for the Db2 family products. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well... Read More →

Thursday March 20, 2025 9:25am - 10:20am AEDT
Sydney

Technical Session

Platform LUW

10:30am AEDT

A16 | Title TBD

Thursday March 20, 2025 10:30am - 11:20am AEDT

TBD

Speakers

Kavitha Murthy

Bendigo and Adelaide Bank

Hi, I am Kavitha Murthy, a Mainframe Db2 DBA for 20 years now. My work experience has mostly been in Banks and Financial Services. Primarily a Db2 DBA with occasional stints as IMS and Datacom DBA. Worked in India, Singapore and now in Australia from past 5 years.

Thursday March 20, 2025 10:30am - 11:20am AEDT
Canberra

Technical Session

Platform z/OS

10:30am AEDT

B16 | Secure your data across the Db2 stack

Thursday March 20, 2025 10:30am - 11:20am AEDT

Data today is dynamic, distributed and in high demand as data holds critical information to help organizations make informed business decisions, recommendations, and predications to stay competitive and to provide a better customer experience. All this information is stored in a data repository either on-premises or in the cloud, and native approaches to support security and compliance can be operationally complex and don’t ensure data confidentiality. In this presentation, we will take technical deep dive on how to accomplish automated data discovery, classification, real-time activity monitoring and machine learning analytics to understand, detect and respond to suspicious activity, and discuss the different scalable architectures for monitoring and protecting your data. The session will also emphasis on how you can protect your databases and data against insider and external attacks by understanding how to leverage capabilities such as alerting, blocking, and quarantining users and/or processes of suspicious behaviour. In addition, we will demonstrate how to help your organization support audit and compliance activities for APP, PCI DSS, SOX, HIPAA and many more. This session will be valuable for novice to seasoned experts that are looking to learn, design and implement a solid data protection model for data across the enterprise.

Speakers

Pirabu Pathmasenan

IBM

Pirabu Pathmasenan has over 15 years of experience in Data & Analytics, Cybersecurity, Customer Success, and Consulting services; focused on innovation and simplification to help customers achieve their business results. Pirabu currently leads the Security Sales Engineering for the... Read More →

Thursday March 20, 2025 10:30am - 11:20am AEDT
Sydney

Technical Session

Platform LUW

11:25am AEDT

A17 | A Day in the life of a Db2 schema

Thursday March 20, 2025 11:25am - 12:15pm AEDT

There is a lot of talk about DevOps and agile development and with good reason. But what does this mean for a Db2 for Z/OS database administrator? In this presentation I will provide an overview of how the process of schema management can be organized with well accepted processes and tools. This will help to optimize the time of scarce DBA resources while safeguarding or even improving the quality of deliverables.

Speakers

Toine Michielse

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 worked a number of years as a Db2 Lab advocate, supporting IBM customers worldwide. Before joining Broadcom I worked at SwissRe... Read More →

Thursday March 20, 2025 11:25am - 12:15pm AEDT
Canberra

Technical Session

Platform z/OS

11:25am AEDT

B17 | Wrapping Up Db2 11.5

Thursday March 20, 2025 11:25am - 12:15pm AEDT

Now that we have delivered Db2 12.1 to the market – it’s an excellent time to take a holistic look at the baseline of high value capabilities in place leading in to Db2 12.1. This includes capabilities to support a Lake House, new security capabilities, schema level administration capabilities, optimizations for variable data types, the technology preview of the AI optimizer, AI capabilities, multi-model capabilities and much more. This is an overall summary of 11.5.4 through 11.5.9 inclusively.

Speakers

Les King

IBM

Les King has impacted the vision for IBM’s Hybrid Data Management strategies, which includes Big Data, Analytics, Database and Cloud Data Services by acting as a trusted advisor both to clients and within IBM. He has held this post for four years however; Les has 25 years of experience... Read More →

Thursday March 20, 2025 11:25am - 12:15pm AEDT
Sydney

Technical Session

Platform LUW

1:30pm AEDT

A18 | Db2 for z/OS Performance and Monitoring Updates

Thursday March 20, 2025 1:30pm - 2:20pm AEDT

Db2 for z/OS continues to improve the performance and enhance performance monitoring. This session discusses the latest major performance updates, recommendation as well as key monitoring updates on Db2 13. It will also include the recommended set of data collections on the various situations.

Speakers

Akiko Hoshikawa

IBM

Akiko Hoshikawa is a Distinguished Engineer at IBM Silicon Valley Laboratory in San Jose. As a Db2 for z/OS architect she has overall responsibility for overall performance, product simplification, and strategic integration of AI capability within IBM Db2 for z/OS, including the... Read More →

Thursday March 20, 2025 1:30pm - 2:20pm AEDT
Canberra

Technical Session

Platform z/OS

1:30pm AEDT

B18 | Modernize your Analytical Workload

Thursday March 20, 2025 1:30pm - 2:20pm AEDT

It is time to modernize your analytical workload to meet the demands of your growing data volumes, price-performance requirements, or application modernization needs. This session will cover the new enhancements that have been made to Db2 warehouse solution and will also take a look at post v12.1 enhancements, which will further push the envelope on capabilities and performance in the warehouse space.

Speakers

Bryan Tang

Bryan Tang is the Senior Product Manager from IBM Hybrid Data Management team.He is responsible for the roadmap and prioritization for Db2 Core Engine and Db2 Warehouse on-premises deployment

Thursday March 20, 2025 1:30pm - 2:20pm AEDT
Sydney

Technical Session

Platform LUW

2:25pm AEDT

A19 | Stay Ahead of Cyber Threats: Your Strategic Game Plan!

Thursday March 20, 2025 2:25pm - 3:15pm AEDT

Manual

Speakers

Devanand Karunakaran

BMC

Devanand Karunakaran, Senior Solution Engineer at BMC Software. In this role, he helps customers maximize the value of BMC AMI Data Solutions. Dev has previous experience as a Database Administrator, managing Db2 and IMS databases for telecommunications and retail customers. He specializes... Read More →

Thursday March 20, 2025 2:25pm - 3:15pm AEDT
Canberra

Technical Session

Platform z/OS

2:25pm AEDT

B19 | Achieving Success in Implementation, Migration, and Conversion: A Strategic Approach

Thursday March 20, 2025 2:25pm - 3:15pm AEDT

Manual

Speakers

Pushpa Herath

Thursday March 20, 2025 2:25pm - 3:15pm AEDT
Sydney

Technical Session

Platform LUW

3:30pm AEDT

A20 | Db2 Analytics Accelerator: product updates, VNext, and customer experiences from the field

Thursday March 20, 2025 3:30pm - 4:20pm AEDT

Manual

Speakers

Cünext Göksu

Thursday March 20, 2025 3:30pm - 4:20pm AEDT
Canberra

Technical Session

Platform z/OS

3:30pm AEDT

B20 | Db2 Warehouse Update

Thursday March 20, 2025 3:30pm - 4:20pm AEDT

Warehouse environments continue to be very much in use in many Enterprises in the Data Platform space. These environments need to provide the high performance requirements that are required of them, and in addition provide a cheaper, integrated option in the larger Data platform context. Learn what Db2 Warehouse has to offer in the on-prem and the SaaS space and how they expose these capabilities that are required of them.

Speakers

Mike Springgay

IBM

Mike Springgay is the Db2 Overall Architect. Prior to that he was responsible for exending Db2's SQL Compatibility features, routine infrastructure, client server connectivity and warehouse engine.

Thursday March 20, 2025 3:30pm - 4:20pm AEDT
Sydney

Technical Session

Platform LUW

4:25pm AEDT

A21 | Taking SQL Functions to the Next Level

Thursday March 20, 2025 4:25pm - 5:15pm AEDT

SQL Functions enable customers to improved productivity, performance, enable cross platform porting, and encapsulate application logic in the database. Db2 for z/OS supports Built in Functions that Aggregate data, operate on scalar data, as well as materialize data as a table. Db2 also enables customers to create functions to in Host languages (such as COBOL or C/C++) or in SQL PL (The ANSI compatible SQL Procedures Language). Finally, Db2 13 also introduced SQL Data Insights which allows easy, function based AI, to be applied to customer data. This session will cover the basics, as well as dig deeper into how to exploit all the Function(al) capabilities of Db2 to take your SQL queries to new levels.

Speakers

Chris Crone

Broadcom

Chris is a Distinguished Engineer for Database Technology and a lead architectfor the Data Management portfolio within the Mainframe Division of BroadcomSoftware Group. He oversees strategy and architecture decisions for theBroadcom database products IDMS and Datacom, as well as for... Read More →

Thursday March 20, 2025 4:25pm - 5:15pm AEDT
Canberra

Technical Session

Platform z/OS

4:25pm AEDT

B21 | One Data Movement Approach for all Mission Critical Workloads

Thursday March 20, 2025 4:25pm - 5:15pm AEDT

Moving catalog objects and data can become complicated when handling big/little endian formats or row/columnar formats, source/destination differences, constituting object dependencies and managing data integrity. IBM Db2 Bridge is the outcome of our mission in alleviating the pain and making your life easier. Join us!

Speakers

Mike Springgay

IBM

Mike Springgay is the Db2 Overall Architect. Prior to that he was responsible for exending Db2's SQL Compatibility features, routine infrastructure, client server connectivity and warehouse engine.

David Kalmuk

IBM

David Kalmuk is a Senior Technical Staff Member & Master Inventor and Data Warehousing Architect for the Db2 family products. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well... Read More →

Thursday March 20, 2025 4:25pm - 5:15pm AEDT
Sydney

Technical Session

Platform LUW

8:30am AEDT

S07 | Db2 for z/OS Utilities Update

Friday March 21, 2025 8:30am - 9:20am AEDT

TBD

Speakers

Haakon Roberts

IBM

Haakon Roberts is an IBM Distinguished Engineer based at the Silicon Valley Laboratory in San Jose, California. He is the Director of the Db2 for z/OS and Tools organization and CTO of IBM z Data & AI. He holds several patents and is a leading expert in database management, data integrity... Read More →

Friday March 21, 2025 8:30am - 9:20am AEDT
Canberra

Technical Session

Platform z/OS

8:30am AEDT

S08 | Db2 12.1 - Optimized Performance and Advanced Feature

Friday March 21, 2025 8:30am - 9:20am AEDT

Manual

Speakers

Ajay Patil

Friday March 21, 2025 8:30am - 9:20am AEDT
Canberra

Technical Session

Platform LUW

9:25am AEDT

A22 | Playing (with) FETCH

Friday March 21, 2025 9:25am - 10:20am AEDT

This session will delve into the many ways to get data out of Db2. These vary from SELECT INTO; to SELECT FROM FINAL TABLE; to FETCH FOR :N ROWS; to RESULT SETS. Db2 has evolved over the years and there are many ways to get data from Db2 - this session will be both a primer and a review.

Speakers

Chris Crone

Broadcom

Chris is a Distinguished Engineer for Database Technology and a lead architectfor the Data Management portfolio within the Mainframe Division of BroadcomSoftware Group. He oversees strategy and architecture decisions for theBroadcom database products IDMS and Datacom, as well as for... Read More →

Friday March 21, 2025 9:25am - 10:20am AEDT
Canberra

Technical Session

Platform z/OS

9:25am AEDT

B22 | Database AI Assistant

Friday March 21, 2025 9:25am - 10:20am AEDT

This session will introduce you to the new IBM DBA AI assistant, a new AI powered tool designed for DBAs that provides insights and smart recommendations through a natural language chat interface. Leveraging Large Language Models (LLMs) in combination with a wide knowledge base and telemetry from your database fleet, the assistant acts as a copilot that can streamline information retrieval and help you to quickly answer questions and troubleshoot problems on your database systems.

Speakers

David Kalmuk

IBM

David Kalmuk is a Senior Technical Staff Member & Master Inventor and Data Warehousing Architect for the Db2 family products. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well... Read More →

Shaikh Quader

IBM

Shaikh Quader is the AI architect at IBM Db2. His role involves developing product features to enhance database operations with AI and allow users in implementing AI solutions with Db2. Shaikh also manages research collaborations between IBM and Canadian universities. He and his team... Read More →

Friday March 21, 2025 9:25am - 10:20am AEDT
Sydney

Technical Session

Platform LUW

10:30am AEDT

A23 | Configuring Db2 on Z for SMF collection on very large systems

Friday March 21, 2025 10:30am - 11:20am AEDT

Working with some of the worlds largest banks I have come across unique issues which require a combination of ZPARM changes and software configuration. In this session I will give background on some of the issues I have experiences, and how these were solved.

Speakers

Pete Meers

21CS

Pete Meers has over 2 decades of experience with Db2 on IBM Z systems as a DBA, software designer, programmer. He has recently been working as Mainframe Data Scientist on IBM Z Performance and Capacity Analytics, where he creates algorithms to analyse SMF records for performance tuning... Read More →

Friday March 21, 2025 10:30am - 11:20am AEDT
Canberra

Technical Session

Platform z/OS

10:30am AEDT

B23 | SQL Extensions Db2 11 Onwards

Friday March 21, 2025 10:30am - 11:20am AEDT

Catchup on all the new SQL capabilities added to Db2 over the course of 11.1, 11.5, 12.1 GA and the recent mod packs. Take a sneak peak at up coming enhancements being considered for a future Db2.

Speakers

Mike Springgay

IBM

Mike Springgay is the Db2 Overall Architect. Prior to that he was responsible for exending Db2's SQL Compatibility features, routine infrastructure, client server connectivity and warehouse engine.

Friday March 21, 2025 10:30am - 11:20am AEDT
Sydney

Technical Session

Platform LUW

11:25am AEDT

A24 | z/OS Expert Panel

Friday March 21, 2025 11:25am - 12:15pm AEDT

TBD

Speakers

T

TBD

Friday March 21, 2025 11:25am - 12:15pm AEDT
Canberra

Technical Session

11:25am AEDT

B24 | LUW Expert Panel

Friday March 21, 2025 11:25am - 12:15pm AEDT

TBD

Speakers

T

TBD

Friday March 21, 2025 11:25am - 12:15pm AEDT
Sydney

Technical Session

Platform Cross Platform

1:30pm AEDT

A25 | Unlocking the Power of AI with Db2 for z/OS

Friday March 21, 2025 1:30pm - 2:20pm AEDT

Manual

Speakers

Akiko Hoshikawa

IBM

Akiko Hoshikawa is a Distinguished Engineer at IBM Silicon Valley Laboratory in San Jose. As a Db2 for z/OS architect she has overall responsibility for overall performance, product simplification, and strategic integration of AI capability within IBM Db2 for z/OS, including the... Read More →

Friday March 21, 2025 1:30pm - 2:20pm AEDT
Canberra

Technical Session

Platform z/OS

1:30pm AEDT

B25 | Db2 Datalake Tables and Integration with the Data Lakehouse

Friday March 21, 2025 1:30pm - 2:20pm AEDT

The use of object storage and open data and table formats, like Parquet, ORC, and Iceberg, are becoming common place in data management. Db2 has embraced this with the introduction of a new datalake table type, which allows Db2 table data to be stored outside of the database, using these open formats. In this session, you’ll learn more about datalake tables, including use cases, benefits, and how to create and work with them. Additionally, you’ll see how this and other new capabilities allow Db2 to tightly integrate with watsonx.data, IBM’s hybrid, open data lakehouse platform. The data lakehouse is the latest architecture in the evolution of data management, but rather than a replacement for enterprise data warehouses, the data lakehouse is poised to bring value by augmenting and optimizing them.

Speakers

Kelly Schlamb

Friday March 21, 2025 1:30pm - 2:20pm AEDT
Sydney

Technical Session

Platform LUW

2:25pm AEDT

A26 | Back to Basics Triggers and Advanced Triggers

Friday March 21, 2025 2:25pm - 3:15pm AEDT

Manual

Speakers

Frank Rhodes

BMC

Frank RhodesSenior Product Development Architect, DB2 Administration ProductsFrank Rhodes started with BMC Software in 1995. In his current role he works to promote cross product coordination between the Database Administration products and the other BMC DB2 products. The products... Read More →

Friday March 21, 2025 2:25pm - 3:15pm AEDT
Canberra

Technical Session

Platform z/OS

2:25pm AEDT

B26 | Db2 OLTP SaaS Update

Friday March 21, 2025 2:25pm - 3:15pm AEDT

Db2 has a wide range of services available across cloud providers like AWS, Azure and IBM Cloud. This session will provide a technical overview of some of the recent updates to these services and offerings as well as provide a sneak peak of what’s to come.

Speakers

Andrew Hilden

IBM

Andrew Hilden is the Chief Architect of Db2 SaaS. He is involved extensively in the development and architecture of several data-oriented cloud services in IBM. In the past 25 years he has worked in development, architectural and leadership roles in Db2 from SaaS to areas like appliances... Read More →

Friday March 21, 2025 2:25pm - 3:15pm AEDT
Sydney

Technical Session

Platform LUW

3:30pm AEDT

A27 | How to access Db2 for z/OS (and other Z oriented) data in the cloud

Friday March 21, 2025 3:30pm - 4:20pm AEDT

Manual

Speakers

Cüneyt Göksu

IBM

Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, Bachelor’s degree and PhD in ComputerScience. He has been working with Db2 for z/OS and IBM Z Platform... Read More →

Friday March 21, 2025 3:30pm - 4:20pm AEDT
Canberra

Technical Session

Platform z/OS

3:30pm AEDT

B27 | IBM Db2: A Database of AI, A Database for AI

Friday March 21, 2025 3:30pm - 4:20pm AEDT

IBM Db2 has introduced several AI features in recent years. These features fall into two categories: AI for database and database for AI. In the first category, Db2 has AI models in the database to optimize database operations. A key example is the AI query optimizer GA’d in v12. In the second category, Db2 has integrated machine learning algorithms into the database for users' AI use cases. It provides over 200 in-database AI stored procedures that allow users to develop and run ML pipelines within the database. Db2 also supports Python and R UDFs, enabling users to use their external Python and R models from Db2. These AI features improve database operations and simplify enterprise AI workflows. This session will explore Db2’s AI features from both categories and show how you can use them in developing modern data-driven applications and enterprise workloads.

Speakers

Shaikh Quader

IBM

Shaikh Quader is the AI architect at IBM Db2. His role involves developing product features to enhance database operations with AI and allow users in implementing AI solutions with Db2. Shaikh also manages research collaborations between IBM and Canadian universities. He and his team... Read More →

Friday March 21, 2025 3:30pm - 4:20pm AEDT
Sydney

Technical Session

Platform LUW

4:25pm AEDT

A28 | Partitioning Advances: PBR and PBR RPN

Friday March 21, 2025 4:25pm - 5:15pm AEDT

Manual

Speakers

Frank Rhodes

BMC

Frank RhodesSenior Product Development Architect, DB2 Administration ProductsFrank Rhodes started with BMC Software in 1995. In his current role he works to promote cross product coordination between the Database Administration products and the other BMC DB2 products. The products... Read More →

Friday March 21, 2025 4:25pm - 5:15pm AEDT
Canberra

Technical Session

Platform z/OS

4:25pm AEDT

B28 | Enhancing Uptime and Availability Like Never Before

Friday March 21, 2025 4:25pm - 5:15pm AEDT

In this session, we will deep dive the important Backup and Restore enhancements. Likewise, we will go through the pain point of Db2 users and how does the latest enhancement saves time and money for the mission critical applications. Intra-table-space Parallelism (ITP) for backup operations. Automatic Db2 backup enhancements. New Registry variable DB2_VALIDATE_LOG_ON_ARCHIVE. ZLIB compression for backup and log file compression. Offline backup requirement lifted, following a drop member topology change event. Support for database and table space restore involving dropped members in a Db2 pureScale environment. Support for database and table space rollforward through a drop member topology change event in a Db2 pureScale environment. Replication enhancement using the db2ReadLog API in a Db2 pureScale environment. Changes to LIST HISTORY, DB_HISTORY and b2HistoryData data structure.

Speakers

Shashank Kharche

Friday March 21, 2025 4:25pm - 5:15pm AEDT
Sydney

Technical Session

Platform LUW