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 #14! FOURTEEN 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!

Recent Popular Replays

Show OS Replay Link Theme Guest(s) Photos
#263 DB2
LUW
Watch
Replay
Monitoring and Tuning Native SQL Stored Procedures
This presentation offered in-depth store procedure tuning tips
Philip Nelson Phil on LinkedIn
#262 DB2
LUW
Watch
Replay
Build a Lightweight Monitor to Identify SQL Workload Tuning Potential
This presentation offered in-depth monitoring insights using EXPLAIN
Kai Stroh Kai on LinkedIn
#261 DB2
LUW
Watch
Replay
Amazon RDS for Db2
This presentation offered in-depth insights into Db2 RDS implementations and solutions to the most common challenges faced by customers
Karthik Gopalakrishnan and Vikram S Khatri from Amazon Karthik on LinkedIn
#260 DB2
LUW
Watch
Replay
Db2 Performance FAQ's
This presentation offered valuable insights into common Db2 performance issues and provided effective solutions for each problem identified.
Raghavendra C, Senior Staff Software Engineer, IBM Software Labs, India Raghavendra C on LinkedIn
#259 DB2
LUW
Watch
Replay
Db2 Warehouse (SaaS) Gen 3
This presentation provides information about Db2 11.5.9 Next Generation Data Warehouse, Watsonx.data and Data Lake.
Les King, Data Architect, IBM Toronto Lab Les King on LinkedIn
#258 DB2
LUW
Watch
Replay
Db2 Database Upgrade in pureScale
This presentation provides step by step instructions for a complex Db2 pureScale upgrade.
Mohan Saraswatipura, IBM Gold Consultant Mohan Saraswatipura on LinkedIn
#257 DB2
LUW
Watch
Replay
All About IDUG
This presentation provides an overview of IDUG 2024 technical tracks, recent IDUG website updates and logistics for 2024 NA conference. The 2024 IDUG conference offers a comprehensive and flexible experience, combining the benefits of in-person and virtual participation. With a diverse range of session tracks, interactive workshops, and extensive networking opportunities, the conference aims to cater to the varied interests and needs of the Db2 community. The logistics are designed to ensure a smooth and enjoyable experience for all attendees, with a focus on accessibility, safety, and technical support.
Chris Muncan, IDUG CPC Chair 2024 Chris Muncan on LinkedIn
#256 DB2
LUW
Watch
Replay
Machine Learning Optimizer Feature in Db2
This presentation looks at the Machine Learning Optimizer in Db2. In particular, the first use is for better cardinality estimation (estimating the number of rows within the optimizer plan). We look at capabilities in the Tech Preview that has been available for some time now. We will also look at the what will be done towards getting it out for production use. Some usage scenarios comparing the new functionality with the traditional optimizer functionality will be presented. Click register for details...
Calisto Zuzarte, IBM Toronto Lab Calisto Zuzarte on LinkedIn
#255 DB2
LUW
Watch
Replay
Db2 Always-On Architecture
The IT landscape has changed in the past 10+ years with IT systems and customers being global rather local. This has created a number of problems as peak times can now come in waves from around the globe and batch windows have shortened. This volume increase has driven an explosion in data volumes and server horsepower for even simple applications. Leading IT organizations need to handle this change and react as quickly as the business requires.
Dale McInnis
@dalemcinnis
Dale McInnis
#254 DB2
LUW
Watch
Replay
Db2 UDFs : Beyond the Basics
Db2 User Defined Functions (UDFs) are a largely ignored tool in the developer's armoury, providing exciting and in some cases unique capabilities. This presentation will go beyond creating simple UDFs to look at more complex use cases and capabilities. A particular focus will be on table UDFs and why they sometimes are better than stored procedures.
Philip Nelson Phil Nelson
#253 DB2
LUW
Watch
Replay
Explain Essentials for Query Optimization
One of the most important factors in query performance is the access plan chosen by the Db2 query optimizer. This presentation will cover the most important techniques for collecting and using explain information so that you can quickly and effectively understand your access plans to achieve and maintain the best possible query performance.
John Hornibrook, STSM, IBM Toronto Lab
@rld_box
John Hornibrook on LinkedIn
#252 DB2
LUW
Watch
Replay
SQL in Action: SQL Traps and Solutions
In this session I will show some SQL traps and how to escape them.
Michael Tiefenbacher
@globomike
Michael Tiefenbacher
#251 DB2
LUW
Watch
Replay
What's New in Db2 11.5.8
The Show's opening monologue will start with an description of the v11.5.8 continuous delivery model, multi-platform & container-only installs and the new mod/fix pack numbering scheme. After that we will have a deep dive into the Top 10 (or so) key enhancements on the v11.5.8 roadmap.
Keri Romanufa
@RomanufaKeri
Keri Romanufa
#250 Db2
LUW
Watch
Replay
A Db2 Security Primer
Security demands continue to grow and you need to be aware of all the tools and capabilities that Db2 provides you in this area. This session provides a review of the Db2 security landscape for those new to Db2 and to grizzled veterans. We will look at the various features and functions available across the four primary security domains: authentication ; authorization ; auditing ; and encryption. Along the way ; we will discover a couple of potential "gotchas" and some lesser known aspects of Db2 security.
Greg Stager
@GregStager
Greg Stager
#249 DB2
LUW
Watch
Replay
Db2 Warehouse Reference Architectures for X86 & Power
We are announcing two new Reference Architectures which are designed to optimize Db2 for high end - petabyte scale - warehouse/OLAP workloads. These reference architectures are called "Db2 Warehouse Reference Architecture for X86" and "Db2 Warehouse Reference Architecture for Power" and are designed to be on-premises follow-ons to our Db2-based analytic appliances (PDOA and IIAS). In this session we will review the next generation of Db2-based platforms for warehouse/analytic workloads and drill down into the architecture and other details of these two new offerings..
Les King
@LesKing00
Les King
#248 DB2
LUW
Watch
Replay
Db2 pureScale on AWS - The New Experience
With the availability of Db2 pureScale on AWS as a self-managed service, not only does it continue to provide the same value propositions as in on-premise deployments, it opens up many other opportunities. This session introduces the new revolutionary journey, unveils the added benefits, covers the new use cases that break the traditional "time-barrier" in on-premises deployments and drastically reduces the total cost of ownership. The session wraps up with a sneak peek at the next phase of enhancement in this AWS journey as well as the path on other public clouds.
Alan Lee
@ykalee1
Alan Lee
#247 DB2
LUW
Watch
Replay
Db2 Click-2-Containerize
Deploying an existing Db2 to OpenShift or Cloud Pak for Data usually involves some form of export and import and a lot of work! Rather than you having to do all of the hard work, we introduced the Click to Containerize tool to help you move your on premise Db2 Linux database directly to the Cloud - with no exporting of data! A lot has changed in the last year and Click to Containerize Version 2 is now in technical preview! This session will take you through the new enhancements to the IBM Db2 C2C program and how it can help modernize your Db2 databases quickly and efficiently!
George Baklarz
@upintheairyyz
George Baklarz
#z138 DB2
z/OS
Watch
Replay
Db2 User Experience Transformation Strategy
This is an of Db2z app dev capabilities. Click register for details...
Sowmya Kameswaran, IBM SVL Sowmya Kameswaran on LinkedIn
#Z137 DB2
z/OS
Watch
Replay
Db2 Java Performance Best Practices Version X
Learn how to achieve blazing-fast Db2 and Java performance with these proven best practices. In this presentation, we'll cover essential Db2 coding techniques, Java class frameworks, and debugging/tracing practices to identify and resolve performance bottlenecks in record time. Whether you need to improve Db2 access, optimize Java runtimes, minimize CPU usage, or process billions of rows, this presentation's real world expert advice will help you achieve top-tier performance. Click register for details...
Dave Beulke
@DBeulke
Dave Beulke
#z136 DB2
z/OS
Watch
Replay
Examples of Db2 Mistakes for others to Avoid
It may be one summer, collection, package or one query brings your CPU to its knees. These are the war stories that I will cover so you can learn from others’ mistakes. Examples of seriously delayed filtering, not following performance rules, checking to see if Db2 is up, and many other tricky but painful techniques will be divulged.
Slow Down Db2
Sheryl Larsen
@smlsql
Sheryl Larsen
#Z135 Db2
z/OS
Watch
Replay
Use Profiles to Monitor and Control Db2 Application Context
With increased popularity of distributed applications, related Db2 system and application definitions were defined in distributed application servers. Sub-optimal definitions could impact on overall Db2 health. Db2 z/OS provides capabilities to create profiles to monitor and control various aspects of a Db2 specific system and application contexts in Db2 profile tables. Db2 13 extends the profile tables to new attributes for local and remote applications. Maryela will review existing profile capabilities and introduce Db2 13 extensions as well as discuss use case examples. Click register for details...
Maryela Weihrauch Maryela Weirauch
#z134 DB2
z/OS
Watch
Replay
An Audit a day keeps the lawyers at bay!
Stricter government regulations for Data Protection, Monitoring and Auditing require even more vigilance for the CSO, not only to control prohibited access, but also database activities of authorized entities to do their jobs. Beside the organizational issues, cost based challenges should be in focus: Is this 360 degree solution achieved CPU friendly (e.g. z/OS OPx buffer technology)? Are reports and audit preparation based on IBM GUI standards (Eclipse, Zowe)? Is used technology IBM compliant or Vendor specific (Code or appliances)? Click register for details...
Roy Boxwell, Software Engineering
@rld_box
Roy Boxwell on LinkedIn
#z133 DB2
z/OS
Watch
Replay
A Row's Life
Rows in a DB2 z/OS database get mauled and moved and wholly and partially duplicated. There are different ways to find them and different surroundings. And most DBAs find they need to understand these transformations thoroughly to manage performance and recovery and even security. In this presentation, we take a light-hearted view of one row's life to emphasize some of the internals of DB2 on the z/OS platform.
Marcus Davage, BMC
@spufidoo
Marcus Davage on LinkedIn
#z132 DB2
z/OS
& LUW
Watch
Replay
Temporary Tables in DB2 SQL. DGTT and CGTT and more. How to use effectively. Lessons learned!
The SQL concept of 'temporary tables' allows for creation of powerful SQL. Understanding the different types of temporary tables will allow the end-user the option to create useful SQL that may be relatively simpler to understand and allows great flexibility. The presentation will attempt to clearly drive home the difference between DGTT and CGTT. I will share the experience of how a simple DGTT was used in a new high-volume transaction and cost was relatively high. Switching to CGTT fantastically reduced cost!
Brian Laube, Manulife
Brian Laube on LinkedIn
#z131 DB2
z/OS
Watch
Replay
Transforming Db2 for z/OS Application Development Experience
Db2 for z/OS supports mission-critical applications that power the businesses of many Fortune 100 companies. Our customers rely daily on transactional and analytical applications to gain useful insights from data residing on Db2 for z/OS. This makes application development and debugging essential to our customers' daily operations. Join us as we discuss and demonstrate how the application development landscape has changed and how were bringing Db2 to your favorite code editors.
Katherine Soohoo, IBM
Katherine Soohoo on LinkedIn
#z130 DB2
z/OS
Watch
Replay
Db2 13 for z/OS Technical Overview
The purpose of this presentation is to introduce the new migration process for the new Db2 13 for z/OS release. The Db2 13 release migration process is significantly different from any previous Db2 release migration. The changes are, in fact, revolutionary. We will detail the Db2 12 to Db2 13 migration process, the Db2 13 Installation process, and go into details regarding application compatibility and the Continuous Delivery process as it relates to Db2 13. Each release brings new migration processes and challenges we will detail the nuts and bolts of the significant Db2 13 process and procedure changes.
Robert Catterall, IBM
Robert Catterall on LinkedIn
#z129 DB2
z/OS
Watch
Replay
UTS - Past, Present & Future
The UTS has been with us since DB2 V9 and now in Db2 12 it got an upgrade with the UTS PBR RPN type. In this presentation I wish to show you how to use which variant, and when, for the best performance and utility balance. I will also briefly review the history of UTS and its probable future development. Click register for details...
Roy Boxwell, Software Engineering
@rld_box
Roy Boxwell on LinkedIn

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