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.


IDUG EMEA Lisbon Oct 1-5


Our
Favorite Blogs


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 #9 - Register Now!

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!
#Z82 Db2
z/OS
1 Dec
75 Mins
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.
The Db2 12 Catalog -- What happened since Db2 11
Steen Rasmussen
@DB2rasmussen
Steen Rasmussen
#199 Db2
LUW
8 Dec
75 Mins
Awaken your Data with RESTful Access to Db2!
Do you feel your data is locked in with no easy way of getting it out to your mobile clients? The new IBM Data Server Gateway for OData is a standards-based way for customers to leverage Db2 in modern Cloud and Mobile application development environments without requiring database drivers on the client. This session will describe what OData is, how it works with RESTful calls, and what you need to get it working in your environment.
Details and Registration
George Baklarz
@upintheairyyz
George Baklarz, Program Director, IBM
#200 Db2
LUW
15 Dec
75 Mins
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.
Details and Registration
Mark Gillis
@db2geek
Mark Gillis, Principal Consultant, Triton

Recent Popular Replays

Show OS Replay Link Theme Guest(s) Photos
#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
#196 Db2
LUW
Watch
Replay
SQL Infusion: A Transaction Log Expedition
Are your transaction logs too small? Too large? What about your log buffer size? Are Db2 transaction logs more like Oracle's UNDO or REDO logs? Is there human-readable data in them? What options do you have around transaction logs, and how do they impact performance? Join us to learn all about DB2 transaction logs from the mundane to the unusual, along with the SQL to investigate many different aspects of transaction logs!
Ember Crooks
@Ember_Crooks
Ember Crooks, Db2 Goddess
#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
#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
#Z78 DB2
z/OS
Watch
Replay
IBM DB2 Analytics Accelerator for z/OS Update
DB2 Analytics Accelerator for z/OS is a must have product for analytical use cases with DB2 for z/OS. Hear about latest trends and directions directly out of IBM's development lab in Boeblingen, Germany.
Peter Bendel
STSM, IBM Germany
@peterbendel_ibm
Peter Bendel
#Z77 DB2
z/OS
Watch
Replay
DB2 12 Update
DB2 12 is the latest release of DB2 for z/OS. DB2 12 adds new capabilities to take customers to the next level of mainframe leadership in the era of cloud and mobile. This session will provide an update on DB2 12, its new features and other important information.
Jeff Josten
Distinguished Engineer, IBM SVL
@jeff_josten
Jeff Josten
#Z76 DB2
z/OS
Watch
Replay
DB2 SQL Tuning Tips
This is the z/OS version of Tony's SQL tuning presentation. Most tips will also apply to DB2 LUW, so everyone should free to attend.
Tony Andrews
@TonyAndrews12
Tony Andrews
#Z75 DB2
z/OS
Watch
Replay
SQL Tuning in the Digital World
Mainframe Application Performance Management is more imperative today with processor speeds approaching the 7 GHZ limit. Throwing hardware at performance issues is not enough anymore. Various CICS, Batch, and DDF DB2 Version 11 tuning opportunities will be examined; analyzing SQL Text, DB2 Access Paths, and the DB2 Catalog Objects involved.
Sheryl Larsen
@smlsql
Sheryl Larsen

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.