Team with the best
Database 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!
#z127 DB2
z/OS
20 MAY
75 Mins
Db2 V13 Migration Planning
Join us to hear about planning and considerations for migrating to the recently announced Db2 V13!
Register
Anthony Ciabattoni
@aciabattoni

John Lyle
Anthony Ciabattoni

John Lyle
#246 DB2
LUW
10 JUN
75 Mins
Db2 Advanced Log Space Management - Unleashed
Trying to figure out the ins and outs of Db2 Log Space Management? Db2 11.5 GA introduced Advanced Log Space Management as a technical preview. Now fully supported, we will do a deep dive into the technology and transformation behind making log space management more hands off, which in the end will make life simple for you and your organization.
Register
Michael Roecken
@roecken
Michael Roecken

Recent Popular Replays

Show OS Replay Link Theme Guest(s) Photos
#245 DB2
LUW
Watch
Replay
Db2U Current Capabilities and Future Direction
Db2 on CPD/OpenShift/k8s (a.k.a. Db2U) current capabilities and future direction will be focused around overall Db2U current and next-gen architecture, cloud native features, deployment patterns and supported platforms.
Aruna De Silva
@aruna_desilva

Janpreet Singh Chandhok
@chandhok97
Aruna De Silva

Janpreet Singh Chandhok
#244 DB2
LUW
Watch
Replay
Db2 AIX to X86 Linux Migration
Db2 customers currently running AIX have a challenge when then plan to migrate to a cloud based environment. All major cloud vendors provide X86 Linux support whereas AIX support is only available on IBM Cloud through the Power Server Virtual Server offering. As such, the majority of customers planning on migrating to an cloud environment will be required to migrate the database to an X86 Linux deployment. This presentation will examine several aspects of such a migration, e.g. how it affects HA, how to physically move the data as well as what would be the required amount to resources to run the same workload in an X86 environment.
Dale McInnis
@dalemcinnis
Dale McInnis
#243 DB2
LUW
Watch
Replay
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 Jim Bean on LinkedIn
#242 DB2
LUW
Watch
Replay
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.
Piotr Mierzejewski
@piotrm42
Piotr Mierzejewski
#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
John Hornibrook on LinkedIn
#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 Jim Bean on LinkedIn
#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
#z126 DB2
z/OS
Watch
Replay
Tuning SQL that Still Works V2
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
#Z125 DB2
z/OS
Watch
Replay
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.
Michael Cotignola
Michael Cotignola
#Z124 DB2
z/OS
Watch
Replay
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.
Haakon Roberts
@db2tools
Haakon Roberts
#Z123 DB2
z/OS
Watch
Replay
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.
Patrik Bossman
@Bossman2day
Patrick Bossman
#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 Sowmya Kameswaran on LinkedIn
#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