Track F - Back Bay B

TRACK F sessions
are in Back Bay B

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

Hao Qi, 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

David Kreiss & Louise Comeaux, BMC Software

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

Ken Shaffer, Aerodata Inc.

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

John Lyle, IBM

 
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
 Back To Basics

Andrew Badgley, Broadcom

Does it really matter how often my application commits its activity? Yes, it does. This session will explore what the Db2 log is, how Db2 writes to it, what a Unit of Work is, and the impact of canceling a Unit of Work with regard to Db2 logging.

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.