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!
#z133 DB2
z/OS
& LUW
27 JAN
75 Mins
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.
Register button
Marcus Davage, BMC
@spufidoo
Marcus Davage on LinkedIn
#252 DB2
LUW
10 FEB
75 Mins
SQL in Action: SQL Traps and Solutions
In this session I will show some SQL traps and how to escape them.
SQL Traps
Michael Tiefenbacher
@globomike
Michael Tiefenbacher
#253 DB2
LUW
10 MAR
75 Mins
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.
Phil's topic
Philip Nelson Phil Nelson
#254 DB2
LUW
14 APR
75 Mins
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.
Register button
John Hornibrook, STSM, IBM Toronto Lab
@rld_box
John Hornibrook on LinkedIn

Recent Popular Replays

Show OS Replay Link Theme Guest(s) Photos
#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
#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