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

The Db2Night Show™

Educate. Inform. Entertain.

FEATURED Db2 LUW V11.1 REPLAYS: Part 1: What's New in Db2 LUW V11
Guests Matt Huras and Berni Schiefer, IBM Canada Lab


Part 2: Db2 LUW V11
Deep Dive
on
BLU and Analytics
Part 3: Db2 LUW V11
Deep Dive
on
OLTP and pureScale
Part 4: Db2 LUW V11
Upgrade Best Practices
with Melanie Stopfer
Part 5: Db2 LUW V11
FREE Resources
with
George Baklarz

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 #10 - Starting in September!

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!
#207 Db2
LUW
28 SEPT
75 Mins
Db2 News from IBM Canada Lab
We're kicking off Season #10 of The Db2Night Show with the latest news from the IBM Lab. Be sure to join us for updates on Db2 announcements! Register button
Les King
@LesKing00
Les King

Recent Popular Replays

Show OS Replay Link Theme Guest(s) Photos
#204 Db2
LUW
Watch
Replay
Db2 LUW on AWS Cloud - SAP Experiences
Arwel Owen, known as @SAP_AWS on Twitter, has achieved some pretty spectacular performance, compression, and cost savings results by moving his company's SAP Db2 environment to the AWS cloud. Join us and learn from his experiences.
Arwel Owen
@sap_aws
Arwel Owen
#206 Db2
LUW
Watch
Replay
A Crash Course on Db2 pureScale and Advantages
IBM Champions, and Db2 Certification Book Authors, Mohan Saraswatipura and Kent Collins return as our special guests to give us a crash course on Db2 pureScale and its advantages.
Mohan Saraswatipura
@mohankumarsp
Kent Collins
@rcollins963
Mohan Saraswatipura
Robert (Kent) Collins
#205 Db2
LUW
Watch
Replay
Deep Dive into Db2 LUW Locks, Logs, and pureScale
IBM Champions, and Db2 Certification Book Authors, Mohan Saraswatipura and Kent Collins return as our special guests to give us a deep dive on Db2 V11 locks, logs, and pureScale.
Mohan Saraswatipura
@mohankumarsp
Kent Collins
@rcollins963
Mohan Saraswatipura
Robert (Kent) Collins
#203 Db2
Family
Watch
Replay
ALL ABOUT IDUG!
It's our annual show wherein we invite IDUG volunteer guests to share insider information about upcoming IDUG conferences - with a focus on IDUG North America in Philadelphia April 29th to May 3rd. If you'll be attending IDUG, or if you're thinking about attending, don't miss this show for the latest conference information!
IDUG Volunteers
@IDUGDB2
IDUG
#202 Db2
LUW
Watch
Replay
Using Jupyter Notebook for Db2 Administration
Our guest, Ember Crooks, had standing room only for this presentation at IDUG EMEA Lisbon 2017! Join us and learn how you can use Jupyter Notebooks to help you with DBA tasks and reporting! Make sure you attend to see the LIVE demonstration!
Ember Crooks
@ember_crooks
Ember Crooks, IBM GOLD Consultant, Xtivia
#201 Db2
LUW
Watch
Replay
Favorite Tuning Tips and Tricks for Db2 LUW
Joe Geller won Best User Speaker at IDUG EMEA Lisbon 2017 with this fantastic presentation about his favorite tips and tricks for tuning Db2 LUW. There's 100% chance you're going to learn something helpful!
Joe Geller Joe Geller, Db2 Performance Specialist
#200 Db2
LUW
Watch
Replay
Db2 V11 Performance: BLU Hits and Misses
Based on his popular IDUG Lisbon Db2 technical session, Mark will cover an overview of BLU, examples of workload performance in V10.5, the benefits of V11.1 for your workload, show examples of where the BLU savings are, and share some GOTCHAS where you might not realize the advertised benefits of BLU.
Mark Gillis
@db2geek
Mark Gillis, Principal Consultant, Triton
#198 Db2
LUW
Watch
Replay
The 5 W's of Db2 HADR
Our special guest, Dale McInnis, is the father of Db2 backup, recovery, HADR, and all things related thereto. During this show, Dale will share with us a newer presentation on the 5 W's of HADR. If you're using HADR or thinking about it, make sure you join us!
Dale McInnis
@dalemmcinnis
Dale McInnis, IBM STSM
#197 Db2
LUW
Watch
Replay
Db2 Science Projects, IoT, WLM, and other cool stuff!
Roger Sanders has been tinkering with Db2 IoT technologies, and he's built something really cool that he's keen to share. Paul Bird has updated the Db2 WLM Graphical User Interface and you need to see it!
Roger Sanders
@Roger_E_Sanders
Paul Bird
@IBM_Paul_Bird
Roger Sanders, Db2 Offering Manager
Paul Bird, STSM, IBM Canada
#194 DB2
LUW
Watch
Replay
Interviewing the DB2 LUW Optimizer
Special guest Ember Crooks returns to share with us her advice on understanding Explains and the DB2 LUW optimizer!
Ember Crooks
@ember_crooks
Ember Crooks
#189 DB2
LUW
Watch
Replay
IBM DB2 LUW Optimized for SAP - The Rest of the Story
Martin Hubel, an IBM DB2 GOLD Consultant and IBM Champion, and the leading independent DB2 LUW SAP Performance Expert, will share his insights about performance optimization for SAP databases.
Martin Hubel
@mhubel
Martin Hubel
#188 DB2
LUW
Watch
Replay
Sage Advice Part 3-
Predictive Index Impact Analysis - Know before you Create!
Based on his popular and highly rated IDUG presentations, Scott continues his Sage Advice series with Part 3 which reviews Part 1 (weight analysis) and Part 2 (advanced index benefit analysis), then introduces Predictive Index Impact Analysis - a method for forecasting the impacts of index(es) before they are created!
Scott Hayes
@srhayes
Scott Hayes
#Z88 Db2
z/OS
and
LUW
Watch
Replay
DB2 Security Best Practices Volume II
Implementing the best security techniques and strongest configuration is mandatory these days for safe guarding your data. This presentation discusses the latest DB2 security methods, procedures and techniques for fortifying DB2 systems, databases and applications. This presentation details DB2 z/OS and DB2 LUW security strategies such as the impacts of encryption, database design security techniques and how best implement a multi-layered DB2 security data perimeter.
Dave Beulke Dave Beulke
#Z87 DB2
z/OS
Watch
Replay
Db2 RESTful Service Support and z/OS Connect
The Application Programming Interface (or short API) Economy has changed how developers build application and how organization deploy software as a service. Mobile devices have accelerated the shift of providing services via API. Maryela will show how SQL and stored procedures in Db2 on z/OS can be made available in the era of application assembly and integrate with z/OS Connect EE.
Maryela Weihrauch
IBM Distinguished Engineer
@zAnalyticsGURU
Maryela Weihrauch
#Z86 DB2
z/OS
Watch
Replay
Pre-IDUG Db2 for z/OS Update
This presentation gives a summary of some of the latest news and deliveries from Db2 for z/OS development. Kind of a preview of what will be covered at the IDUG North American conference at the end of April, if you will.
Jeff Josten Jeff Josten
#Z85 DB2
z/OS
Watch
Replay
Db2 12 Continuous Delivery - New challenges for deployment
Fundamental changes in the Db2 z world often lead to concerns. Let's face it - some changes force us to change! This will have a tremendous impact on migration strategies, because we have to find a reliable way to test these code deliveries in a fraction of the time we used to have. This presentation will describe the difference between Code, Catalog, Function and Application Levels, how you can control them and how you can fallback in case of anomalies.
Roy Boxwell, Software Engineering Roy Boxwell on LinkedIn
#z84 DB2
z/OS
Watch
Replay
Revival of the SQL Tuner
The pool of DBAs with SME knowledge of SQL tuning has shrunk dramatically while the number of SQL statements needing attention has grown and will continue to grow. DB2 performance tooling can help identify what needs to be tuned. But what do you do then? This presentation will help fill the skills gap by reviving the role of an SQL Tuner.
Sheryl Larsen
@smlsql
Sheryl Larsen
#Z83 Db2
z/OS
Watch
Replay
Copy Smarter - Unload/Load, DSN1COPY and beyond
When you get tasked with setting up a refresh process for thousands of DB2 z/OS tables you probably have a few thoughts running through your head. This presentation discusses advantages and disadvantages of different utilities that copy DB2 data, but the main focus is automating all the side tasks that DBAs usually need to do in addition to copying the data itself.
Kai Stroh Kai Stroh
#Z82 Db2
z/OS
Watch
Replay
The Db2 12 Catalog -- What happened since Db2 11
There are many ways to learn about a new Db2 version, but using the catalog is probably the fastest and most enlightening. Once you look at the revision track in the Db2 Catalog and Directory section of the SQL Reference Guide, study the column changes, additions as well as new catalog tables, you have a very good overview of everything worth to know about that specific Db2 version.
Steen Rasmussen
@DB2rasmussen
Steen Rasmussen
#Z81 Db2
z/OS
Watch
Replay
Early experiences using Db2 for z/OS Transparent Data Set Encryption
Db2 11 and Db2 12 recently delivered a simple, transparent and consumable approach to enable extensive encryption of data at-rest. This new capability substantially reduces the people and hardware costs associated with protecting data & achieving compliance mandates. Db2 12 expands the Db2 11 functionality by providing new options to allow a DBA to manage encryption policies at a table level. The session discusses the differences between Db2 11 and Db2 12 and results of early customer experiences using this new encryption approach.
James Pickel Patrick Bossman
#Z80 Db2
z/OS
Watch
Replay
DevOps and Cloud Provisioning for Db2 z
Lost in the sea of application development terms? "DevOps, Agile, Continuous Delivery, Continuous Integration, Cloud Provisioning, Self-service economy, Shift Left" - What does all this mean? How does it affect me? Why are they doing this? This session focuses less on the buzz words than showing an example of what the development process can look like through a simple application development and deployment scenario, from initial sand-box check in, through merge into configuration management controlled environment. ** Please note: many parts of this presentation also apply to Db2 for LUW
Patrick Bossman
@Bossman2day
Patrick Bossman
#Z79 DB2
z/OS
Watch
Replay
zIIP Experiences: Exploitation Not Abuse
IT staffs are being pressed to get every cycle possible out of their System z Integrated Information Processor (zIIP) specialty engines and the now defunct System z Application Assist Processors (zAAP). DB2 for z/OS and related processes that run on System z can take advantage of these processors, and will be covered in depth during the presentation.
Adrian Burke
IBM DB2 SWAT team
@agb_DB2z
Adrian Burke

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
Responsive Systems Logo
www.responsivesystems.com
KBCE Logo
www.kbce.com
Triton Consulting Logo
www.Triton.co.uk

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.1 :: 11.1 PDFs :: 10.5 :: 10.1 :: 9.7 :: 9.5 :: 9.1 :: 8.2

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: Unlikely, but sometimes slide excerpts are made available. 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. Help us find guests that won't have to get out of bed at 2am and we will be happy to do studio audience live shows at peak European and Australian times.

FAQ 5: How do we become a sponsor of the show?
ANS 5: Email "db2nightshow" "at" "dbisoftware.com" for a prospectus.

Our Favorite Blogs



Our Db2 Community

World of Db2 Logo