The DB2Night Show™

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

Follow, and participate in,
The DB2Night Show at twitter.com/db2nightshow

Please use hash tag #DB2Night in your Tweets! Search #DB2Night!



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.


2014 IDUG EMEA


Our
Favorite Blogs


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 #6:

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/Time Theme Guest(s) Photos
#145 DB2
LUW
9 JAN 2015
90 Minutes
"db2pd" party with Melanie Stopfer, IBM
db2pd is one of the most powerful commands in DB2, and, without a doubt, one of the most popular. During this show, Melanie will present about a 1,000 cool and useful ways to use this versatile command!

Click for Details and Registration: Register

Melanie Stopfer
DB2 Brain
Surgeon
Melanie Stopfer
#146 DB2
LUW
30 JAN 2015
75 Minutes
Top 5 Cool Tricks with DB2 LUW
Adam Storm is an IBM STSM and Master Inventor working out of the IBM Canada Lab. His "Top 5 Tricks" Presentation at IDUG Prague received rave reviews from attendees, so we're bringing this COOL presentation on COOL tricks to our show!

Click for Details and Registration: Register

Adam Storm
IBM STSM
& Master Inventor
Adam Storm

Recent Popular Replays

Show OS Replay Link Theme Guest(s) Photos
#144 DB2
Family
Watch
Replay
Annual Eggnog Party!
We gather up top people in the world of DB2 (z/OS and LUW) and pass the microphone around the room. DB2 Industry Leaders, Consultants, and IBM folks are asked "What was great in 2014?" and "What are you looking forward to in 2015?" Scott Hayes drinks special eggnog. It's just fun and insightful!
Various
Guests
Eggnog Party!
#143 DB2
LUW
Watch
Replay
HADR and TSAMP Advanced Topics
Freshly graduated from the school of hard knocks, Ember Crooks will talk about what HADR really does, how it works, tools from IBM to optimize HADR, and TSAMP details behind the db2haicu command.
Ember Crooks
IBM DB2 GOLD
Consultant
Ember Crooks, Xtivia
#142 DB2
LUW
Watch
Replay
Sage Advice - DB2 LUW Performance Tuning
Based on his Top 10 Rated IDUG Presentation, Scott presents sage advice for DB2 LUW Tuning based on 20+ years of experience and over 2,000,000 miles flown on Delta Airlines. Read the fine print: Studio Audience ATTENDEES will receive FREE SQLs that you will learn about in this presentation!
Scott Hayes
IBM DB2 GOLD
Consultant
Scott Hayes, DBI Software
#141 DB2
LUW
Watch
Replay
DB2 V10.5 FP4 "CANCUN" - Early Consultant Experiences!
Iqbal has been our guest before and his shows are always top-ranked! During this episode, Iqbal will share his experiences with using and testing Cancun shadow tables and other features.
Iqbal Goralwalla
Triton
Iqbal Goralwalla
#140 DB2
LUW
Watch
Replay
DB2 V10.5 FP4 "CANCUN" Release
George Backlarz first introduced us to DB2 10.5 back on 24 May 2013 in Episode #111 "What's New", and now he's back to tell us about the first Fix Pack that is so special it was given a name - "Cancun"!
George Baklarz
IBM
George Baklarz
#138 DB2
LUW
Watch
Replay
DB2 LUW V10.5 Tips, Upgrades, and Best Practices
Famous for her love of chocolate chip cookies, Melanie has educated millions of DB2 professionals around the world with her awesome classes and conference presentations. Don't miss her DB2 10.5 upgrade best practices and advice!
Melanie Stopfer
IBM
Melanie Stopfer
#136 DB2
LUW
Watch
Replay
Why Wait!?!? DB2 LUW Locking!
Based on his excellent IDUG presentation "Why Wait?", our special guest Paul Turpin, Sr. DBA at BB&T, will share invaluable information about DB2 LUW Locking.
Paul Turpin,
BB&T Bank
Paul Turpin
#135 DB2
LUW
Watch
Replay
DB2 DPF Successes: Monitoring and Tuning a hybrid IBM Infosphere Warehouse
Pavan Kristipati, Sr. DBA at Huntington Bank, will share his experiences with tuning a large hybrid DPF database. This presentation is based on his joint presentation with Scott Hayes, DBI, given at IDUG on May 15 (session C10, 9:15am). Check out Pavan's blogs at db2talk.com!
Pavan Kristipati,
Huntington Bank
Pavan Kristipati
#Z49 DB2
z/OS
Watch
Replay
Understanding Query Transformation in DB2
When a query is submitted one of the first thing that happens is that it goes through query transformation. In this part of the process DB2 interprets the submitted SQL, and automatically rewrites it.
While this is a z/OS topic, most of it also applies to DB2 LUW.
Dan Luksetich
IBM Gold Consultant
DanL Consulting
Daniel Luksetich
#Z50 DB2
z/OS
Watch
Replay
z/OS DB2 Buffer Pool Tuning How to get the greatest benefits
Effective pool tuning offers great opportunities for improving both system and application performance. This presentation will take you through the basics and some steps of analysis and tuning, showing you how to analyze and tune your system, and evaluate the payback.
Joel Goldstein
Responsive Systems
Joel Goldstein
#Z51 DB2
z/OS
Watch
Replay
Willie's Winging It Volume 3
Willie Favero is one of our all time favorite DB2 speakers, and we are delighted to have him back this fall. Topics included service levels, documentation, zIIPs, and more!
Willie Favero
IBM SVL
Willie Favero
#Z52 DB2
z/OS
Watch
Replay
DB2 Thread Reuse and RELEASE(DEALLOCATE)
This session will introduce and discuss using RELEASE(DEALLOCATE) bind option with thread reuse to reduce CPU resource consumption. It will include a primer on thread reuse and the RELEASE bind option, considerations, limitations, and clean up activity.
John Campbell
Distinguished Engineer
DB2 for z/OS Development
John Campbell
#Z53 DB2
z/OS
Watch
Replay
Altering objects and the impact it has
Some alters are a piece of cake and can also reverted. Others are more complex and have a (big) impact. Some are still impossible and require you to drop and recreate the object. On this show, Klaas will discuss the many faces of ALTER and how to deal with them.
Klaas Brant
IBM Gold Consultant
KBCE
Klaas Brant
#Z54 DB2
z/OS
Watch
Replay
Tuning zIIPs for Fun and Profit
In the past few releases, DB2 for z/OS has steadily increased its exploitation of zIIP speciality processors. This presentation will review DB2 zIIP usage by release, and provide the attendee with some practical guidance on zIIP capacity planning and usage monitoring.
Julian Stuhler
IBM Gold Consultant
Triton
Julian Stuhler

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!

FREEDB2.com
We had links to this site, but Google Chrome warned of possible malware. DB2? Malware? LOL!
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
HLS Technologies Logo
www.hlstechnologies.com
Please inquire about sponsorship opportunities. Email "db2nightshow" "at" "dbisoftware.com". Please inquire about sponsorship opportunities. Email "db2nightshow" "at" "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 http://www.DBIsoftware.com/media/20090812INDEXES.wmv (112MB)

Quick Links to IBM DB2 LUW Knowledge Center

10.5 :: 10.1 :: 9.7 :: 9.5 :: 9.1 :: 8.2

FREE TOOLS from IBM!

Smarter Planet®, IBM®, Tivoli®, DB2® and others are registered trademarks of IBM Corporation in many jurisdictions, reused with permission of IBM Corporation. Any further reproduction must be authorized by IBM Corporation. DBI makes no claims of ownership to any registered trademarks or trademarks belonging to any other entity.