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!
We won't mind if you share the registration links!

SEASON #11! ELEVEN YEARS of FREE Db2 Education!

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!
#Z106	Db2 Family	17 Apr 75 Mins	ALL ABOUT IDUG! It's our annual show wherein we invite the IDUG volunteer leadership to share insider information about upcoming IDUG events and activities. If you want to learn more about the International Db2 Users Group, don't miss this show for the latest information!	IDUG Volunteers @IDUGDB2	IDUG
#225	DB2 LUW	1 MAY 75 Mins	The new face of Db2: Cloud-Native and AI ready Db2 has come a long way since being one of the first Relational Database Management Systems. Explore the containerization of Db2 and optimization on RedHat OpenShift. New exciting features like Db2 Graph , REST APIs and enhanced ML capabilities with PythonUDF and in-DB Machine Learning. Click below to register.	Piotr Mierzejewski @piotrm42
#Z107	Db2 z/OS	15 MAY 75 Mins	Best practices for developing high performing Java applications for Db2 Java workloads have proliferated on Db2. Due to gaps in understanding true database behavior, application developers find it challenging to code well behaved applications that are high performance with large data volumes and also have continuous availability. Maryela will present best practices in all key areas of developing Java application against Db2 - connection management, resultset handling, load balancing settings, failover techniques, optimization of expensive resources such as Java objects and much more - to bridge the gap between applications and Db2. Click register for details...	Maryela Weihrauch

Recent Popular Replays

