Special Guest: Martin Hubel
IBM DB2 GOLD Consultant

DB2 LUW Optimized for SAP - The Rest of the Story!

76% of our audience learned something! For 24%, it was review and validation they were doing the right things to tune and manage SAP on DB2 LUW! You will learn about registry variables for SAP, dropping and adding indexes, and more best practices. What's more, Martin talks about how to defend your DB2 turf from Hana! Please learn from, and enjoy, 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...

Special Guest: Scott Hayes, DBI Software

Sage DB2 LUW Performance Advice
Predictive Index Impact Analysis -
Know Before you Create!

100% of our audience learned something! Sage Advice Part 3 - Predictive Index Impact Analysis - Know Before you Create - extends the performance tuning journey that began with Parts 1 and 2. Don't worry if you missed Parts 1 and 2 because they are briefly reviewed during this show, plus we have links to prior shows where you can watch the full presentations. Learn how to figure out what to fix or improve, then learn how to get optimized design solutions, and then, in Part 3, you will learn how to gain confidence in your solutions and make your change control people very happy! Watch and learn...

Special Guest: George Baklarz, Program Director, IBM Canada

New & Updated FREE Resources to help you succeed with DB2 LUW V11.1

Again, 100% of our audience learned something! When you listen to our replay, take note of the millions of miles that George has flown around the world. While he's on the airplanes, he writes books and develops really cool tools to help learn about DB2. During this show, you'll learn about his new V11 e-book and updated tools: "DB2 Demo", "DB2 Compression Estimator", and "pureScale Simulator." Links to these resources are provided. Bonus: Learn about DB2 V11's unofficial support of JSON and please take our one question poll. Enjoy...

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

Special Guest: Les King, Director of Big Things, IBM

BigInsights 4.2 and BigSQL Drill Down!

Again, 100% of our audience learned something!For DB2 Folks, Les King took us on an informative journey into some IBM BigData solutions with a focus on BigSQL. Watch our replay and you'll see how IBM BigInsights BigSQL will allow you to run your favorite SQL against Hadoop. BigSQL is powered by DB2 - The Common Analytics Engine (CAE). Fascinating... Enjoy...

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

Special Guest: Nailah Bissoon, Performance Architect, IBM BigSQL

Monitoring IBM BigInsights BigSQL
How does it compare to monitoring DB2 LUW?

100% of our audience learned something! Your cheese is moving! Someday, if not already, you may be asked to monitor the performance of IBM BigSQL. As you'll learn in this replay, there are a few differences and many similarities to monitoring DB2 LUW. Nailah provided a fantastic comparison of DB2 LUW and BigSQL, their architectures, how they work, and how to monitor both- complete with examples and useful SQL! Enjoy...

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

Special Guest: Les King, Director of Big Things, IBM

DB2 - The Corner Stone of the
IBM Analytics Platform Strategy

100% of our audience learned something! What is the future of DB2? How will your career change? Has IBM moved your cheese? DB2 engine technology is invading many of IBM's software and cloud offerings. Affectionately called the Common Analytics Engine (CAE), DB2 is spreading like a virus (a good one) into BigInsights, BigSQL, Netezza, dashDB, and more. Via the DB2 CAE, investments that have been made in analytics SQL queries will run seamlessly in many places. To understand how you can grow your career and deliver great business results with IBM DB2 CAE technologies, watch this show and take notes! Enjoy...

Special Guest: Roger Sanders, Author, Teacher, and Security Guru, IBM

DB2 LUW Security:
From the Data Center to the Cloud!

100% of our audience learned something! No surprises there! Famous for his DB2 Certification Books and Classes, everyone learns from Roger! In this presentation, Roger provides our audience with the nuts and bolts and best capabilities for DB2 LUW security. As with any great presentation, it is rich with explanations, examples, and sample commands. If you want to improve DB2 security for your organization, you MUST watch and learn from this replay and the PDF handout! Enjoy...

Special Guest: Melanie Stopfer, IBM DB2 LUW Brain Surgeon

DB2 LUW V11.1 UPGRADE Best Practices
plus TIPS and Hidden Gems!

100% of our audience learned something! No surprises there! Everyone learns from Melanie! For our season #7 grand finale, Melanie gave our audience the complete scoop on upgrading to DB2 LUW V11.1! You will not only learn best practices, but you will also learn some very wise and insightful tips, plus you will learn about some "Hidden Gems" - - the extra "smaller" stuff that isn't making the headlines! And, did you notice? We kicked off Season #7 with Melanie talking about auditing and security, and today Melanie provided our Season #7 Grand Finale! Watch and learn...

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

Special Guest: David Kalmuk, STSM, IBM Canada

DB2 LUW Advanced Performance Diagnostics for SQL

100% of our audience learned something! David gave us another great IDUG presentation packed with tips and advice for monitoring and diagnosing performance issues in DB2 LUW. A PDF handout is available so you can copy/paste from his SQL examples! Watch and learn...

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

DB2 LUW DPF/MPP for Single Partition DBAs in 10 Tips!

100% of our audience learned something! During today's show, Pavan shares his excellent IDUG presentation in which he helps DBAs familiar with single partition databases understand how DPF works, how DPF is different, and he gives valuable administration advice! A PDF handout is available so you can copy/paste Pavan's SQL! Watch our replay and learn...

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