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...

Presented by: Joel Goldstein
Responsive Systems Company

"The DB2Night Show z50: DB2 Buffer Pool Tuning"
Replays available in WMV and M4V formats!

100% of our studio audience learned something! Joel provided an in-depth look at buffer pool tuning with many real world examples. Watch the replay...

Presented by: Dan Luksetich
DanL Consulting Inc.

"The DB2Night Show z49: Understanding Query Transformation in DB2"
Replays available in WMV and M4V formats!

100% of our studio audience learned something! Dan gave a detailed look at how DB2 performs query transformation, how you can monitor it, and considerations for SQL and application performance. Watch the replay...

Presented by: Martin Hubel
Martin Hubel Consulting Inc.

"The DB2Night Show z48: Where is the Problem in My z/OS Transaction?"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Martin showed the sources of transaction data both within and outside of DB2, and the considerations for end-to-end problem resolution. Watch the replay...

Presented by: Dave Beulke
Dave Beulke and Associates

"The DB2Night Show z47: Big Data Disaster Recovery Performance"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Dave provided a wide variety of recovery options and strategies for backup and disaster recovery. Watch the replay...

Presented by: Sheryl Larsen
World Wide DB2 for z/OS Evangelist, IBM

"The DB2Night Show z46: What's New in DB2 11 SQL Coding and Tuning"
Replays available in WMV and M4V formats!

99% of our studio audience learned something!Sheryl provided intimate details on performance and SQL coding for DB2 11. Watch the replay...

Presented by: Cristian Molaro
IBM SVL

"The DB2Night Show z45: Practical DB2 11 for z/OS Performance in a Nutshell"
Replays available in WMV and M4V formats!

98% of our studio audience learned something!Cristian provided tips and insight into application and system performance for DB2 11. Watch the replay...

Presented by: Willie Favero
IBM SVL

"The DB2Night Show z44: DB2 z/OS - Willie's Winging It"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Willie covered many topics from bufferpools, zIIPs, and prefetch to IDAA. This is a must-see for any z/OS DBA. Watch the replay...

Presented by: Phil Nelson
ScotDB Ltd.

"The DB2Night Show z43: DB2 z/OS in a Connected World"
Replays available in WMV and M4V formats!

94% of our studio audience learned something!Phil presented several scenarios described DB2 for z/OS connectivity options. Watch the replay...

Presented by: Julian Stuhler
Triton Consulting

"The DB2Night Show z42: DB2 11 for z/OS - Easing Upgrade Anxiety"
Replays available in WMV and M4V formats!

98% of our studio audience learned something!Julian gave a comprehensive look at the new compatibility options available in DB2 11 for z/OS. Watch the replay...

Presented by: Damon Anderson and Steven Loesch
Anixter

"The DB2Night Show z41: New DB2 V10 Functionality Implemented at Anixter"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Steve and Damon gave practical user tips and experiences for managing DB2 10. Watch the replay...

Presented by: Klaas Brant
IBM Gold Consultant & IM Champion

"The DB2Night Show z40: Dynamic SQL, Pros and Cons"
Replays available in WMV and M4V formats!

98% of our studio audience learned something! Klaas presented many characteristics and considerations for using dynamic SQL. Watch the replay...

Presented by: Cristian Molaro
IBM IM Champion and Gold Consultant

"The DB2Night Show z38: zIIPs and zAAPs in DB2 10"
Replays available in WMV and M4V formats!

100% of our studio audience learned something! Cristian described zIIPs and zAAPS, and provided techniques to estimate savings, and for eligibility and monitoring. Watch the replay...

Presented by: Martin Hubel
MHC Inc., IBM IM Champion

""
Replays available in WMV and M4V formats!

100% of our studio audience learned something! Martin presented his approaches to application problem solving and tuning. Watch the replay...

Presented by: Dave Beulke
IBM Gold Consultant and IM Champion

""
Replays available in WMV and M4V formats!

92% of our studio audience learned something! Dave presented his experiences on implementing a time-constrainted project to implement a 22-billion row data warehouse. Watch the replay...

Presented by: Gerald Hodge
HLS Technologies

""
Replays available in WMV and M4V formats!

92% of our studio audience learned something! Gerry presented a detailed how-to on dynamic SQL hints for DB2 for z/OS 10. Watch the replay...

Presented by: Namik Hrle
IBM Distinguished Engineer, IBM Germany

""
Replays available in WMV and M4V formats!

100% of our studio audience learned something! Namik presented the advantages and improvements in the IBM DB2 Analytics Accelerator (IDAA),including improvements introduced after V2. Watch the replay...

Presented by: Cristian Molaro
IBM Gold Consultant, M Consulting

""
Replays available in WMV and M4V formats!

Cristian spoke about the importance of rebinding to obtain DB2 10 performance benefits, plan management, and the new Bind features in DB2 10 for z/OS. Watch the replay...