104

The purpose of this presentation is to unveil some of the  mysteries of the Db2 catalog and the migration process. The presentation will cover some basic catalog information before moving into the mysteries of a catalog migration. Will cover data sharing/non-data sharing migration considerations, catalog and migration enhancements for Db2 releases through Db2 VNext, performance considerations, and finish with information about the future direction of the Db2 catalog and migration process. Will cover information about the various modes of V12 through VNext. This presentation will also spend time discussing the future of the  migration process and also touch on Continuous Delivery concepts and new Online Migration capabilities

IBM Db2 Administration Foundation is the no-charge replacement for the administrative features in Data Studio and DSM. We will all features and functions including catalog navigation, running SQL statements, executing Db2 commands and BINDs/REBINDs, Visual Explain, and much more. Also learn how to order, download, install, and configure Admin Foundation and related components such as the IBM SQL Tuning Service.

Db2 for z/OS continuous delivery constantly introduces new features and meanwhile started depreciation of existing. This also affects the Db2 for z/OS clients landscape. Continuous delivery introduces new opportunities but also challenges for client applications and their configuration. This presentation gives an overview what you should consider to make your Db2 clients ready for the continuous delivery era. It also discusses other important trends and directions for Db2 for z/OS clients such as the future of Db2 Connect Gateways; IBM Data Studio and related tools.

The integrated AI Accelerator on IBM Z and LinuxONE enables emerging deep learning uses cases to be deployed on IBM Z vNext. This presentation describes how accelerated inferencing/scoring for instance within CICS transactions can be achieved on IBM Z, enabling a number of use cases, such as fraud detection, process automation, financial advisor, customer retention, risk mitigation, and smart IT operation. The presentation provides details on embedded AI inference with the new central low-latency AI accelerator in combination with Watson Machine Learning for z/OS and a comprehensive technology stack designed for AI on IBM Z.

An access path selected by Db2 drastically affects how well or how badly your SQL statement and overall application perform. Developers should be familiar with what the access path is and how to read it, while database administrators need to be able to maintain workload stability avoiding performance degradations and resource consumption spikes. This session will talk about how to interpret an access path with EXPLAINs, discuss how to influence the optimizer, and cover the ways to maintain and manage access paths for both static and dynamic SQL statements