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 #13! THIRTEEN 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!
#Z123	DB2 z/OS	21 JAN 75 Mins	Latest news in Db2 for z/OS Data Studio and DSM strategic replacement Are you wondering what's going on with Data Studio, and what the future will bring for developers of Db2 for z/OS applications? Patrick will demonstrate SQL function capabilities, creation of native rest services, the IBM Z Open Editor for JCL, COBOL, PL1, and using the Zowe extension to connect to z/OS and explore and edit files on z/OS. Get a taste of the art of the possible, where we're going, and offer suggestions for what you'd really like to see. Click below to register.	Patrik Bossman @Bossman2day
#242	DB2 LUW	11 FEB 75 Mins	V12 Plans & New Watson Query! 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
#Z124	DB2 z/OS	18 FEB 75 Mins	Db2 for z/OS Utilities Update The Db2 for z/OS Utilities team continues to deliver significant new performance, availability and usability enhancements through the V12 maintenance stream. This session will cover recent deliverables, explain what the improvements are, why they matter and how to take advantage of them. Click below to register.	Haakon Roberts @db2tools
#243	DB2 LUW	11 MAR 75 Mins	Techniques for Optimal DB Performance Part 2 Jim continues his excellent presentation where he covers many performance improvement considerations and techniques that can be applied to relational databases; many of the examples come from Db2 LUW and Db2 on zOS. We'll see the impact of these types of changes, and look at several recent features not commonly used.	Jim Bean, Cigna
#Z125	DB2 z/OS	18 MAR 75 Mins	Things About Db2 I wish I'd Remember When... With all the changes and enhancements made to Db2 over the years, it is getting more and more challenging to know the exact command, syntax or option to use for any given feature/function. Continuous Delivery has not made it any easier. This presentation will cover some of the more overlooked or forgotten options, commands, syntax that could prove to be invaluable in managing your Db2 environment. Click below to register.	Michael Cotignola

Recent Popular Replays

Show	OS	Replay Link	Theme	Guest(s)	Photos
#241	DB2 LUW	Watch Replay	The Db2 Access Plan Troubleshooting Handbook Optimal query access plans are essential for good query performance and it is the Db2 query optimizer's job to choose the best one. This presentation will cover monitoring and explain facility techniques to help you determine why an access plan is performing poorly and how to correct some common sub-optimal access plan problems. Attend this session to learn the essentials of access plan troubleshooting and query performance tuning.	John Hornibrook, STSM, IBM Toronto Lab @rld_box
#240	DB2 LUW	Watch Replay	Techniques for Optimal DB Performance Part 1 In this presentation, Jim Bean covers many performance improvement considerations and techniques that can be applied to relational databases; many of the examples come from Db2 LUW and Db2 on zOS. We'll see the impact of these types of changes, and look at several recent features not commonly used.	Jim Bean, Cigna
#239	DB2 LUW	Watch Replay	Db2 Blu Improvements Satya presents an important update to many features: - Db2 BLU Storage and Compression Features - Db2 Runtime Features - Db2 Catalog Features - Db2 Connectivity and Spatial Features	Satya Krishnaswamy @satya_ksr
#238	DB2 LUW	Watch Replay	Lessons Learned with Building Db2 HADR Clusters on AWS Running Db2 on "the cloud" is now very common. There are a number of ways to do this - everything from "roll your own" (IaaS) all the way through to using one of the IBM DBaaS offerings. This presentation looks at lessons learnt while building fully automated Db2 clusters on top of IaaS on Amazon's AWS cloud. After discussing why we might want to use IaaS rather than a fully managed service, we will look at what producing a Db2 build for AWS teaches us both about Db2 features and the AWS (and other) cloud platforms.	Philip Nelson
#237	DB2 LUW	Watch Replay	Db2 REST - From Movie Recommendation to... Shazam!? Let's dive into Db2 REST, a modern, REST-based interface for your data, that's flexible enough to be applied practically anywhere. Let's take a look at a real-world movie recommendation application powered by Db2 REST. We'll also have some fun exploring a music discovery app - similar to Shazam - powered by Db2 and Db2 REST. Click register for details...	Tanmay Bakshi @TajyMany
#236	DB2 LUW	Watch Replay	Analyze data with the new Db2 Graph and train an ML model using 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 IBM Db2 on Cloud offerings.	Tanmay Sinha @tanmaysinha
#235	DB2 LUW	Watch Replay	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.	Piotr Mierzejewski @piotrm42
#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
#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
#z122	DB2 z/OS	Watch Replay	Data Gate: Current and Consistent Db2 for z/OS Data on any Cloud Data Gate is the most simple, fast and and resource efficient way to provide a read-only copy of your Z data on Cloud for your modern applications that operate on Z data. This presentation includes a demo.	Sowmya Kameswaran, IBM SVL
#z121	DB2 z/OS	Watch Replay	Esoteric Functions in Db2 In this presentation Roy will delve into FTB/FIT, Spatial Indexes, Regular Expressions, Clone tables and Scrollable cursors. All of these could be called esoteric as most shops do not use or even know of their existence! I would hope that after this presentation the viewers will have learned something new about Db2 and perhaps could use one or more of these esoteric functions so that it becomes "well known" function and not a hidden gem!	Roy Boxwell, Software Engineering @rld_box
#z120	DB2 z/OS	Watch Replay	Building Blocks of Db2 Have you ever wondered what those cryptic values for the columns in PLAN_TABLE mean? This beginner level presentation answers your questions. The RDS and Data Manager use a relatively small number of types of simple requests which are set oriented, like retrieving all rows from a table through a matching index scan, sorting a workfile, etc. This presentation delves into these in depth; we try to pretend we are the DB2 Optimizer and select the best block for the job!	Jim Dee @dee_jim
#Z119	DB2 z/OS & LUW	Watch Replay	Secure by design: Best practices to design security into your database and applications This presentation details Db2 z/OS and LUW database design security techniques, steganography procedures and application audit practices. You will learn about systems/application security vulnerabilities, security design techniques for your data tables and recommended audit mitigation strategies/checklists/SQL Scripts. These system and application security best practices will help you secure your database designs and improve your application security profile.	Dave Beulke @DBeulke
#Z118	DB2 z/OS	Watch Replay	Favorite Db2 z/OS Performance and Optimization Features V9-V12 Want to know more about the optimization improvements since V9? There were many and this presentation provides some of best and favorites that all developers should know about. As with all Db2 z/OS releases, Db2 delivers a large number of new features, functions, enhancements, and optimization improvements with many specific to the developers. Come away with a better understanding of the Db2 z/OS optimizer.	Tony Andrews @TonyAndrews12
#Z117	Db2 z/OS	Watch Replay	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
#Z116	Db2 z/OS	Watch Replay	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
#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