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

What's New in DB2 LUW V11.1: DEEP DIVE on OLTP and pureScale

Guests:
Steve Rees, STSM
Keri Romanufa, STSM
Xun Xue, STSM
IBM Canada Lab

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

What's New in DB2 LUW V11.1: DEEP DIVE on BLU and Analytics

Guests:
John Hornibrook, STSM
David Kalmuk, STSM
IBM Canada Lab

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

What's New in DB2 LUW V11.1 - Overview

Special Guests:
Matt Huras,
Chief Architect DB2 LUW

Berni Schiefer,
IBM Fellow

97% of our audience learned something! A new version of DB2 LUW is born! V11.1 will be generally available mid-June 2016. Almost 75% of our HUGE live studio audience indicated that they were very excited about the new features and capabilities becoming available in V11. V11 includes many enhancements for BLU, Analytics, OLTP, pureScale, security, SQL, and more! Please learn from, and enjoy, 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...

ALL ABOUT IDUG Austin Texas May 23-26

plus DB2's GOT TALENT 2016 Winners!

1st Place Winner - IDUG Badge: Rohit Kumawat

2nd Place Winner - Apple iPad: Ankan Garg

Special Guest: Martin Hubel
IBM DB2 GOLD Consultant

DB2 LUW Bufferpool Tuning Techniques!

100% of our audience learned something! His memory is rock solid, his experiences are bountiful, and few people have mastered tuning DB2 LUW Bufferpool Memory like Martin Hubel has! You will learn the importance of block based bufferpools, how to configure them, how to monitor effectiveness, and much more! Please learn from, and enjoy, the replay...

DB2's GOT TALENT 2016
ROUND #4 - Final Round!

1 Contestant Competes for YOUR Votes!

Judges and Guests give Presentations!

BREAKING NEWS: IBM & DBI Reception at IDUG!

Best show in a long time! Several top-notch, informative, presentations from a contestant, special guests, and our judges, plus breaking news about a BIG EVENT on 25 May 2016 at IDUG in Austin! Watch the entire replay for 65 minutes of pure education and enjoyment, or watch the YouTube videos to give our presenters the THUMBS UP they deserve! Watch...

DB2's GOT TALENT 2016
ROUND #3!

2 Contestants Compete for YOUR Votes!

Great DB2 LUW and z/OS presentations!

Most of our studio audience learned something! We have a new format for our contest this year! Contestants only present ONE time, up to seven minutes, in hopes of earning votes from the DB2 community, their peers, and friends. Voting is achieved by simply LIKING videos on YouTube. We've embedded the videos herein for your convenience, plus we'll share the URLs for direct access. Cheers to your learning! Watch...

DB2's GOT TALENT 2016
ROUND #2!

4 Contestants Compete for YOUR Votes!

Great DB2 LUW and z/OS presentations!

Most of our studio audience learned something! We have a new format for our contest this year! Contestants only present ONE time, up to seven minutes, in hopes of earning votes from the DB2 community, their peers, and friends. Voting is achieved by simply LIKING videos on YouTube. We've embedded the videos herein for your convenience, plus we'll share the URLs for direct access. Cheers to your learning! Watch...

DB2's GOT TALENT 2016
ROUND #1!

3 Contestants Compete for YOUR Votes!

Great DB2 LUW and z/OS presentations!

Most of our studio audience learned something! We have a new format for our contest this year! Contestants only present ONE time, up to seven minutes, in hopes of earning votes from the DB2 community, their peers, and friends. Voting is achieved by simply LIKING videos on YouTube. We've embedded the videos herein for your convenience, plus we'll share the URLs for direct access. Cheers to your learning! Watch...

Special Guest: Ian Bjorhovde
Principal Consultant at DataProxy LLC

DB2 LUW Data Security 102

90% of our audience learned something! Security isn't sexy, but it is important, especially if you've been a victim of identity theft or endured a data breach. During this show, Ian Bjorhovde "The Master of DB2 Security" shares valuable information and advice on how to achieve a more secure DB2 database environment. Please learn from, and enjoy, the replay...

Special Guest: Michael Tiefenbacher
Manager Business Services & Data Management Specialist at ids-System

Facilitate WLM Functions and Tools to Improve Your DB2 LUW Monitoring

100% of our audience learned something! If you don't have tools, you need to be clever about monitoring DB2 with built-in monitoring capabilities. During this show, Michael does a great job of explaining how DB2 Workload Manager (WLM) features and functions can be used for capturing and analyzing SQL, histograms, and system statistics. Enjoy 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...

Special Guest: Scott Hayes, DBI Software

Sage DB2 LUW Performance Advice
Advanced Index Benefit Analysis
BLU Table Convert Row to Column Analysis

