Mexico Virtual Seminar Agenda

Db2 for z/OS

Db2 (LUW)

10:00 - 10:55 CST

Session Presentation and Q & A


Anthony Ciabattoni, IBM

The session will discuss various unexpected, unplanned scenarios and events that customers have experienced. The discussion will explain the details of the events, how the customer was impacted and illustrate how to take preventative measures. The risk of experiencing the unexpected may be small, but when Murphey strikes the impact to the organizations can be costly.


Ferdinand Prahst, ITGAIN Consulting Gesellschaft für IT-Beratung mbH

Running Db2 on Docker is getting more and more state of the art. Within the presentation we want to show our best practices in deploying and running Db2 and Docker. Therefore we show deployments from standalone till the HADR version and the obstacles you have to deal with. With the running Db2 we have made performance and failure tests and will show you our results dealing with storage and memory.

11:00 - 11:55 CST

Session Presentation and Q & A


Dominique Parker, IBM

Db2 for z/OS is enabled for REST access! Application developers who do not even know Db2 or SQL can invoke services composed of Db2 SQL statements or stored procedures and include these services in their applications via APIs or native REST access to Db2 for z/OS. This session describes this exciting new approach for taking advantage of the valuable data in your z/OS environment.


James Sobieski, Fourth Millennium Technologies

Unix shells provide powerful programming capabilities that easily integrate with Db2 and its Command Line Processor. This session provides and introduction to automating Db2 administration tasks in shell scripts. It will discuss techniques and Unix tools such as awk, sed, and more, providing many examples and code snippets to perform simple to complex activities in Db2. Examples include post processing Db2 load output, using Db2 to track and manage many concurrent DBA tasks, automating tuning, and explain plan analysis.

12:20 - 13:15 CST

Session Presentation and Q & A


Javier Estrada Benavides, Broadcom
Language: Spanish

Anomaly detection is a trendy topic, and it is something that can be quickly explored whether it's for your weekly Db2 trends report, monitoring, or capacity planning. Db2 12 for z/OS provides a couple built-in functions that can be used for this purpose and for quick Exploratory Data Analysis, enabling people to do more analytical work within their daily roles.

On this presentation, we will take a look at several ways to do Anomaly Detection by ourselves and have an overall view of what these alternatives offer, tips, and gotchas. We'll begin using pure Db2 SQL and then move to Data Science tools using Python Jupyter Notebooks.


Andres Gomez Casanova, Experian
Language: Spanish

La presentación explica todo el proceso de migración de un conjunto de bases de datos de 10.5 a 11.5, además del cambio a otro conjunto de servidores con sistema operativo más reciente. Como parte de la presentación se muestra el escenario de origen, las diversas actividades que se realizaron previamente para una migración, qué se hizo durante la migración, y finalmente una retroalimentación con las cosas aprendidas.

14:15 - 15:10 CST

Vendor Sponsored Presentations

Session Description

Session Description

15:15 - 16:10 CST

Session Presentation and Q&A


Brian Laube, Manulife Financial

Db2 Index Compression has been available since Db2 Version 9. Surprisingly, it remains a relatively under-utilized feature of Db2. If you are not using index compression, then it is time to at least consider it!
This presentation will review what index compression is and how it works along with the benefits and impact. It is not like tablespace compression!

A key decision for index compression is the bufferpool. This presentation will explain why the bufferpool decision is important and it will help you pick the best bufferpool for each index. The presentation will include a free “tool” to find and identify the best indexes for compression along with the best bufferpool.

Finally, I will explain why we decided to review our indexes and our experiences and benefits from our implementation. Obviously, reducing mainframe DASD storage usage for indexes is a measurable impact and we were able to clearly show the dollar cost savings

As a bonus, I will share some index lessons we learned along the way... Along with some queries I developed to help identify duplicate indexes and indexes that are a subset of one another. How and why did we let that happen?


Les King, IBM

This session will do a dive into both Db2 11.5.4 and Db2 11.5.5 taking a look at new capabilities delivered with BLU, pureScale, multi-modal, security, performance, recoverability, availability, and more. We will also take a peek ahead at what is being considered for the year to come.

16:30 - 17:25 CST

Session Presentation and Q&A


Tony Andrews, Themis

Most relational tuning experts agree that the majority of performance problems with applications that access a relational database are caused by poorly coded programs or improperly coded SQL. Industry experts agree that poorly performing SQL is responsible for a very high percent of response-time issues. SQL developers should be informed of the many performance issues associated with the SQL language, the way the tables are designed, and associated data statistics.

