Track A - Independence West

TRACK A sessions
are in Independence West

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




Mon Jul 11th
11:00am

 Db2 for z/OS

Thomas Baumann
IBM Champion

Morning has broken! The Role of the DBA in the era of Machine Learning, Data Visualization, Real-time Analytics and Autonomous Databases. A DBA-Bear awakens after hibernation. Astonished he sees a lot of new creatures buzzing around: Machine Learning; Big Data; IOT; Cloud; Lean; SaFe and DevOps mushrooms everywhere. And what is happening with our old “Data Honey”? It is now called the “new oil," has a lot more value, and it is moving, changing, and going to the cloud! And as much as a bear prefers fresh salmon, data is captured, analyzed and visualized in real-time, not any longer analyzed only a few days later after an ETL process. The DBA-bear is not a scavenger! All this has an only meaning: Change and Adapt. Are we an endangered species, or is it just a new step in our evolution? What does it mean to work for a Data Driven Enterprise? Which are the shifts in our mindset necessary to embrace this change; who are the new fellow travelers? If you are only waiting for retirement, this is not a talk for you. If you want to find out more about the future of your role, then you are exactly in the right place.
Mon Jul 11
2:00pm

 Db2 for z/OS

Akiko Hoshikawa, IBM

Db2 for z/OS Performance Updates & z16 Synergy
Mon Jul 11
3:15pm

 Db2 for z/OS

Bharat Verma, IBM, & Akiko Hoshikawa, IBM

Identify hidden insights using SQL Data Insights
Mon Jul 11
4:30pm

 Db2 for z/OS

James Pickel, IBM, Akiko Hoshikawa, IBM, & Bharat Verma, IBM

Now You See It, with Db2 AI for z/OS 1.5
Tue Jul 12
9:00am

 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.
Tue Jul 12
11:30am

 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.
Tue Jul 12
2:00pm

 Db2 for z/OS
 NEW

Thomas Halinski, Broadcom

The Trilogy of DB2’s “Originating” Address Spaces–Mainframe DB2, DDF and Stored Procedures
Tue Jul 12
3:15pm

 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.
Tue Jul 12
4:30pm

 Db2 for z/OS

Moderator: Jim Reed, IBM
[click "+" above for list of panelists]

z/OS Expert Panelists:
Mo Townsend
Haakon Roberts
Akiko Hoshikawa
Anthony Ciabattoni
Gaya Chandran
Dave Beulke
Wed Jul 13
9:00am

 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.
Wed Jul 13
11:30am

 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.
Wed Jul 13
2:00pm

 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.
Wed Jul 13
4:30pm

 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.
Thu Jul 14
9:30am

 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.
Thu Jul 14
10:45am

 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?
Thu Jul 14
12:00pm

 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.