Team with the best
Db2® LUW Performance Tools
company in the World

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! Share/Bookmark
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!
#240 DB2
LUW
10 DEC
75 Mins
Considerations and Techniques for Optimal Database Performance
In this presentation Jim Bean will cover 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. Click register for details...
Register button
Jim Bean, Cigna Jim Bean on LinkedIn
#z122 DB2
z/OS
17 DEC
75 Mins
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. Click register for details...
Register button
Sowmya Kameswaran, IBM SVL Sowmya Kameswaran on LinkedIn
#218 DB2
LUW
14 JAN
75 Mins
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.
Register button
John Hornibrook, STSM, IBM Toronto Lab
@rld_box
John Hornibrook on LinkedIn
#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.
Register
Patrik Bossman
@Bossman2day
Patrick Bossman

Recent Popular Replays

Show OS Replay Link Theme Guest(s) Photos
#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
Jim Dee
#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 Phil 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
Tanmay Bakshi
#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
Tanmay Sinha
#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
Piotr Mierzejewski
#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
John Hornibrook on LinkedIn
#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
Tanmay Sinha
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
Piotr Mierzejewski
#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
Roy Boxwell on LinkedIn
#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
Jim Dee
#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
Dave Beulke
#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
Tony Andrews
#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
Steen Rasmussen
#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...
Register button
Maryela Weihrauch Maryela Weirauch
#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
Dave Beulke
#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
Sheryl Larsen
#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
Roy Boxwell on LinkedIn
#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
Daniel Luksetich
#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
Cristian Molaro
#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
Patrick Bossman
#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
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". IDUG Logo
www.IDUG.org
DBI Logo
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:
RSS 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. RSS Feed 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!

The Db2Night Show™

The Db2Night Show Logo
REPLAYS :: LUW :: z/OS :: Family
SHOW NEWS

Please use hash tag
#DB2Night in your Tweets!

Each Studio Audience is limited to only the first 1,000 people who reserve free tickets. If a show gets "Sold out", check back here for replay information. Please help us keep this show free by forwarding news and registration links for each episode to your friends.

FAQs


FAQ 1: I'm having trouble joining.
ANS 1: It's rare, but sometimes firewalls get in the way. For solutions, visit Citrix Firewalls

FAQ 2: Can I get a PDF copy of the slides?
ANS 2: We often make the slide deck available for download, but it is up to the presenter. We protect the intellectual property of our guests.

FAQ 3: Why is the show called The Db2Night Show when the events are held during the day?
ANS 3: Like many late night TV Shows, recordings actually occur during the daytime with live studio audiences. How many of you would get out of bed at 11pm to watch DB2 on TV?

FAQ 4: The show recordings occur during US time zones. What about those of us in Europe and Australia?
ANS 4: Our challenge is finding show guests. We often have European speakers; our show time is late afternoon for them. For other parts of the world, this can be tricky.

Our Favorite Blogs



Our Db2 Community

World of Db2 Logo