The Db2Night Show™

Educate. Inform. Entertain.

FEATURED Db2 LUW V11.1 REPLAYS: Part 1: What's New in Db2 LUW V11
Guests Matt Huras and Berni Schiefer, IBM Canada Lab

Part 2: Db2 LUW V11 Deep Dive on BLU and Analytics

Part 3: Db2 LUW V11 Deep Dive on OLTP and pureScale

Part 4: Db2 LUW V11 Upgrade Best Practices with Melanie Stopfer

Part 5: Db2 LUW V11 FREE Resources with George Baklarz

The Db2Night Show has the simple mission of building a fun, interactive community around IBM^® DB2^®. Each episode will include fun stuff, education, tips, and special guests. Guests will range from industry experts to "Joe the DBA".
PLEASE TELL AT LEAST FIVE of YOUR FRIENDS about The DB2Night Show!
We won't mind if you share the registration links!

SEASON #10! TEN YEARS of FREE Db2 Education!

Unless otherwise noted, all shows start at 8am Pacific, 9am Mountain, 10am Central, and 11am Eastern time. Adjust accordingly for Daylight Savings and International locations.

Show	OS	Date & Duration	Theme	Guest(s) @Twitter_ID	Photos- Click to see profiles!
#Z92	Db2 z/OS	14 DEC 75 Mins	Distributed access to Db2 for z/OS: top things to know With today's complex n-tier architectures and heterogeneous applications and platforms, optimization and availability can be a challenge. Fortunately, the ways in which DB2 communicates with its distributed clients is evolving and presents exciting new possibilities and opportunities. Cristian will discuss the top things that you must know about distributed access to Db2.	Cristian Molaro @cristianmolaro
#210	Db2 LUW	21 DEC 75 Mins	EGGNOG and Db2 LUW Tuning! Jolly Holidays! Special Guest Martin Hubel, IBM Db2 GOLD Consultant, IBM Champion, and famous Db2 Performance Tuning Expert, presents his exceptional IDUG presentation on Db2 Indexes and Prefetching. You will learn about bufferpool tuning too, and more! Click register for details...	Martin Hubel @mhubel
#Z91	Db2 z/OS	18 JAN 75 Mins	Best Design and Performance Practices for Analytics Designing application analytical systems requires comprehensive data management and usage analysis to design and build the best performance analytical application that produces meaningful insights. This presentation will discuss the application design patterns that provide sustainable performance for fast analytic answers.	Dave Beulke
#211	Db2 LUW	25 JAN 75 Mins	Db2 LUW Favorite Problem Determination Tricks Pavel Sustr, Sr. Manager and STMM, IBM Canada Lab, will share with us his favorite problem determination methods and tricks, including insider secrets, advanced diagnostics, shortcuts, and interpreting Db2 diagnostic data. Click register for details...	Pavel Sustr @pavel_sustr
#212	Db2 LUW	22 FEB 75 Mins	Db2 LUW SQL Tuning: detect, fix, and prevent problems Our special guest, Klaas Brant, IBM Db2 GOLD Consultant, returns to share with us his SQL tuning methods! How to find bad SQL? Fix it? Prevent it? Join us! Click register button below for details!	Klaas Brant @klaas_brant

Recent Popular Replays