100% of our audience learned something! In Sage Advice Part 1 during Episode #142, Scott teaches audiences how to find the biggest problems in DB2 based on weights. In Sage Advice Part 2 during this Episode, Scott teaches audiences how to accurately determine the benefit of each index recommended by IBM program "db2advis". As a bonus, if you are using DB2 10.5, Scott provides a methodology and queries for quickly and easily determining if a Row based table should be converted to BLU Column based. Sage Advice Part 3 "Predictive Index Impact Analysis" will be offered at IDUG conferences in 2016 - hope to see you in AUSTIN Texas at IDUG! Watch and learn...

Special Guests: Mike Winer, David Kalmuk, Matt Huras, John Hornibrook, Adam Storm, Melanie Stopfer, Iqbal Goralwalla, Ian Bjorhovde, Michael Tiefenbacher, Mohan Saraswatipura, Ember Crooks, Cristian Molaro, Klaas Brant, Martin Hubel, David Simpson, and Scott Hayes

Eggnog Party!
Celebrating 2015 with 2016 Insights!

95% of our audience learned something! 5% attended for the eggnog, fun, and insights! We sang, we danced, and we learned what was great about DB2 in 2015 and what people are looking forward to in 2016! Scott got a little crazy with twinkling DB2 Experts. Watch or listen, and learn...

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

Special Guest: Pavan Kristipati, Sr. DBA, Huntington Bank

DB2 LUW Tips, Tricks, SQL, and Scripts for Lazy DBAs

96% of our audience learned something! During today's show, Pavan shares his excellent IDUG presentation in which he details many of his tricks and techniques to make his DBA job easier and faster! Several examples are given and you can get his PDF! According to Pavan, these time saving techniques save him 30-60 minutes every day! Watch our replay for details...

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

Special Guests: Mohan Saraswatipura & Kent Collins

Real World DB2 LUW
DBA Essentials!

100% of our audience learned something! Our guests talked about DB2 pureScale efficient page reclaims, understanding connection methods and member subsets, compression techniques with comparisons, and replicated MQT problems and solutions. Watch and learn...

Special Guest: Ember Crooks
DB2 Lead DBA & Delivery Manager, Xtivia
IBM DB2 GOLD Consultant

8 High-Impact Performance Tuning Tips
for DB2 LUW OLTP & E-Commerce Databases

97% of our audience learned something! Want to make your OLTP databases run faster? Ember offered eight terrific tips and sage advice for getting maximum performance from your transactional databases! Index Read Efficiency, finding problem SQL, finding index solutions, finding bad indexes and dropping them, pruning data, HADR impacts, when to use STMM and when NOT to use it, using parameter markers or STMT_CONC, and optimal use of Solid State Disk (SSD). Watch and learn...

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

Special Guest: Matt Huras
IBM DE, Chief Architect DB2 LUW

DB2 LUW BLU
Concepts and Best Practices!

100% of our audience learned something! Matt Huras fills session rooms at IDUG conferences, and today our studio audience size was rather large as well. And, it is no wonder - Matt has a gift for explaining complicated technical things and making them understandable. He's an excellent presenter too. As Chief Architect for DB2 LUW, who would know better about how DB2 works!?!? Enjoy our replay! Watch and learn...

Special Guest: Steve Rees, IBM STSM

DB2 LUW pureScale Performance
Config, Monitoring, and Best Practices!

100% of our audience learned something! Steve is one of the top DB2 LUW performance gurus at the IBM Canada Lab, and he gives great presentations too! Today was no exception! Steve covered recommended configurations, how to monitor DB2 pureScale, and offered his sage advice based on his worldly experiences. Watch and learn...

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

Special Guest: Melanie Stopfer, IBM DB2 LUW Brain Surgeon

Who's Knocking at Your Door?
DB2 LUW Security & Auditing

100% of our audience learned something! No surprises there! Everyone learns from Melanie! For our season #7 kickoff, Melanie gave our audience the complete scoop on DB2 LUW auditing how-to's, best practices, and some gotchas! You'll learn advice on DB2 LUW security too! And, hey, who wants to be in the news for a data breach or the victim of identity theft?!?! Watch and learn...

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

Special Guest: John Hornibrook, STSM, IBM Canada

Top 10 DB2 LUW Explain Tips

100% of our audience learned something! John Hornibrook is one of the top IBM brains behind DB2's optimizer. In this helpful presentation, John shares some invaluable tips for using and understanding DB2's Explain capabilities. You will learn the best ways to create Explain tables, upgrade them, and empty them, how to see actual cardinality values, how to determine if access plans have changed, and much more! Watch and learn...