The Db2Night Show™

Educate. Inform. Entertain.

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 #12! TWELVE 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!
Special	DB2 LUW	22 APR 75 Mins	Check and Tune Db2 with only a few mouse clicks using DBI's new Web Suite Introducing the new DBI Web Performance Suite version 5. Learn how to detect issues and tune your database in minutes. Perform health checks, get performance advice and index recommendations, create virtual index and simulations, view transaction service levels and database availability, monitor real time metrics with dashboards and trend charts, and a many more. Don't miss it! Click below to register.	Chad Kidd, DBI Rhonda Kirk, DBI
#Z116	Db2 z/OS	23 APR 75 Mins	Integrate Db2 for z/OS database changes in your enterprise DevOps pipeline Typically, the first focus for a Development team is implementing a DevOps pipeline for application changes, whereas, in practice, many application changes also require Db2 z/OS database changes. That introduces a dependency on DBAs to deploy code with multiple hand-offs between DBA, application developer, and Data Modeler, which in turn creates unnecessary bottlenecks and deployment delays. Click register for details...	Maryela Weihrauch
#225	DB2 LUW	7 MAY 75 Mins	Db2 Latest News Db2 has come a long way since being one of the first Relational Database Management Systems. Explore the containerization of Db2 and optimization on RedHat OpenShift. New exciting features like Db2 Graph, REST APIs and enhanced ML capabilities with PythonUDF and in-DB Machine Learning. Click below to register.	Piotr Mierzejewski @piotrm42
#Z117	Db2 z/OS	21 MAY 75 Mins	A very untraditional approach implementing schema changes! The most commonly used methodology implementing Db2 schema changes is to compare new/old structures and create the worklist to execute the changes - being online or deferred or the DBA nightmare of UDCL. This approach can result in some surprises like the requirement to fall back or access path changes due to altered indexes/tables/columns/programs. This presentation will illustrate how a complete different approach can be implemented mitigating most of the risks/challenges - done by real customers.	Steen Rasmussen @DB2rasmussen

Recent Popular Replays

