Sueli Almeida, IBMLanguage: 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.
Rodolfo Custodio, BroadcomLanguage: 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
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.
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.
Session Description Coming Soon
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.
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!
back to top
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
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 savingsAs 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
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 SoftwareLanguage: 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.
Session Description Coming Soon!
Rodolfo Custódio, BroadcomLanguage: 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
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
2601 Iron Gate Drive, #101Wilmington, NC 28412Phone: (910) 660-8649Fax: (910) 523-5504