Track A

Room A

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





Db2 for z/OS

 Db2 for z/OS

Greg DeBo, Team SWAMI
IBM Champion

Most Mainframe Modernization discussions focus on the application, but there’s also so much that can be done with data. We will talk about IDAA for analytics and the use of virtualization technologies to simplify access to mainframe data (not just Db2).
Db2 for z/OS

 Db2 for z/OS

Akiko Hoshikawa, IBM

Db2 for z/OS Performance Updates & z16 Synergy
Db2 for z/OS

 Db2 for z/OS

Rick Chang

Identify hidden insights using SQL Data Insights
Db2 for z/OS

 Db2 for z/OS

Vince Rabsatt, IBM & Martin Dinh, IBM

Now You See It, with Db2 AI for z/OS 1.5
Db2 for z/OS

 Db2 for z/OS

Robert Bersano, Rocket Software
IBM Champion

There are many reasons affecting the version of Db2 your organization uses, such as time to migrate, what features/functions drive your implementation--even cost. One thing does tend to remain true: many enterprises are making scant use of some of the basic Db2 capabilities introduced both in previous versions and in newer releases. With migration and function levels providing easier adoption, why not put what you do have to work for you and your organization? We will look at some of the key features in Db2 that will help provide you a faster, easier and safer way to get from a feature being under consideration to an actual implementation in your production environment.
Db2 for z/OS

 Db2 for z/OS
 Back To Basics

Haakon Roberts, IBM

Whilst most of Db2 development has been focused on V13, the utilities team has continued to deliver major new improvements in APARs in V12. This session will cover what's new in utilities in both V12 and now in V13 of Db2.
Db2 for z/OS

 Db2 for z/OS
 NEW

Thomas Halinski, Broadcom

The Trilogy of DB2’s “Originating” Address Spaces–Mainframe DB2, DDF and Stored Procedures
Db2 for z/OS

 Db2 for z/OS

Anthony Ciabattoni, IBM

The session will concentrate on new SWAT team experiences. Various unexpected outcomes and behaviors will be discussed, as well as hot technical items customers are exploiting and some technologies that have been challenging for them.
Db2 for z/OS

 Db2 for z/OS

Moderator: Jim Reed, IBM

Z Expert Panelists to be listed here
Db2 for z/OS

 Db2 for z/OS

Davy Goethals, Arcelormittal

In this presentation, we will explain the roadmap we used for migrating from z/OS V12 FL500 to FL510 and how we managed the APPLCOMPAT levels of the DB2 packages during this migration.
Db2 for z/OS

 Db2 for z/OS

Alain Pary, Database Business Partners SPRL

The information about getpages has been available for free since Db2 V12 in RTS and I will explain how to take advantage of this precious information. After this presentation, you can implement a simple monitoring tool in one hour and directly get the advantages of this new source of data. We will help you identify objects with a high getpage activity or objects candidates for page steal none buffers. This will help you have a better view on objects' behavior and with what is the most used index for a table.
Db2 for z/OS

 Db2 for z/OS

Thomas Baumann, Swiss Mobiliar

In an OLTP environment where every microsecond matters, the ability to access real-time data for instantaneous analysis is critically important. Additionally, after such diagnosis, quick remediation is necessary. What do you do if the problem is not the access path? How do you resolve performance problems if: they affect latch waits; the number of waits for log writes is abnormally large; the response times vary dramatically dependent on the variable values; or the number of long prepares is constantly growing? In this presentation, we will identify problem areas, analyze dynamic queries, and resolve the problems. Therefore, I've selected 10 use cases derived from everyday practical work and only two of them are related to access path issues.
Db2 for z/OS

 Db2 for z/OS

Mark Rader, IBM

Db2 for z/OS Data Sharing has been available for over 25 years. Many IBM clients rely on Db2 Data Sharing for their production systems to provide continuous availability, flexible scalability, and workload balancing to their critical applications.
Db2 for z/OS

 Db2 for z/OS
  

Maryela Weihrauch, IBM

Large tables in Db2 are frequently inflated by inactive data. Maryela shares a solution proposal using Db2 for z/OS archive table capabilities where inactive data can be separated but stays available to the applications that need access to that old data.
Db2 for z/OS

 Db2 for z/OS
 Back To Basics

Sally Mir, IntelliMagic

Most people have a fuzzy understanding of the SMF data that contains all the information about what Db2 is doing behind the scenes. There are SMF record types, IFCIDs, trace classes, and somehow they all relate to each other. But how?
Db2 for z/OS

 Db2 for z/OS

Jørn Thyssen, Rocket Software
IBM Champion

Python is a widely popular programming language with a large set of libraries available. In this presentation, we will explore more complex examples of Db2 and sysprog productivity aid programs using various python libraries to run a Db2 query and save in.