Show	OS	Replay Link	Theme	Guest(s)	Photos
#224	DB2 LUW	Watch Replay	Latest From the Lab: What's next for Db2 v11.5 Have you been checking out the Db2 Aha! Roadmap? (@ http://ibm.biz/Data-and-AI-Roadmaps ) Are you excited to see some of the new capabilities slated for 1H this year? The Show's opening monologue will start with an description of the v11.5 continuous delivery model, multi-platform & container-only installs and the new mod/fix pack numbering scheme. After that we will have a deep dive into the Top 10 (or so) key enhancements on the v11.5 roadmap.	Keri Romanufa @RomanufaKeri
#223	DB2 LUW	Watch Replay	New developments in Db2 pureScale for v11.5 and beyond At the heart of IBM Hybrid Database Management Portfolio, Db2 pureScale plays an integral role as a robust, highly-scalable and highly-available solution deployed across a diversified set of industries. This session provides a deep dive into each of these areas and includes a sneak peak at what is coming down the pipe later in the year in the Db2 pureScale landscape!	Toby Haynes @TobyHaynes
#222	DB2 LUW	Watch Replay	Db2 Resiliency Models - what real customers are doing In this presentation we will detail several DB2 resiliency patterns that customers have deployed. We will review the customer's requirements, discuss alternatives and detail the final architectural chosen outlining both the pros and cons. Monitoring is key to success in building a resilient environment this we will detail what needs to be monitored. Click below to register.	Dale McInnis @dalemcinnis
#221	DB2 LUW	Watch Replay	Db2 Advanced Log Space Management - Trying to Make Life Simple With the introduction of Db2 11.5 the journey has begun in making log space management more autonomic. We will do a deep dive into the technology and transformation behind making log space management more hands off, which in the end will make life simple for you and your organization.	Michael Roecken @roecken
#220	DB2 LUW	Watch Replay	Db2 and Jupyter Notebooks - Up and Running in no time! This session will explore the use of Jupyter notebooks and how to access Db2 from this environment. We will explore the tools required to make this work, how to get the Db2 extensions installed, and finally explore what type of SQL you can run from within a notebook. Make SQL prototyping and scripting easier through the use of Jupyter notebooks!	George Baklarz @upintheairyyz
#219	DB2 LUW	Watch Replay	Health Checks - How to Evaluate the Health of a Db2 Database Every database can be improved upon. Sometimes a second set of eyes finds problems that we don't see when we work with a database every day. What should you check when evaluating the health of your database or a co-worker's database?	Ember Crooks @ember_crooks
#218	DB2 LUW	Watch Replay	Db2 Automatic Statistics Deep Dive Current and accurate catalog statistics are the lifeblood of the query optimizer Db2 has had automatics statistics support since version 8.2 and real-time statistics were introduced in version 9.5. Attend this session to gain a deeper understanding of how they work and why you can trust them to simplify your DB administration and improve overall query performance.	John Hornibrook, STSM, IBM Toronto Lab @rld_box
#217	Db2 LUW	Watch Replay	Season #11 Premiere: Light at the End of the Encrypted Tunnel Greg Stager of the IBM Toronto Lab will cover the fundamental principals of Transport Layer Security (TLS aka SSL) encryption and working with certificates. You will learn how to configure all of the locations within Db2 that use TLS as well as the operational details for managing certificates.	Greg Stager @GregStager
#216	Db2 LUW	Watch Replay	Season #10 GRAND FINALE: Db2 LUW Problem Determination CLASS Pavel Sustr, Sr. Manager at IBM Canada Lab, will share with us his popular troubleshooting seminar, updated with the newest Db2 11.1 problem determination techniques and LIVE DEMOS! Learn how to identify and resolve database hangs, crashes, performance problems, and data corruption issues, and more!	Pavel Sustr @pavel_sustr
#215	Db2 LUW	Watch Replay	BREAKING NEWS from the IBM Toronto Lab Our special guest, Kelly Rodger, Senior Development Manager, IBM Canada, provided us with breaking news from IBM regarding Db2 LUW V11.5!	Kelly Rodger @kdrodger
#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
#Z105	DB2 z/OS	Watch Replay	DevOps for DB2 DBAs How is the role of the DBA evolving? What new tools/techniques/buzzwords do I need to understand? What role does cloud computing play in all of this? This session will answer these questions as more, as it outlines the major considerations and benefits for integrating DB2 for z/OS into a modern enterprise DevOps environment.	Julian Stuhler @jstuhler
#Z104	DB2 z/OS	Watch Replay	Db2 for z/OS Utilities Hints and Tips Getting the most out of your utilities can make a huge difference to performance, resource consumption and data availability. Given all the options and system configurations, how can you ensure that you are taking full advantage of all the utilities can do? This session will tell you how.	Haakon Roberts @db2tools
#Z103	DB2 z/OS	Watch Replay	Coding Db2 for Application Performance - By the Book! Writing Db2 programs that perform well can be a difficult task, especially when you are under pressure to deliver code quickly. This presentation will include coding techniques, SQL issues, indexing, and is based on Craig's latest book, A Guide to Db2 Application Performance for Developers. Click below to register.	Craig Mullins @craigmullins
#Z102	DB2 z/OS	Watch Replay	Db2 z/OS V9 - V12 Best Developer Features As with every new version of Db2 since V9, there have been many new features specific to developers. If you are a developer, designer, DBA, or performance tuning specialist wanting to learn more about many of these new features, then this webinar is especially for you.	Tony Andrews @TonyAndrews12
#Z101	DB2 z/OS	Watch Replay	Distributed best practices for Db2 today...and tomorrow With the proliferation of distributed applications, and now the appeal of Mobile workloads, DB2 continues to provide functionality in this arena. DB2 can now accept and return a JSON payload in response to API calls. Customers will want to understand how this technology can affect their current environment, and what steps they can take to ensure continued levels of service.	Adrian Burke IBM DB2 SWAT team @agb_DB2z
#Z100	DB2 z/OS	Watch Replay	Show and tell - Agile development practices with Db2 for z/OS Adopting modern application development methodologies using modern development tools enables the next generation of application developers to create and enhance applications using Db2 for z/OS. This demonstration uses Java and native stored procedures with dependencies on db2 tables. Click below to register.	Patrick Bossman @Bossman2day
#Z99	DB2 z/OS	Watch Replay	Db2 for z/OS Know your Limits! Roy will show and explain the current number of limits within Db2 on z/OS starting with the basics, and then moving on to Linear Dataset limits. We then will have a quick look at how the COPYPOOL is looking before diving off to the world of PBGs where you must be aware of MAXPARTIONS among other things. Click below to register.	Roy Boxwell, Software Engineering @rld_box

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".	www.IDUG.org	www.DBISoftware.com
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:
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. 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!

• Learn and TRY the newest DB2 V10 & V10.5 Features with "DB2 Demo"
• DB2 Compression Estimator - Updated for DB2 V10.5 BLU