Presented by: Adrian Burke
DB2 for z/OS SWAT team

"The DB2Night Show #Z79: zIIP Experiences: Exploitation Not Abuse"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Adrian gave many tips for the proper use and exploitation of zIIP processors. Watch the replay...

Presented by: Peter Bendel
IBM STSM, Germany

"The DB2Night Show z78: IBM DB2 Analytics Accelerator for z/OS Update"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Peter gave insight into the many new enhancements of the IBM DB2 Analytics Accelerator. Watch the replay...

Presented by: Jeff Josten
Distinguished Engineer, IBM SVL

"The DB2Night Show Z77: DB2 12 Update"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Jeff did a great of describing the highlights in DB2 12 and beyond. Watch the replay...

Presented by: Tony Andrews
Instructor and Consultant, Themis Inc.

"The DB2Night Show Z76: DB2 SQL Tuning Tips"
Replays available in WMV and M4V formats!

97% of our studio audience learned something!Tony described many SQL coding issues that cause bad performance and then discussed the solutions. Watch the replay...

Presented by: Sheryl Larsen
Sr. DB2 Product – Specialist, BMC Software

"The DB2Night Show Z75: SQL Tuning in the Digital World"
Replays available in WMV and M4V formats!

94% of our studio audience learned something!Sheryl looked at how the data and transaction flood can be further affected by bad SQL and access paths. Watch the replay...

Presented by: Klaas Brant
Klaas Brant, IBM Gold Consultant and Champion for IM

"The DB2Night Show z74: DB2 Utilities: Changes you should know"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Klaas shared must know information on DB2 utilities and changes in DB2 11. Watch the replay...

Presented by: Dave Beulke
Dave Beulke, IBM Gold Consultant and Champion for IM

"The DB2Night Show z73: Justified Big Data Performance transforms your business"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Dave shared information on the IDAA with techniques to justify its savings as well as workload tuning tips to take better advantage of the IDAA. Watch the replay...

Presented by: Adrian Burke
DB2 for z/OS SWAT team

"The DB2Night Show #Z72: DB2 for z/OS Distributed Access - In the Mobile Age"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Adrian gave many tuning and management tips for distributed and mobile apps. Watch the replay...

Presented by: Jeff Josten
IBM Distinguished Engineer, DB2 z/OS Development

"The DB2Night Show #Z71: DB2 12 Preview"
Replays available in WMV and M4V formats!

98% of our studio audience learned something!Jeff provided a concise, clear overview of the new features in DB2 12 for z/OS. Watch the replay...

Presented by: Sheryl Larsen
Sr. DB2 Product – Specialist, BMC Software

"The DB2Night Show z70: Advanced and Complex SQL Refresher"
Replays available in WMV and M4V formats!

98% of our studio audience learned something!Sheryl discussed how to improve SQL coding skills; specifically in knowing when to use which SQL feature. Watch the replay...

Presented by: John Iczkovits and Paul Wirth - Senior IT Specialist - IBM

Connecting DB2 Applications, Including Mobile and Cloud, with Data on z Systems

EVERYBODY (100%) in our audience learned something! In the polls we found out that 80% of the audience is using mainframe DB2 data in some web or mobile application. How can you connect these applications in a secure way to you mainframe data? Watch, learn and enjoy...

Presented by: Cristian Molaro
IBM Champion and Gold Consultant

"The DB2Night Show z68: DB2 for z/OS Trusted Contexts and Roles: What you must know"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Cristian provided valuable tips and insight into trusted contexts and roles, including their definition and configuration. Watch the replay...

Presented by: Sheryl Larsen
Sr. DB2 Product – Specialist, BMC Software

"The DB2Night Show z67: SQL Performance Tuning in 2016"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Sheryl discussed SQL features and performance in the most recent versions of DB2. Watch the replay...

Presented by: Martin Hubel
Martin Hubel Consulting Inc.

"The DB2Night Show z66: DB2 11 for z/OS: Some personal favorites"
Replays available in WMV and M4V formats!

This show discussed some of the important but less presented features of DB2 11 including archive tables and new grouping functions. Watch the replay...

Presented by: David Simpson
Themis Education

"The DB2Night Show z65: Implementing Expanded RBA/LRSN in DB2 11 for z/OS"
Replays available in WMV and M4V formats!

This information is timely for the multitude of companies moving to DB2 11! David covered the many aspects of the expanded LRSN /RBA. Watch the replay...

Presented by: John Iczkovits
Senior IT Specialist - IBM

What Every DB2 for z/OS Professional Needs to Understand about IBM Disk and Tape Virtualization

