Track F

Room F

To view additional details about each session, click the + icon or session title.





Cross Platform

 Cross Platform

Dave Beulke, Dave Beulke and Associates
IBM Gold Consultant & Champion 

This presentation details Db2 and Java performance best practices. Db2 coding best practices, java class frameworks, and debugging/tracing practices will be presented that can immediately identify your performance bottlenecks. After this discussion, you will be able to dramatically improve your Db2 access and Java runtimes, minimize CPU, and quickly access billions of rows with the best performance possible.
Db2 for LUW

 Db2 for LUW

Clark Jackson, IBM

Thoughts on pacemaker from an ex-TSAMP SME.
Db2 for z/OS

 Db2 for z/OS

Todd Havekost, IntelliMagic

This session will highlight capabilities to keep in mind as you seek to boost the value you derive from your Db2 Statistics and Accounting SMF data. It will be full of technical content exploring actual Db2 SMF data.
Db2 for z/OS

 Db2 for z/OS
 Back To Basics

Jim Kurtz, BMC Software

This is a back-to-basics introductory session on Db2 Bufferpools.
Db2 for LUW

 Db2 for LUW

Mohankumar Saraswatipura, Kronsys Inc
IBM Gold Consultant & Champion 

This presentation is all about data replication from a transactional system to operational data store or data mart for real time reporting purposes with limited impact to transactional workload. It will provide insight into the replication architecture for SQL Replication, Q Replication, and Change Data Capture. It explains the business driver behind the data replication and challenges in replicating the data in locally or geographically dispersed locations. We will also provide pointers to understand the replication workload statistics and the SLA requirements to propose a precise replication strategy.
Db2 for z/OS

 Db2 for z/OS
 Back To Basics

Jim Dee, BMC Software Inc.
IBM Champion 

This presentation discusses the structure and use of indexes. It is intended for beginners.
Cross Platform

 Cross Platform

Michael Tiefenbacher, mip GmbH
IBM Gold Consultant & Champion 

Searching for "pivot" in Google returns lots of EXCEL information, but data transformations can be done in Db2 with SQL as well (without moving your data into Excel and possibly back). SQL is a very powerful and mighty programming language and, in this session, it is all about transposing data--from row to column, column to row, denormalizing it into a single column, and reversing it again. Why that? Because we can. No, seriously, this is frequently needed for data preparation in Data Warehouse environments and is very often asked in forums like Stackoverflow, etc. And you even need it if you dig into the Db2 catalog. So let's look into it.
Db2 for z/OS

 Db2 for z/OS

Mariusz Koczar, Sopra Steria

Having many customers with different security standards can cause difficulties doing maintenance. Leaving in GDPR words are tricky and require profs (reports) on how we are protecting customer data. These requirements came from customers and regulators.
Db2 for LUW

 Db2 for LUW

Jens Seifert, IBM Deutschland R&D GmbH

With ADMIN_MOVE_TABLE, you can move any table within your database to address problems like growth, data placement, compression, or even reorganization of tables. The presentation provides technical background on ADMIN_MOVE_TABLE and use cases and insights into new features and functions like size estimation. Furthermore, monitoring of ADMIN_MOVE_TABLE and performance considerations are presented.
Db2 for LUW

 Db2 for LUW
 Back To Basics

Ian Bjorhovde, XTIVIA
IBM Gold Consultant & Champion 

IBM has added many features to Db2 over the years to help DBAs manage their databases. This session reviews the various autonomic features present in Db2: what they are, how to monitor them, and how to control their actions. 
Cross Platform

 Cross Platform
 

David Simpson, Transamerica 
IBM Champion 

Share in my recent lessons learned while rolling out new versions of Db2 clients to desktops and servers. 
Db2 for z/OS

 Db2 for z/OS

Gareth Copplestone-Jones, Triton Consulting
IBM Gold Consultant & Champion 

With the advent of Continuous Delivery and Function Levels in Db2 12 for z/OS, some users now face the challenge of managing the application compatibility level of DRDA applications that are dependent on the NULLID packages. This presentation discusses the challenges this presents and discusses ways of selectively applying appropriate APPLCOMPAT attributes at the application level (even at the level of the individual application program).
Db2 for z/OS

 Db2 for z/OS

Denis Tronin, Broadcom

This presentation will equip you with a good understanding of Db2 for z/OS traces in general, as well as when and how to best use them. It will also show you the newest and most useful tracing abilities available to you with the latest Db2 release.
Db2 for z/OS

 Db2 for z/OS

Toine Michielse, Broadcom
IBM Champion 

AI techniques and related software are common place nowadays. The Db2 ecosystem plays an important role as a data provider. In this presentation, you'll get an overview of software and ideas that can be used to get yourself started in exploiting both data and software in your day-to-day life.
Db2 for LUW

 Db2 for LUW

Shashank Kharche, IBM

This presentation describes detail awareness and what DBAs can do for various Db2 corruption scenarios. We will discuss the key best recovery practices DBAs can use to minimize and, in fact, eliminate outages (proactively).
Db2 for z/OS

 Db2 for z/OS

Christoff Theisen, Rocket Software Deutschland GmbH
IBM Champion 

This presentation introduces the basic principles of dynamic statement caching in Db2 for z/OS. It describes what DBAs and developers need to consider to use the statement cache optimally and how it can be monitored.