Show	OS	Replay Link	Theme	Guest(s)	Photos
#209	Db2 LUW	Watch Replay	The PERFECT Db2 LUW Server! PLUS Db2 V11.1.4.4 What's New Our special guest, Klaas Brant, IBM Db2 GOLD Consultant, presents how to achieve an optimally configured Db2 server including memory, storage, instances, STMM, monitoring, and more! Breaking Non-Fake News: Kelly Rodger from the IBM Canada Lab will also share with us What's New in Db2 V11.1.4.4!	Klaas Brant @klaas_brant
#208	Db2 LUW	Watch Replay	10 Minute Triage: Troubleshooting Db2 LUW Production Issues Our special guest, Michael Krafick, Lead Db2 Database Engineer and IBM Champion, will share with us his thoughts and methods on how to quickly triage production Db2 problems.	Michael Krafick @MKrafick
#207	Db2 LUW	Watch Replay	Db2 News from IBM Canada Lab We're kicking off Season #10 of The Db2Night Show with the latest news from the IBM Lab. Be sure to join us for updates on Db2 announcements!	Les King @LesKing00
#204	Db2 LUW	Watch Replay	Db2 LUW on AWS Cloud - SAP Experiences Arwel Owen, known as @SAP_AWS on Twitter, has achieved some pretty spectacular performance, compression, and cost savings results by moving his company's SAP Db2 environment to the AWS cloud. Join us and learn from his experiences.	Arwel Owen @sap_aws
#206	Db2 LUW	Watch Replay	A Crash Course on Db2 pureScale and Advantages IBM Champions, and Db2 Certification Book Authors, Mohan Saraswatipura and Kent Collins return as our special guests to give us a crash course on Db2 pureScale and its advantages.	Mohan Saraswatipura @mohankumarsp Kent Collins @rcollins963
#205	Db2 LUW	Watch Replay	Deep Dive into Db2 LUW Locks, Logs, and pureScale IBM Champions, and Db2 Certification Book Authors, Mohan Saraswatipura and Kent Collins return as our special guests to give us a deep dive on Db2 V11 locks, logs, and pureScale.	Mohan Saraswatipura @mohankumarsp Kent Collins @rcollins963
#202	Db2 LUW	Watch Replay	Using Jupyter Notebook for Db2 Administration Our guest, Ember Crooks, had standing room only for this presentation at IDUG EMEA Lisbon 2017! Join us and learn how you can use Jupyter Notebooks to help you with DBA tasks and reporting! Make sure you attend to see the LIVE demonstration!	Ember Crooks @ember_crooks
#201	Db2 LUW	Watch Replay	Favorite Tuning Tips and Tricks for Db2 LUW Joe Geller won Best User Speaker at IDUG EMEA Lisbon 2017 with this fantastic presentation about his favorite tips and tricks for tuning Db2 LUW. There's 100% chance you're going to learn something helpful!	Joe Geller
#198	Db2 LUW	Watch Replay	The 5 W's of Db2 HADR Our special guest, Dale McInnis, is the father of Db2 backup, recovery, HADR, and all things related thereto. During this show, Dale will share with us a newer presentation on the 5 W's of HADR. If you're using HADR or thinking about it, make sure you join us!	Dale McInnis @dalemmcinnis
#197	Db2 LUW	Watch Replay	Db2 Science Projects, IoT, WLM, and other cool stuff! Roger Sanders has been tinkering with Db2 IoT technologies, and he's built something really cool that he's keen to share. Paul Bird has updated the Db2 WLM Graphical User Interface and you need to see it!	Roger Sanders @Roger_E_Sanders Paul Bird @IBM_Paul_Bird
#194	DB2 LUW	Watch Replay	Interviewing the DB2 LUW Optimizer Special guest Ember Crooks returns to share with us her advice on understanding Explains and the DB2 LUW optimizer!	Ember Crooks @ember_crooks
#189	DB2 LUW	Watch Replay	IBM DB2 LUW Optimized for SAP - The Rest of the Story Martin Hubel, an IBM DB2 GOLD Consultant and IBM Champion, and the leading independent DB2 LUW SAP Performance Expert, will share his insights about performance optimization for SAP databases.	Martin Hubel @mhubel
#188	DB2 LUW	Watch Replay	Sage Advice Part 3- Predictive Index Impact Analysis - Know before you Create! Based on his popular and highly rated IDUG presentations, Scott continues his Sage Advice series with Part 3 which reviews Part 1 (weight analysis) and Part 2 (advanced index benefit analysis), then introduces Predictive Index Impact Analysis - a method for forecasting the impacts of index(es) before they are created!	Scott Hayes @srhayes
#Z91	Db2 z/OS	Watch Replay	Machine Learning and Db2 for z/OS Beginning with enhancing the access path decisions made by the optimizer tailored to your workloads, Db2 for z/OS is embarking on a journey to improve performance and manageability by exploiting machine learning. This session will outline where Db2 is in this journey, and hint at the roadmap for a self-tuning Db2	Terry Purcell
#Z90	Db2 z/OS	Watch Replay	Total Recall: Exploiting In-Memory Features in Db2 12 for z/OS IBM has steadily expanded the in-memory capabilities of DB2 in recent releases, to the extent that Db2 12 for z/OS is now officially recognised by Gartner as a bona fide "In Memory" Database. This presentation provides an overview of the ways in which DB2 is evolving to exploit more real memory, reduce CPU and deliver improved price/performance.	Julian Stuhler @jstuhler
#z89	Db2 z/OS	Watch Replay	Are you just gonna play in the pool...or own it...Bufferpool that is There have been many changes to buffer pool behavior, performance, and management across recent DB2 releases. This presentation will walk through several major enhancements as well as if they are right for you, and how to measure them. Understanding the impact of your tuning activities is just as important as undertaking them in the first place.	Adrian Burke @agb_DB2z
#Z88	Db2 z/OS and LUW	Watch Replay	DB2 Security Best Practices Volume II Implementing the best security techniques and strongest configuration is mandatory these days for safe guarding your data. This presentation discusses the latest DB2 security methods, procedures and techniques for fortifying DB2 systems, databases and applications. This presentation details DB2 z/OS and DB2 LUW security strategies such as the impacts of encryption, database design security techniques and how best implement a multi-layered DB2 security data perimeter.	Dave Beulke
#Z87	DB2 z/OS	Watch Replay	Db2 RESTful Service Support and z/OS Connect The Application Programming Interface (or short API) Economy has changed how developers build application and how organization deploy software as a service. Mobile devices have accelerated the shift of providing services via API. Maryela will show 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.	Maryela Weihrauch IBM Distinguished Engineer @zAnalyticsGURU
#Z86	DB2 z/OS	Watch Replay	Pre-IDUG Db2 for z/OS Update This presentation gives a summary of some of the latest news and deliveries from Db2 for z/OS development. Kind of a preview of what will be covered at the IDUG North American conference at the end of April, if you will.	Jeff Josten
#Z85	DB2 z/OS	Watch Replay	Db2 12 Continuous Delivery - New challenges for deployment Fundamental changes in the Db2 z world often lead to concerns. Let's face it - some changes force us to change! This will have a tremendous impact on migration strategies, because we have to find a reliable way to test these code deliveries in a fraction of the time we used to have. This presentation will describe the difference between Code, Catalog, Function and Application Levels, how you can control them and how you can fallback in case of anomalies.	Roy Boxwell, Software Engineering
#z84	DB2 z/OS	Watch Replay	Revival of the SQL Tuner The pool of DBAs with SME knowledge of SQL tuning has shrunk dramatically while the number of SQL statements needing attention has grown and will continue to grow. DB2 performance tooling can help identify what needs to be tuned. But what do you do then? This presentation will help fill the skills gap by reviving the role of an SQL Tuner.	Sheryl Larsen @smlsql
#Z83	Db2 z/OS	Watch Replay	Copy Smarter - Unload/Load, DSN1COPY and beyond When you get tasked with setting up a refresh process for thousands of DB2 z/OS tables you probably have a few thoughts running through your head. This presentation discusses advantages and disadvantages of different utilities that copy DB2 data, but the main focus is automating all the side tasks that DBAs usually need to do in addition to copying the data itself.	Kai Stroh
#Z82	Db2 z/OS	Watch Replay	The Db2 12 Catalog -- What happened since Db2 11 There are many ways to learn about a new Db2 version, but using the catalog is probably the fastest and most enlightening. Once you look at the revision track in the Db2 Catalog and Directory section of the SQL Reference Guide, study the column changes, additions as well as new catalog tables, you have a very good overview of everything worth to know about that specific Db2 version.	Steen Rasmussen @DB2rasmussen
#Z81	Db2 z/OS	Watch Replay	Early experiences using Db2 for z/OS Transparent Data Set Encryption Db2 11 and Db2 12 recently delivered a simple, transparent and consumable approach to enable extensive encryption of data at-rest. This new capability substantially reduces the people and hardware costs associated with protecting data & achieving compliance mandates. Db2 12 expands the Db2 11 functionality by providing new options to allow a DBA to manage encryption policies at a table level. The session discusses the differences between Db2 11 and Db2 12 and results of early customer experiences using this new encryption approach.	James Pickel
#Z79	DB2 z/OS	Watch Replay	zIIP Experiences: Exploitation Not Abuse IT staffs are being pressed to get every cycle possible out of their System z Integrated Information Processor (zIIP) specialty engines and the now defunct System z Application Assist Processors (zAAP). DB2 for z/OS and related processes that run on System z can take advantage of these processors, and will be covered in depth during the presentation.	Adrian Burke IBM DB2 SWAT team @agb_DB2z