EVERYBODY (100%) in our audience learned something! John did an excellent job on explaining what disk and tape virtualization is. Do you want to know what that is? Then watch, learn and enjoy...

Presented by: Dan Luksetich
DanL Consulting Inc.

"The DB2Night Show z63: DB2 for z/OS DBaaS and The Advantages of Automated Objects"
Replays available in WMV and M4V formats!

100% of our studio audience learned something! This is a must-see show. Taking the new terminology of database as a service (DBaaS), Dan presented the features in DB2 for z/OS that help reach that goal. Watch the replay...

Presented by: Roy Boxwell
Sr. DB2 Product Specialist
Segus / Software Engineering

Where is the BiF?

EVERYBODY (100%) in our audience learned something! Roy did a great job on explaining what can go wrong with the buitin functions (BiF's) when moving to DB2 11. Do you want to know what's new? Then watch, learn and enjoy...

Presented by: Sheryl Larsen
Sr. DB2 Product – Specialist, BMC Software

"The DB2Night Show z61: DB2 in the Digital Age"
Replays available in WMV and M4V formats!

90% of our studio audience learned something!Sheryl took a look into the future of technology and DB2's role. Watch the replay...

Presented by: Dave Beulke
Dave Beulke and Associates

"The DB2Night Show z60: SQL Performance for a Big Data 22 Billion row data warehouse"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Dave shared a wealth of SQL tuning tips aimed at very large DW environments. A must-see! Watch the replay...

Presented by: Sheryl Larsen
Sr. DB2 Product – Specialist, BMC Software

"The DB2Night Show z59: Comparing DB2 to Oracle"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Sheryl gave a deep dive comparison of DB2 on z/OS to Oracle. Watch the replay...

Presented by: Cristian Molaro
IBM Champion and Gold Consultant

"The DB2Night Show z58: Must knows about DB2 for z/OS Distributed - Part 2"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Cristian continued his excellent presentation on distributed configuration and many other topics. Watch the replay...

Presented by: Peter Bendel
IBM SVL

"The DB2Night Show z57: IBM DB2 Analytics Accelerator for z/OS - More Than Just Query Acceleration"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Peter insight into the many new features of the IBM DB2 Analytics Accelerator. Watch the replay...

It's the International DB2 Olympics!

Today's Finalist Winners: Cristian, Leila, Akshat, & Rajesh

100% of our studio audience learned something! Today's presentations were again very good considering that we had contestants from Austria, Iran, and India! It fascinates me that we can gather around our computers and learn from industry peers all over the world. You will learn about inline UDFs in DB2 V10/V11, Performance Optimization on SAP/DB2, Solving DBM1 high CPU usage, and lessons learned while upgrading DB2 LUW with avoiding pitfalls. This show contains another buffet of useful tips and advice! Enjoy!

Presented by: Cristian Molaro
IBM Champion and Gold Consultant

"The DB2Night Show z56: What you must know about Distributed access to DB2 for z/OS"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Cristian provided valuable tips and insight into distributed configuration, DBAT, and many other topics. Watch the replay...

Presented by: Adrian Burke
DB2 Swat Team, IBM SVL

"The DB2Night Show z55: Avoiding L2 Performance PMRs"
Replays available in WMV and M4V formats!

100% of our studio audience learned something! Adrian used RMF data to show several real world examples of DB2 as they show up at the z/OS level. Watch the replay...

Presented by: Julian Stuhler
IBM Gold Consultant, Triton Consulting

"The DB2Night Show z54: Tuning zIIPs for Fun and Profit"
Replays available in WMV and M4V formats!

98% of our studio audience learned something! Jules talked about zIIPs, their use, metrics and more. Watch the replay...

Presented by: Klaas Brant
IBM Gold Consultant, KBCE

"The DB2Night Show z53: Altering objects and the impact it has"
Replays available in WMV and M4V formats!

96% of our studio audience learned something! Some alters are a piece of cake and can also reverted. Others are more complex and have a (big) impact. Some are still impossible and require you to drop and recreate the object. Watch the replay...

Presented by: John Campbell
Distinguished Engineer, IBM DB2 Development

"The DB2Night Show z52: DB2 Thread Reuse and RELEASE(DEALLOCATE)"
Replays available in WMV and M4V formats!

98% of our studio audience learned something! John did a deep dive into thread reuse, Release(Deallocate), and when to use it to maximum advantage. Watch the replay...

Presented by: Willie Favero
IBM Silicon Valley Laboratory

"The DB2Night Show z51: Willie's Winging It Volume 3"
Replays available in WMV and M4V formats!

100% of our studio audience learned something! Willie provided insight into a number of topics including service levels, documentation, zIIPs and statistics. Watch the replay...