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 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!
#Z59 DB2
z/OS
MAY 29

60 Minutes

Comparing IBM DB2 for z/OS's Hybrid Transaction and Analytics Platform to Oracle
August 2014, Oracle launched the in-memory option for its database. Oracle may be using this launch as an opportunity to target your company for a discussion about re-hosting your DB2 for z/OS workloads. If your company is confused by the hype from Oracle sales campaigns, join me for a focused discussion that will teach you how to defend your workload through an understanding of the marketing myths surrounding Oracle technology.

Click for Details and Registration: Register

Sheryl Larsen
Sr. DB2 Product Specialist, BMC Software
Sheryl M. Larsen
#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
#Z60 DB2
z/OS
June 12

60 Minutes

SQL Performance for a Big Data 22 Billion row data warehouse
This presentation discusses the design, architecture, performance and complex SQL issues building and reporting within a big data analytics DW system. This presentation has 30 SQL tuning tips, the real life issues, agile SQL considerations and SQL design solutions, built in six months.

Click for Details and Registration: Register

David Beulke
IBM Gold Consultant and Champion for IM
Dave Beulke
#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
#Z61 DB2
z/OS
JUNE 26

60 Minutes

Sheryl Larsen Week 2
Sheryl is a knowledge, popular speaker. Stay tuned for her topic!

Click for Details and Registration: Register

Sheryl Larsen
Sr. DB2 Product Specialist, BMC Software
Sheryl M. Larsen

Recent Popular Replays

Show OS Replay Link Theme Guest(s) Photos
#158 DB2
LUW
Watch
Replay
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!
Sanjay Trehan, Sr. DBA
Sanjay Trehan
#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
#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
#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
#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
#Z58 DB2
z/OS
Watch
Replay

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.
Cristian Molaro
IBM Champion and Gold Consultant
Cristian Molaro

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.