Show | OS | Date & Duration | Theme | Guest(s)
@Twitter_ID |
Photos-
Click to see profiles! |
#Z103 | DB2 z/OS |
75 Mins |
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. ![]() |
@craigmullins |
![]() |
Show | OS | Replay Link | Theme | Guest(s) | Photos |
#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. This presentation will introduce you to some of the concepts and principles behind it all. 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. |
@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. Find out how you make SQL prototyping and scripting easier through the use of Jupyter notebooks! Click below to register. |
@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? Join Ember to see what she looks at when doing a health check and why. Click below to register. |
@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. Click below to register. |
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 |
![]() |
#214 | Db2
Family |
Watch
Replay |
All About IDUG June 2-6 Charlotte NC
Special guests Mike Inman and Dustin Ratliff from the IDUG Conference Planning Committee will give us the Inside Scoop on the upcoming IDUG conference including Tech Sessions, Ed Seminars, SIGs, Networking Events, and more! If you're attending IDUG or thinking about it, don't miss this show! |
IDUG CPC
@IDUGDb2 |
![]() |
#213 | Db2
LUW |
Watch
Replay |
Db2 LUW Native Encryption
Our special guest, Paul Bird, STSM IBM Canada, offers a great presentation to help you learn about Db2 Native Encryption and how to protect your databases from evil-doers! Paul's talk covers preparation, implementation, and operational considerations! |
Paul Bird
@IBM_Paul_Bird |
![]() |
#212 | Db2
LUW |
Watch
Replay |
Db2 LUW SQL Tuning: detect, fix, and prevent problems
Our special guest, Klaas Brant, IBM Db2 GOLD Consultant, returns to share with us his SQL tuning methods! How to find bad SQL? Fix it? Prevent it? Join us! |
Klaas Brant
@klaas_brant |
![]() |
#211 | Db2
LUW |
Watch
Replay |
Db2 LUW Favorite Problem Determination Tricks
Pavel Sustr, Sr. Manager at IBM Canada Lab, will share with us his favorite problem determination methods and tricks, including insider secrets, advanced diagnostics, shortcuts, and interpreting Db2 diagnostic data. |
Pavel Sustr
@pavel_sustr |
![]() |
#210 | Db2
LUW |
Watch
Replay |
EGGNOG and Db2 LUW Tuning! Jolly Holidays!
Special Guest Martin Hubel, IBM Db2 GOLD Consultant, IBM Champion, and famous Db2 Performance Tuning Expert, presents his exceptional IDUG presentation on Db2 Indexes and Prefetching. You will learn about bufferpool tuning too, and more! Click register for details... |
Martin Hubel
@mhubel |
![]() |
#209 | Db2
LUW |
Watch
Replay |
The PERFECT Db2 LUW Server! PLUS Db2 V11.1.4.4 What's New Our special guest, Klaas Brant, IBM Db2 GOLD Consultant, presents how to achieve an optimally configured Db2 server including memory, storage, instances, STMM, monitoring, and more! Breaking Non-Fake News: Kelly Rodger from the IBM Canada Lab will also share with us What's New in Db2 V11.1.4.4! |
Klaas Brant
@klaas_brant |
![]() |
#208 | Db2
LUW |
Watch
Replay |
10 Minute Triage: Troubleshooting Db2 LUW Production Issues
Our special guest, Michael Krafick, Lead Db2 Database Engineer and IBM Champion, will share with us his thoughts and methods on how to quickly triage production Db2 problems. |
Michael Krafick
@MKrafick |
![]() |
#207 | Db2
LUW |
Watch
Replay |
Db2 News from IBM Canada Lab
We're kicking off Season #10 of The Db2Night Show with the latest news from the IBM Lab. Be sure to join us for updates on Db2 announcements! |
Les King
@LesKing00 |
![]() |
#204 | Db2
LUW |
Watch
Replay |
Db2 LUW on AWS Cloud - SAP Experiences
Arwel Owen, known as @SAP_AWS on Twitter, has achieved some pretty spectacular performance, compression, and cost savings results by moving his company's SAP Db2 environment to the AWS cloud. Join us and learn from his experiences. |
Arwel Owen
@sap_aws |
![]() |
#206 | Db2
LUW |
Watch
Replay |
A Crash Course on Db2 pureScale and Advantages
IBM Champions, and Db2 Certification Book Authors, Mohan Saraswatipura and Kent Collins return as our special guests to give us a crash course on Db2 pureScale and its advantages. |
Mohan Saraswatipura
@mohankumarsp Kent Collins @rcollins963 |
![]() ![]() |
#205 | Db2
LUW |
Watch
Replay |
Deep Dive into Db2 LUW Locks, Logs, and pureScale
IBM Champions, and Db2 Certification Book Authors, Mohan Saraswatipura and Kent Collins return as our special guests to give us a deep dive on Db2 V11 locks, logs, and pureScale. |
Mohan Saraswatipura
@mohankumarsp Kent Collins @rcollins963 |
![]() ![]() |
#202 | Db2
LUW |
Watch
Replay |
Using Jupyter Notebook for Db2 Administration
Our guest, Ember Crooks, had standing room only for this presentation at IDUG EMEA Lisbon 2017! Join us and learn how you can use Jupyter Notebooks to help you with DBA tasks and reporting! Make sure you attend to see the LIVE demonstration! |
Ember Crooks
@ember_crooks |
![]() |
#201 | Db2
LUW |
Watch
Replay |
Favorite Tuning Tips and Tricks for Db2 LUW
Joe Geller won Best User Speaker at IDUG EMEA Lisbon 2017 with this fantastic presentation about his favorite tips and tricks for tuning Db2 LUW. There's 100% chance you're going to learn something helpful! |
Joe Geller |
![]() |
#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 |
![]() |
#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 |
![]() ![]() |
#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 |
![]() |
#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 |
![]() |
#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 |
![]() |
#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. |
@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. |
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. |
@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 |
![]() |
#Z98 | Db2
z/OS |
Watch Replay |
Optimizing Data Transformation with Db2 for z/OS and Db2 Analytics Accelerator
The companies that derive more information from the available data will be ahead of their competitors. The Extract-Transform-Load ETL process is executed to make that data consumable for analytical processing. Maryela discusses the challenges of typical ETL processing today and walks through Db2 and IDAA functionality to optimize data transformation and introduces the concept of real-time data transformation with SQL. She will also give a positioning between real-time transformation with SQL and Data Virtualization. Click register for details... |
Maryela Weihrauch |
![]() |
#Z97 | Db2
z/OS |
Watch Replay |
Why does the Db2 for z/OS Optimizer need a Data Scientist?
To sum up the past 30 years of Db2 access path optimization: good for many, great for few. Come find out what IBM is doing about this and how the solution will fit in your DevOps environment. Click register for details... |
Sheryl Larsen |
![]() |
#Z96 | Db2
z/OS |
Watch Replay |
Db2 for z/OS Latest News and Future Directions
Db2 for z/OS is investing for leadership in the cloud, mobile, and analytics era, while extending our mainframe heritage of 24x7 availability, security, scalability, and performance, and keeping Db2 as the industry leader for mission-critical applications. This presentation reviews the latest Db2 for z/OS enhancements, and takes a look at Db2's strategic roadmap and what the Db2 Development lab is planning in the coming months. Click register for details... |
Jeff Josten |
![]() |
#Z95 | Db2
z/OS |
Watch Replay |
Db2 Batch System Design for High Performance
Mission critical high performing Db2 for z/OS batch systems bring challenges to a whole new level. Learn how to turn an I/O bound Db2 for z/OS application into one that is CPU bound and why that is a good thing. |
Neal Lozins |
![]() |
#Z94 | Db2
z/OS |
Watch Replay |
Data Masking for Db2 on z/OS
Kai will show how to design data masking algorithms that you can use in real-world scenarios. Key aspects are versatility, performance, repeatability, and generating usable test data that mimics real production data. Click register for details... |
Kai Stroh |
![]() |
#Z93 | Db2
z/OS |
Watch Replay |
Best Design and Performance Practices for Analytics
Designing application analytical systems requires comprehensive data management and usage analysis to design and build the best performance analytical application that produces meaningful insights. This presentation will discuss the application design patterns that provide sustainable performance for fast analytic answers. |
Dave Beulke |
![]() |
#Z92 | Db2
z/OS |
Watch Replay |
Distributed access to Db2 for z/OS: top things to know
With today's complex n-tier architectures and heterogeneous applications and platforms, optimization and availability can be a challenge. Fortunately, the ways in which DB2 communicates with its distributed clients is evolving and presents exciting new possibilities and opportunities. Cristian will discuss the top things that you must know about distributed access to Db2. |
Cristian Molaro
@cristianmolaro |
![]() |
#Z91 | Db2
z/OS |
Watch
Replay |
Machine Learning and Db2 for z/OS
Beginning with enhancing the access path decisions made by the optimizer tailored to your workloads, Db2 for z/OS is embarking on a journey to improve performance and manageability by exploiting machine learning. This session will outline where Db2 is in this journey, and hint at the roadmap for a self-tuning Db2 |
Terry Purcell |
![]() |
#Z90 | Db2
z/OS |
Watch
Replay |
Total Recall: Exploiting In-Memory Features in Db2 12 for z/OS
IBM has steadily expanded the in-memory capabilities of DB2 in recent releases, to the extent that Db2 12 for z/OS is now officially recognised by Gartner as a bona fide "In Memory" Database. This presentation provides an overview of the ways in which DB2 is evolving to exploit more real memory, reduce CPU and deliver improved price/performance. |
Julian Stuhler
@jstuhler |
![]() |
#z89 | Db2
z/OS |
Watch
Replay |
Are you just gonna play in the pool...or own it...Bufferpool that is
There have been many changes to buffer pool behavior, performance, and management across recent DB2 releases. This presentation will walk through several major enhancements as well as if they are right for you, and how to measure them. Understanding the impact of your tuning activities is just as important as undertaking them in the first place. |
Adrian Burke
@agb_DB2z |
![]() |
#Z88 | Db2
z/OS and LUW |
Watch
Replay |
DB2 Security Best Practices Volume II
Implementing the best security techniques and strongest configuration is mandatory these days for safe guarding your data. This presentation discusses the latest DB2 security methods, procedures and techniques for fortifying DB2 systems, databases and applications. This presentation details DB2 z/OS and DB2 LUW security strategies such as the impacts of encryption, database design security techniques and how best implement a multi-layered DB2 security data perimeter. |
Dave Beulke |
![]() |
#Z87 | DB2
z/OS |
Watch
Replay |
Db2 RESTful Service Support and z/OS Connect
The Application Programming Interface (or short API) Economy has changed how developers build application and how organization deploy software as a service. Mobile devices have accelerated the shift of providing services via API. Maryela will show how SQL and stored procedures in Db2 on z/OS can be made available in the era of application assembly and integrate with z/OS Connect EE. |
Maryela Weihrauch
IBM Distinguished Engineer @zAnalyticsGURU |
![]() |
#Z86 | DB2
z/OS |
Watch
Replay |
Pre-IDUG Db2 for z/OS Update
This presentation gives a summary of some of the latest news and deliveries from Db2 for z/OS development. Kind of a preview of what will be covered at the IDUG North American conference at the end of April, if you will. | Jeff Josten |
![]() |
#Z85 | DB2
z/OS |
Watch
Replay |
Db2 12 Continuous Delivery - New challenges for deployment
Fundamental changes in the Db2 z world often lead to concerns. Let's face it - some changes force us to change! This will have a tremendous impact on migration strategies, because we have to find a reliable way to test these code deliveries in a fraction of the time we used to have. This presentation will describe the difference between Code, Catalog, Function and Application Levels, how you can control them and how you can fallback in case of anomalies. |
Roy Boxwell, Software Engineering |
![]() |
#z84 | DB2
z/OS |
Watch
Replay |
Revival of the SQL Tuner
The pool of DBAs with SME knowledge of SQL tuning has shrunk dramatically while the number of SQL statements needing attention has grown and will continue to grow. DB2 performance tooling can help identify what needs to be tuned. But what do you do then? This presentation will help fill the skills gap by reviving the role of an SQL Tuner. |
Sheryl Larsen
@smlsql |
![]() |
#Z83 | Db2
z/OS |
Watch
Replay |
Copy Smarter - Unload/Load, DSN1COPY and beyond
When you get tasked with setting up a refresh process for thousands of DB2 z/OS tables you probably have a few thoughts running through your head. This presentation discusses advantages and disadvantages of different utilities that copy DB2 data, but the main focus is automating all the side tasks that DBAs usually need to do in addition to copying the data itself. |
Kai Stroh |
![]() |
#Z82 | Db2
z/OS |
Watch
Replay |
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. |
Steen Rasmussen
@DB2rasmussen |
![]() |
Please inquire about sponsorship opportunities. Email "db2nightshow" "at" "dbisoftware.com". |
![]() www.IDUG.org |
![]() www.DBISoftware.com |
![]() www.responsivesystems.com |
![]() www.kbce.com |
![]() www.Triton.co.uk |