Special Guest: Martin Hubel
IBM Gold Consultant
Db2 LUW Performance Tuning: Indexes versus Prefetch!
100% of our audience learned something! Famous for putting his kids through college by Dropping Db2 Indexes, Martin covers a wide variety of Db2 Performance Tuning topics with focus on indexes, prefetch I/O, bufferpools, Db2 MDC and ITC tables, and much more (detailed below). Watch and learn from a top Db2 performance pro!
Special Guest: Klaas Brant
IBM Gold Consultant
The PERFECT Db2 Server! Bonus: What's New in Db2 V184.108.40.206
100% of our audience learned something!Klaas Brant's presentation was amazing! From monitoring commands to configuration recommendations, Klaas covered it all! Watch our replay to learn MON_GET queries, OS commands, configuration settings, and best practices for making your Db2 servers run optimally! What's more, Kelly Rodger ( @kdrodger ) from the IBM Canada Lab briefed us on What's New in Db2 V220.127.116.11!
Special Guest: Michael Krafick
10 Minute Triage: Troubleshooting Db2 LUW Production Issues
100% of our audience learned something!Per Michael's tweet this morning, "I will teach you how to say #holdmybeer while triaging #Db2 on production databases." Downtime is expensive. Most DBAs have been in the hot seat with management demanding rapid information and problem resolution. Michael shares his robust triage plan. Watch and learn from an experienced pro...
Special Guest: Les King
Director, Hybrid Data Management
IBM Canada Lab
Db2 News from IBM Canada Lab
93% of our audience learned something!We kicked off our 10th season of The Db2Night Show with Db2 News presented by Les King. All of the advances and updates with IBM Data Management are pretty amazing. Watch our replay and learn about pureScale, BIGSQL, Db2 Event Store, Cloud, Hadoop, and more! Watch and learn...
Special Guest: Arwel Owen, Enterprise Systems Manager, Princess LTD, UK
Db2 LUW Success Story with SAP on AWS
83% of our audience learned something! 17% of our audience were Arwel's co-workers! Arwel completed a VERY successful migration from Oracle to Db2, and then another migration to Db2 V18.104.22.168 SAP on AWS Cloud. The compression, cost savings, and performance results are simply ASTOUNDING! Watch our fun and informative replay for details...
Special Guests: Kent Collins and Mohan Saraswatipura, Authors
A crash course on Db2 pureScale and Advantages
100% of our audience learned something! Kent provided a wealth of excellent information on Db2 pureScale including best practices, database manager configuration settings, database configuration settings, registry variables, HADR considerations, how to size memory, monitoring, workload manager (WLM), and much more! Get the PDF for reference AND watch our replay so that you don't miss Kent's helpful explanations! Continue...
Presented by: Maryela Weihrauch Distinguished Engineer, IBM SVL
"The DB2Night Show Z87: Db2 RESTful Service Support and z/OS Connect" Replays available in WMV and M4V formats!
100% of our studio audience learned something!Maryela showed how SQL and stored procedures in Db2 on z/OS can be made available in the era of application assembly and integrate with z/OS Connect EE. Watch the replay...
Special Guests: Mohan Saraswatipura and Kent Collins, Authors
DEEP DIVE on Db2 LUW Locks, Logs, and pureScale
100% of our audience learned something! Mohan took us into the bowels of Db2 pureScale locking and logging, complete with sample SQL, monitoring commands, configuration considerations, important stuff you need to know for Db2 V11.1 Certification Testing, and much more! Get the PDF for reference AND watch our replay so that you don't miss Mohan's brilliant explanations! Continue...
Special Guests: Lenin Thandapani, Dustin Ratliff, Saghi Amirsoleymani
IDUG CPC Volunteers
ALL ABOUT IDUG Philadelphia!
100% of our audience learned something! The early bird registration has been extended to 31 March 2018!
Hotel space is filling up! Register Now! See our replays and PDF handout for information about IDUG and the upcoming conference in Philadelphia! It is IDUG's 30 Anniversary! You will learn about Education Seminars, Half and Full Day workshops, tech sessions, Expert Panels, Keynote Speakers, Special Interest Groups (SIGs), Complimentary Certification Exams, Hands-on-Labs, and much more! Watch and learn...
Special Guest: Ember Crooks
IBM DB2 GOLD Consultant
Using Jupyter Notebook for Db2 Administration
100% of our audience learned something! If you like tools that help make your Db2 Administration tasks easier, then watch this replay and learn about Jupyter Notebook from IBM GOLD Consultant Ember Crooks! Ember teaches how to organize your favorite administrative SQLs, plus create graphs and reports, and more! The CLP is so yesterday! Watch and learn...
100% of our audience learned something! SELECTIVITY, OPTGUIDELINES, Runstats, Indexes, Bufferpool Design, REORGs, monitoring advice, and more!! No wonder Joe won Best User Speaker at IDUG Lisbon 2017! Joe's presentation is full of terrific advice and tips! Watch and learn...
100% of our audience learned something! Based on his popular IDUG Lisbon Db2 technical session, Mark covered an overview of BLU, examples of workload performance in Db2 V10.5, the benefits of Db2 V11 for some workloads, showed examples of BLU savings, and shared a few BLU gotchas. If you're using Db2 BLU, or thinking about it, you must watch this replay! Watch and learn...
Special Guest: George Baklarz, Program Director, IBM Canada
Awaken your Data with RESTful Access to Db2! OData!
100% of our audience learned something! The new IBM Data Server Gateway for OData is a standards-based way for customers to leverage Db2 in modern Cloud and Mobile application development environments without requiring database drivers on the client. This show described what OData is, how it works with RESTful calls, and what you need to get it working in your environment. Enjoy the replay!
Special Guest: Dale McInnis
STSM / NA Data Server Tech Sales
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...
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!
Special Guest: Ember Crooks
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, V22.214.171.124 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...