Show	OS	Replay Link	Theme	Guest(s)	Photos
#234	DB2 LUW	Watch Replay	Db2 Query Optimization 101 Optimal query access plans are essential for good data server performance. The optimizer is a very sophisticated component of the data server, tasked with the challenging job of choosing good access paths for the variety of features and table organizations supported by Db2. Attend this session to get an overview of how the optimizer works and to get some tips on how to understand its decisions and control its behavior. Click below to register.	John Hornibrook, STSM, IBM Toronto Lab @rld_box
#233	DB2 LUW	Watch Replay	Db2 Click-2-Containerize and Db2 on Cloud Learn more about our latest tooling to help Db2 users containerize their databases on the HW infrastructure of their choice. We will also talk about what's the latest on our Db2 on Cloud offerings.	Tanmay Sinha @tanmaysinha Vinayak Agrawal
#232	DB2 LUW	Watch Replay	Some Iterations Over Recursion In this session Michael will show some more "SQL gems" to solve interesting real life problems - this time the focus is on recursion. So it is about learning SQL recursion with examples from business related problems and solutions.	Michael Tiefenbacher @globomike
#231	DB2 LUW	Watch Replay	What's New in Db2 11.5.5 An overview of Db2 v11.5 starting with the continuous delivery model and key items in GA, and mod 4. Then progressing to recently shipped Mod 5, And finally ending with a sneak peak into some potential futures.	Keri Romanufa @RomanufaKeri
#230	DB2 LUW	Watch Replay	Enterprise-Scale Machine Learning with IBM Db2 Machine Learning (ML) endeavors are on the rise in every industry. With IBM Db2's ML capabilities, Db2 users can build and deploy their ML models near the data and smoothly integrate ML with their business applications. These capabilities can help Db2 customers save on IT costs and accelerate turning data into assets. This session will provide an overview of the ML capabilities in Db2.	Shaikh Quader @ShaikhQuader
#229	DB2 LUW	Watch Replay	Adaptive Workload Management: Overview and Best Practices Db2's new Adaptive Workload Management technology vastly simplifies the task of dividing your database resources between workloads to ensure they meet their performance objectives. Join David Kalmuk, the architect of the Adaptive Workload Manager, as he takes you through an overview and offers some useful tips that will allow you to get the most out of this technology.	David Kalmuk @DavidKalmuk
#228	DB2 LUW	Watch Replay	Docker Cookbook: Practical Recipes for Running Db2 Docker isn't just a solution for application developers: It's a fantastic solution for running your Db2 database, as well. After you've learned the basics of Docker, this presentation will give you practical recipes that you can use to make Db2 upgrades easier, add functionality to existing Docker images, automate maintenance in your containers, and manage Db2 user authentication.	Ian Bjorhovde @idbjorh
#227	DB2 LUW	Watch Replay	A look at Graph and REST with Db2 In this session we'll walk through two exciting additions to Db2 11.5.4: Db2 Graph and Db2 REST. Graph databases are all around us. Streaming services use graph databases to manage their assets, understand their users' viewing habits and create personalized recommendations, network providers use them to model networks, manage issues and identify breaches, and insurance companies use them to identify fraud. Let's see how we can use both technologies to find relationships in our data.	Daniel Snoddy
#225	DB2 LUW	Watch Replay	The new face of Db2: Cloud-Native and AI ready Db2 has come a long way since being one of the first Relational Database Management Systems. Explore the containerization of Db2 and optimization on RedHat OpenShift. New exciting features like Db2 Graph , REST APIs and enhanced ML capabilities with PythonUDF and in-DB Machine Learning.	Piotr Mierzejewski @piotrm42
#Z115	Db2 z/OS	Watch Replay	Db2 Java Performance Best Practices This presentation details Db2 and Java performance best practices. Db2 coding best practices, java class frameworks and debugging/tracing practices will be presented that can immediately identify your performance bottlenecks. After this discussion you will be able to dramatically improve your Db2 access, Java runtimes, minimize CPU and quickly access billions of rows with the best performance possible. Click register for details...	Dave Beulke @DBeulke
#z114	DB2 z/OS	Watch Replay	Tuning SQL that Still Works! Gone are the days of manually tuning queries. NOT SO FAST! Sheryl will cover all kinds of techniques that are still best practice rules to follow. Perfect for newbies to Db2 for z/OS due to all the pictures used to demonstrate techniques, as well as oldies, who need a refresher.	Sheryl Larsen @smlsql
#z113	DB2 z/OS	Watch Replay	Mitigating migration mayhem in a deprecated world Db2 has grown a lot over the years and, partly due to this, it carries around a ton of old baggage. It is definitely the right time to start crawling through the Db2 catalog and review any and all of the "deprecated" objects that are hanging around still nailed to their perches!	Roy Boxwell, Software Engineering @rld_box
#Z112	Db2 z/OS	Watch Replay	Db2 For z/OS Index Performance Recommendations Many considerations can be made regarding design choices when building and maintaining Db2 for z/OS indexes with regard to high performance. This webcast is going to attempt to address many of those choices, but it is the combination of knowing how an application is going to use the database as well as adequate testing to make the appropriate design decisions.	Daniel Luksetich @DanL_Database
#Z111	Db2 z/OS	Watch Replay	Distributed access to Db2: must know A refresher about must know about Distributed access to Db2. DRDA best practices and what is new. A new look into a classic topic.	Cristian Molaro @cristianmolaro
#Z110	Db2 z/OS	Watch Replay	Db2 for z/OS Visual Studio Code support, read all about it! Come one, come all developers - and get a taste of where we are and where we're going! Are you wondering what's going on with Data Studio, and what the future will bring for developers of Db2 for z/OS applications? Attend this session to see a demo of available, and near term features integrated into Visual Studio Code.	Patrick Bossman @Bossman2day
#Z109	Db2 z/OS	Watch Replay	Exploit DB2's Log Relational DBMS have a transaction log for recovery purposes in case of failure. However, the information stored in the log is also well suited for other purposes. Think of undoing bad transactions, data propagation, and auditing. The DB2 log is a potential gold mine if you know how to seamlessly filter and make complex log data usable. We will show you how the DB2 log is structured, what data DB2 stores in the log besides table contents, and how to find the information you are looking for.	Kai Stroh

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

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.5 :: 11.1 PDFs :: 10.5

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