Presented by: Steen Rasmussen
CA technologies

"The DB2Night Show #Z82: The Db2 12 Catalog -- What happened since Db2 11"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Steen described the Db2 12 catalog changes abd their role in support new and improved Db2 features. Watch the replay...

Special Guest: Dale McInnis
STSM / NA Data Server Tech Sales
IBM Canada

The 5 W's of Db2 HADR

98% of our audience learned something! What is HADR? Why should you use HADR? Where should HADR be deployed? When should you use HADR? Who is using HADR? And, bonus, How is HADR being used by Db2 Customers? Our live audience was HUGE- clearly HADR is an important, and popular, topic of concern for the Db2 community! Watch and learn...

Presented by: James Pickel
DB2 for z/OS SWAT team

"The DB2Night Show #Z81: Early experiences using Db2 for z/OS Transparent Data Set Encryption"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Jim described pervasive encryption for DB2 and the steps to implement it. Watch the replay...

Special Guests: Roger Sanders and Paul Bird, IBM

Db2 Science Projects: IoT Project Pollinator and GWLM Tool

100% of our audience learned something! It's a special show when we have two guests! Roger Sanders introduced us to Project Pollinator and showed us his pet Internet of Things (IoT) Db2 project - Fascinating! And Paul Bird introduced us to a rather new "free" Graphical Workload Manager (GWLM) tool that is available to help make administering Db2 workload management easier! Watch the replay, get the details, follow the links, and enjoy the PDFs!

Presented by: Patrick Bossman
DB2 for z/OS SWAT team

"The DB2Night Show #Z80: DevOps and Cloud Provisioning for Db2 z"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Patrick gave many tips for improving developer and DBA productivity by reducing waits in the development process. Watch the replay...

Special Guest: Ember Crooks
Director, Xtivia
IBM DB2 GOLD Consultant

SQL Infusion: A Db2 LUW Transaction Log Expedition!

96% of our audience learned something! Ember took us on an educational journey that covered just about everything related to Db2 transaction logs, active logs, archive logs, configuration settings, recommendations, and sample SQL for examining your systems. As for the 4% that didn't learn something --- they were IBM Canada Lab staff! Watch and learn...

Special Guests: Roger Sanders and Jessica Rockwood, IBM

Breaking Db2 (LUW) News from the IBM Canada Lab

100% of our audience learned something! Shocker! "DB2 for LUW" is now just "Db2". Mainframe folks will still have to type out "Db2 for z/OS". Some IBM products, or solution offerings, have been renamed. What's new? Well, V11.1.2.2 is new, and there are plenty of goodies and enhancements in it. There's a new DSM release. There are new (free) editions of Db2. A PDF is available for reference, but make sure you download and watch a replay too! So much more is said than what is on the slides, and the questions at the end are excellent. Enjoy...

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

Special Guest: Ember Crooks
Director, Xtivia
IBM DB2 GOLD Consultant

Interviewing the DB2 LUW Optimizer

100% of our audience learned something! Ember took us on a deep dive journey through DB2 LUW Explain information including how to get it, how to interpret it, how to make the most of it, and much more. You will learn about db2exfmt, DB2 Explain from Actuals, IBM DSM, dsmtop, db2top, other tools, and just what the heck all those numbers actually mean! Watch and learn...

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

Special Guests: Mohan Saraswatipura and Kent Collins, Authors

DB2 LUW V11 Certification Training - Part 3

92% of our audience learned something! If you want to earn DB2 LUW V11 IBM Certifications, there are no better teachers than the professionals that are writing the exams and Certification Study Guides! Watch this replay and learn about DB2 LUW V11, RCAC, Security, Trusted Contexts, utilities, and more! Sample Certification Questions are included in the video replay too!

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

Special Guests: Terry Johnson, IDUG Conference Chair, and Paul Turpin, President IDUG Board

ALL ABOUT IDUG Anaheim

100% of our audience learned something! Terry told us all about the upcoming IDUG Conference in Anaheim California, April 30-May 4. This year the conference format is "new and improved", so be sure to listen to the changes to make the most of your IDUG DB2 Tech Conference experience! Paul Turpin also shared with us news about the IDUG Data Tech Summit - which is essentially a conference within the IDUG conference that will be focused on emerging IBM technologies. Please enjoy our replay, and we look forward to seeing you at IDUG!

Special Guests: Mohan Saraswatipura and Kent Collins, Authors

DB2 LUW V11 Certification Training - Part 2

100% of our audience learned something! If you want to earn DB2 LUW V11 IBM Certifications, there are no better teachers than the professionals that are writing the exams and Certification Study Guides! Watch this replay and learn about DB2 LUW V11, BLU, DPF/MPP, pureScale, and more! Sample Certification Questions are provided too!

Special Guests: Mohan Saraswatipura and Kent Collins, Authors

DB2 LUW V11 Certification Training - Part 1

100% of our audience learned something! If you want to earn DB2 LUW V11 IBM Certifications, there are no better teachers than the professionals that are writing the exams and Certification Study Guides! Watch this replay and learn about DB2 LUW V11, BLU, DPF/MPP, pureScale, and more! Sample Certification Questions are provided too!

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