We will be broadcasting at your favorite screen resolution. For audio, VoIP and local country telephone numbers will be available for US, Canada, European countries, Australia, and New Zealand. You are responsible for your transportation to our "Studio", popping your own popcorn, and your favorite beverage.

Thank you to our show sponsors!

Please inquire about sponsorship opportunities. Email "db2nightshow" "at" "dbisoftware.com".	www.IDUG.org	www.DBISoftware.com
www.responsivesystems.com	www.kbce.com	www.Triton.co.uk

NEW! The DB2Night Show has a new LinkedIn Group! Get show updates and discuss our shows!
JOIN The DB2Night Show LinkedIn Group!

---

Show News

Subscribe to an RSS feed of The DB2Night Show News:
Click! Or, read The DB2Night Show News Blog

Replays and Recordings

All show replays have been moved to the new DB2Night Show blogs. By using blogs, we gain a few important advantages:

1. We can provide more descriptive text about each show.
2. You can obtain an RSS Feed of new blog posts, learn about new episodes, and be notified about the availability of replays.
3. Each blog post creates a small Shameless Marketing Moment for show sponsors. You do want The DB2Night Show to remain free, don't you?

Did you miss our Webinar on IBM DB2 LUW Index Design Best Practices and Case Studies? Access a recorded replay at https://www.dbisoftware.com/media/20090812INDEXES.wmv (112MB)

Quick Links to IBM Db2 LUW Knowledge Center

11.1 :: 11.1 PDFs :: 10.5 :: 10.1 :: 9.7 :: 9.5 :: 9.1 :: 8.2

FREE TOOLS from IBM!

• Learn and TRY the newest DB2 V10 & V10.5 Features with "DB2 Demo"
• DB2 Compression Estimator - Updated for DB2 V10.5 BLU