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.


2015 IDUG Philadelphia

2015 IDUG Melbourne Australia

2015 IDUG EMEA Dublin Ireland


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-
Click to see profiles!
#Z58 DB2
z/OS
MAY 15

60 Minutes

What you must know about Distributed access to DB2 for z/OS - Part 2
Due to popular demand, this is continuation of show z56! Distributed access to DB2 is everywhere and is becoming the application environment standard. This presentation contains top tricks, hidden secrets, and gems that you must know. A review of the state of the art and industry best practices.

Click for Details and Registration: Register

Cristian Molaro
IBM Champion and Gold Consultant
Cristian Molaro
#158 DB2
LUW
MAY 22

60 Minutes

Database Maintenance with NO outages using DB2 HADR
This is a real life DB2 customer success story about 24x7x365 high availability and DB2 HADR ROS (Read on Standby). Our guest isn't from IBM, isn't a consultant, but is a real live extraordinary human with an extraordinary story to tell. If you use HADR, DON'T MISS THIS SHOW!

Click for Details and Registration: Register

Sanjay Trehan, Sr. DBA
Sanjay Trehan
#159 DB2
LUW
June 5

75 Minutes

Monitoring DB2 BLU Acceleration In-Depth
David Kalmuk, STSM, IBM Canada, is responsible for DB2 LUW monitoring and workload management. Based on his IDUG presentation, during this session David will share what's new with BLU monitoring along with performance considerations!

Click for Details and Registration: Register

David Kalmuk,
STSM, IBM Canada
David Kalmuk
#160 DB2
LUW
June 19

75 Minutes

Top 10 DB2 LUW Explain Tips
John Hornibrook is one of the leading brains behind DB2 LUW's optimizer. He's been our guest before talking about statistics and SQL performance, and during show #160 he returns to help us understand DB2's Explain Facilities. Attend this show and learn how to optimize your query performance!

Click for Details and Registration: Register

John Hornibrook,
STSM, IBM Canada
John Hornibrook

Recent Popular Replays

Show OS Replay Link Theme Guest(s) Photos
#157 DB2
LUW
Watch
Replay

GET
PDF!
DB2 V10.5 FP5 New Encryption Offering
Learn about Encryption, DB2's offering, Key Management, How to Encrypt your databases, Backup and Restore implications, plus Utilities, Diagnostics, and other considerations.
George Baklarz, IBM
George Baklarz
#156 DB2
LUW
Watch
Replay
Using and Optimizing DataStage and DB2
DataStage one of the leading ETL-Tools and therefore often used in combination with DB2. This show focuses especially on this successful combination - both from a DataStage and a DB2 perspective.
Michael Tiefenbacher
Michael Tiefenbacher
#155 DB2
Family
Watch
Replay
ALL ABOUT IDUG &
DB2's GOT TALENT Winners

IDUG Philadelphia Conference volunteers will share conference highlights, format changes, and tips for optimizing your conference experience! Find out about new Hands-on-Labs, Seminars, and networking opportunities! Plus, we'll be announcing DB2's GOT TALENT 2015 Winners!
IDUG
Volunteers

featuring

Terry Johnson
Conference Chair

IDUG NA Philly Logo
#148
&
#150
DB2
LUW
Part 1
Replay

Part 2
Replay

DB2 LUW 10.1/10.5 Certification Crammer - Parts 1 & 2
There's a new DB2 10.1/10.5 Certification book coming out soon written by Mohan Saraswatipura and Kent Collins. Mohan was 1st place winner of DB2's GOT TALENT 2013, and Kent has appeared as our special guest in Episode #115 "DB2 BLU & pureScale Real Life Successes and Advice".

Mohan
Saraswatipura
Kent
Collins
Mohan Saraswatipura
Kent (Robert) Collins
#146 DB2
LUW
Watch
Replay
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!
Adam Storm
IBM STSM
& Master Inventor
Adam Storm
#145 DB2
LUW
Watch
Replay
"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!
Melanie Stopfer
DB2 Brain
Surgeon
Melanie Stopfer
#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
#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
#Z55 DB2
z/OS
Watch
Replay
Avoiding L2 Performance PMRs
Root cause analysis of presumed, or actual DB2 performance issues can be quite tricky in today's diverse environments. Wouldn't it be nice if there were ways that could quickly guide you in the direction of the root cause?

Adrian Burke
DB2 SWAT Team
IBM SVL
Adrian Burke
#Z56 DB2
z/OS
Watch
Replay
What you must know about Distributed access to DB2 for z/OS
Distributed access to DB2 is everywhere and is becoming the application environment standard. This presentation contains top tricks, hidden secrets, and gems that you must know. A review of the state of the art and industry best practices.
Cristian Molaro
IBM Champion and Gold Consultant
Cristian Molaro
#Z57 DB2
z/OS
Watch
Replay
IBM DB2 Analytics Accelerator for z/OS - More Than Just Query Acceleration
IBM DB2 Analytics Accelerator for z/OS as you know it is an appliance attached to DB2 running on the mainframe that can accelerate analytical queries by orders of magnitude.

Hybrid Transaction and Analytics Processing(HTAP) however requires more than just running queries. Listen in to see how the accelerator is extended with features like accelerator-only tables to support many more use cases.

Peter Bendel
Peter Bendel

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 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.