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.
User Defined Functions (UDFs) are extensions or additions to the existing built-in functions of the SQL language. It allows the user to extend the capabilities of the database by creating custom functions just like built-in functions. UDFs enhance modularity and code reuse, improves query readability by encapsulating complex logic, and optimizes performance by executing custom logic directly within the database. A UDF takes one or more columns or parameters as input. These inputs can be values from a table, constants, or expressions passed to the function. It then applies the logic or operations defined in its code to process the input. This logic can range from simple calculations to complex business rules, transformations, or validations. After performing the defined actions, the UDF produces an output, which is returned as a single value (for scalar UDFs) or as a set of rows (for table UDFs). This result can then be used directly in queries, enabling seamless integration into existing Db2 workflows or applications. We will also cover in this presentation the following topics: · Overview of User Defined Functions (UDFs) · UDF Types and Differences · Differences between UDF, Stored Procedure and Trigger · UDF Operations and Options · SQL Scalar UDF Ordering and Versioning · UDF Restrictions and Considerations · Real-World Use Cases of User Defined Functions
This session explores the latest features introduced in Db2 row and columnar runtime for version 12.1. We will cover key enhancements, including hash join memory and performance improvements for variable-length payloads, extended compact representation support for VarLenBinary and LOBs, FFNR performance enhancements, and the new Data Masking feature powered by MAGEN. Each feature will be discussed in detail, highlighting the significant improvements it brings to the Db2 engine.
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.
This presentation will highlight how Db2 V12 has evolved and continues to evolve as a FinOps-compliant database, with key design and architectural decisions having a significant impact on the total cost of cloud application throughout its life cycle.
In this session, we will explore how Ansible can be used to modernize Db2 for z/OS system management by automating routine administrative tasks. Db2 System Programmers and DBAs typically perform many day-to-day tasks manually. When these tasks need to be executed across an entire SYSPLEX, they become time-consuming, error-prone, and cumbersome. By utilizing Ansible’s built-in modules and integrating with Db2 RESTful APIs, these processes can be automated, reducing manual effort, and improving accuracy. This session will focus on: Introduction to Ansible: A quick start on using Ansible on z/OS, including an overview of Ansible’s built-in modules. Integration of Db2 RESTful API with Ansible: Demonstrating how to use the Db2 RESTful API with Ansible playbooks to automate common Db2 management tasks. Practical Use Case: Walkthrough of a real-world example where Ansible playbooks are used to automatically retrieve and compare the Db2 zparm setting from all active Db2 regions, eliminating the need for manual intervention. By the end of this session, attendees will have an understanding of how to write and execute Ansible playbooks on z/OS. This session will empower attendees with the knowledge of modern automation practices that can be applied in their z/OS environments.
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.
Ever wondered how the choice of a simple data type can significantly impact your database's performance, storage, and overall efficiency? In this session, we'll dive deep into the world of Db2 for z/OS data types, demystifying their nuances and unlocking their full potential. 1) Master the Fundamentals: Gain a solid understanding of core data types like numeric, string, date/time, LOB, XML etc.2) Optimize Database Design: Selecting optimal data type for your specific needs, minimizing storage overhead and maximizing query performance.3) Write Efficient SQL Queries: Discover techniques to leverage data type strengths and write efficient SQL queries that deliver fast results.4) Troubleshoot Data Type Issues: Identify and resolve common data type-related problems, such as data truncation, conversion errors, and performance bottlenecks.This session helps to equip either a budding database enthusiast in acquiring essential skills or a seasoned Db2 for z/OS professional in refreshing or expanding their knowledge base to build robust high-performance databases. Join us on this enlightening journey and unlock the power of data types!"
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
