Brazil Virtual Seminar Agenda

brazilbanner.jpg


Tuesday, December 8

Db2 for z/OS

Db2 (LUW) & Trends

10:00 - 10:55 BRT

Session Presentation and Q&A

 

Sueli Almeida, IBM
Language: Portuguese

Having thrived as an industry-leading database for 35+ years, Db2 for z/OS continues to deliver client-focused, innovative capabilities to market.

Under continuous delivery, we now bring new features to market faster than ever before. In this session you will learn about new work to support simplification, self-managing and tuning, more exciting and efficient Developer Experience, plus more! This session will also cover the latest news on integration of AI with the Db2 engine, leveraging machine learning, and other techniques. This covers automated and constantly improving decision-making for key database operations, such as access path selection.

 

Les King, IBM

This session will drill down on a variety of capabilities delivered in 11.5.4 and 11.5.5 such as enhancements to BLU, pureScale, security, recoverability, availability, performance, multi-model support, and more. We will also take a peek ahead at what is potentially coming over the next year.


11:00 - 11:55 BRT

Session Presentation and Q&A

 

Rodolfo Custodio, Broadcom
Language: Portuguese

Despite the pragmatic view that the Z platform is inherently secure, if Db2 is not properly protected, your data is likely at risk. This session will discuss how to protect Db2 and explore approaches that you can take back and apply to your own system. When was last time you reviewed your Db2 security policies? Do you know the potential security breaches, and how to properly protect your system? This session will help you answer these questions and also learn what's new in terms of security in recent Db2 12 and z/OS releases

 

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, including mixed workloads and evolving to a multi-modal data store. This includes operational workloads and a mix of warehouse workloads. This also includes a look at how Db2 handles different data models like XML, JSON, BSON and Graph as well as how to integrate ML into applications working with these multiple models.


12:20 - 13:15 BRT

Session Presentation and Q&A

 

Sueli Almeida, IBM
Language: Portuguese

An area of concern for customers is the management of Db2 subsystem parameters (zPARMs). A recent study of how customers manage them reveals that many are rarely used and that others have outdated ranges or default settings. In this session, we will share with you the latest enhancements we have delivered in removing several obsolete zPARMs and improving several others according to best practices recommendations.

 

Mike Springgay, IBM

Take a deep dive into the world of external tables. This talk will introduce the concept of an external table within Db2. How they contrast to existing table types and when to leverage external tables. Learn how external tables along with the power of SQL can enhance or simplify your Extract Load and Transform processing. Also discuss how external tables fit and extend existing Db2 data movement utilities and practices.


14:15 - 15:10 BRT

Vendor Sponsored Presentations

Session Description Coming Soon

Session Description Coming Soon


15:15 - 16:10 BRT

Session Presentation and Q&A

 

Steen Rasmussen, Broadcom

The tablespace design has been through many changes and enhancements. This presentation will cover each of the tablespace types including pros and cons and limitations as well as best practices. The emphasis will be on the new tablespace type (Relative Addressing) introduced in Db2 12 using a live Db2 12 system to illustrate the details.

 

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 stand alone 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.


16:30 - 17:25 BRT

Session Presentation and Q&A

 

Sueli Almeida, IBM
Language: Portuguese

In this session, we would like to introduce you a key transformation initiative towards the experience of Db2 developers and administrators. We are working on bringing Db2 for z/OS application code, debug, and tuning capabilities into open source, market leading, cloud ready IDEs. SQL tuning services are being re-factored into APIs, enabling tuning services to be integrated into IDE. We will conclude by looking into plans for Db2 for z/OS integrated with Data Management Console, the replacement for Data Management Server.


Please join us for an interactive session - your voice makes a difference in our journey of transformation!

 

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.

Wednesday, December 9

Db2 for z/OS

Db2 (LUW) & Trends


10:00 - 10:55 BRT

Session Presentation and Q&A

 

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, along 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, focus on latest functionalities, field experiences and best practices from PoCs and deployments


11:00 - 11:55 BRT

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 the what is index compression 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?

 

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 needs to be executed.


12:20 - 13:15 BRT

Session Presentation and Q&A

 

Maryela Weihrauch, IBM

Java workloads have proliferated on Db2. Due to gaps in understanding true database behavior; application developers find it challenging to code well behaved applications that are high performance with large data volumes and also have continuous availability. Furthermore; many customers have embarked on legacy modernization projects where COBOL and Java have to co-exist. This has increased the need for developing efficient programming models. Maryela will present best practices in all key areas of developing Java application against Db2 - connection management; resultset handling; load balancing settings; failover techniques; optimization of expensive resources such as Java objects and much more - to bridge the gap between applications and Db2.

 

Wiliam Kanegae, Rocket Software
Language: Portuguese

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.


14:15 - 15:10 BRT

Vendor Sponsored Presentations

Session Description Coming Soon!

Session Description Coming Soon!


15:15 - 16:10 BRT

Session Presentation and Q&A

 

Rodolfo Custódio, Broadcom
Language: Portuguese


The audience will learn what it is, understand how to use it, and also they will be able to learn about the brand new tool created by Broadcom Db2 Utilities Team that shows which compression is better for a specific object and also the new Huffman Compression support of Fast Load, Fast Unload, and Rapid Reorg.

 

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.


16:30 - 17:25 BRT

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 Murphy strikes, the impact to the organizations can be costly.

 

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.