This presentation is designed for the Db2 development professional who desires to understand the fundamental issues associated with performance for Db2 SQL applications. Emphasis is placed on understanding optimization and the many access paths chosen by the optimizer, along with how to read and understand these access paths using the IBM Data Studio tool. Performance related issues in the areas of database design, indexing, application SQL coding, and data statistics will be addressed.


David Morris, Leidos

Db2 Batch processing has long been considered a mainframe-only domain. Many enterprise domain applications require bulk processing of large volumes of data for mission critical environments. But, what if we could offload some of the batch process handling of mainframe jobs to Linux servers using Java? In the past, Java developers created custom-built Java batch applications that did not followed any standards, were often buggy, and could not be easily repurposed for other Java batch processing applications.

The Java Specification Request (JSR) 352 standard started in 2013 specifies the programming model for batch applications and a runtime for execution of batch jobs. Partnerships were established with the spec lead for the Java Batch Specification, who provided major influence on the development of this standard by using their extensive experience in supporting batch processing. Other partnerships offered significant contributions to the standard as well as collaboration on the development of a JSR 352 implementation batch framework. Decades of experience with batch processing frameworks with COBOL/Mainframe, C++/Unix shaped the framework architecture. These partners committed resources to driver support, enhancements, and a roadmap for the JSR 352 implementation. The standard is fully supported in a comprehensive batch framework.

17:30 - 18:25 CST

Session Presentation and Q&A


William Kanegae, Rocket Software

Customers are struggling to find human resources to develop or maintain applications on the z/OS environment. Is also a challenge obtaining and deploying tooling for their mainframe developers and system programmers. This session will introduce Zowe, and the ways IBM is working with ISVs and customers to address these challenges by bringing modern platforms, frameworks, and open source languages and tooling to the mainframe. With this new tooling even non-mainframe developers will get at speed on interacting with z/OS in an open multi-platform environment.


James Sobieski, Fourth Millennium Technologies

External tables are Db2 table-objects that map to external flat files. You can use external tables inside Db2 to reference flat file data as if it were a Db2 table. Netezza has long had external tables and now the same functionality has rolled into Db2, starting with Db2 v11.5, Db2 Warehouse and the IBM Integrated Analytics System (IIAS). In this presentation you will learn the types of external table objects you can create, how to read from them and load data into regular user tables. It will show examples of reading and writing external tables. The presentation will also discuss error conditions and how to research and debug errors encountered with external tables. When using external tables, log files are written. Learn where these files reside and what they can tell you

   On-Demand Sessions

Mark McNary, UMB Bank

With fewer schools teaching Db2 for z/OS, it often falls on the DBAs to provide instruction for the programming staff. This is a very basic introduction to Db2 concepts and vocabulary, aimed at the novice user of Db2, or anyone who must train novice users.

Maryela Weihrauch, IBM

Maryela will present best practices in all key areas of developing Java application accessing Db2—connection management, resultset handling, load balancing settings, failover techniques, and optimization of expensive resources such as Java objects.

Mike Springgay, IBM

Learn about changes to the Database Conversion Workbench as well as new capabilities in Db2 to make application migration from Oracle, Netezza, and Postgres easier

Chiara Baldan, SOGEI S.p.A

Db2 Analytics Accelerator definitely innovated Sogei IBM Z environment modernizing applications . This session includes an overview of Sogei’s main software application running on IBM Db2 Analytics Accelerator, challenges faced and the benefits achieved will be shown with tips and tricks to migrate Db2 Analytics Accelerator applications from V5 to V7, and how to monitor the accelerator. Sogei took part in the Db2 Analytics Accelerator V7 InSync Early Support Program; find out the outcome of this experience.

Cuneyt Goksu, IBM

As part of continuous delivery, Db2 Analytics Accelerator V7 development is providing new releases and capabilities. In this session, I will provide what is provided in 2020, focusing on latest functionalities, field experiences, and best practices from PoCs and deployments.

Les King, IBM

The workloads and applications in the database space are evolving rapidly. This session will take a closer look at how Db2 is positioned to handle the new workloads and applications.

Anthony Ciabattoni, IBM

The challenge of mass Db2 recovery is overwhelming and challenging but rarely is tested. Disaster Recovery testing often occurs multiple times a calendar year but local recovery testing especially mass application recovery rarely is tested. Statistically speaking mass Db2 recovery will happen more frequently than an actual disaster but most organizations are not properly prepared to execute a mass local recovery. This session will go through the process of planning, preparing and executing a mass Db2 recovery. The ultimate goal is to plan, prepare and be proactive rather than being non-prepared reactive when a mass Db2 recovery is needed to be executed.