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

SEASON #14! FOURTEEN 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!

Recent Popular Replays

Show	OS	Replay Link	Theme	Guest(s)	Photos
#262	DB2 LUW	Watch Replay	Build a Lightweight Monitor to Identify SQL Workload Tuning Potential This presentation offered in-depth monitoring insights using EXPLAIN	Kai Stroh
#261	DB2 LUW	Watch Replay	Amazon RDS for Db2 This presentation offered in-depth insights into Db2 RDS implementations and solutions to the most common challenges faced by customers	Karthik Gopalakrishnan and Vikram S Khatri from Amazon
#260	DB2 LUW	Watch Replay	Db2 Performance FAQ's This presentation offered valuable insights into common Db2 performance issues and provided effective solutions for each problem identified.	Raghavendra C, Senior Staff Software Engineer, IBM Software Labs, India
#259	DB2 LUW	Watch Replay	Db2 Warehouse (SaaS) Gen 3 This presentation provides information about Db2 11.5.9 Next Generation Data Warehouse, Watsonx.data and Data Lake.	Les King, Data Architect, IBM Toronto Lab
#258	DB2 LUW	Watch Replay	Db2 Database Upgrade in pureScale This presentation provides step by step instructions for a complex Db2 pureScale upgrade.	Mohan Saraswatipura, IBM Gold Consultant
#257	DB2 LUW	Watch Replay	All About IDUG This presentation provides an overview of IDUG 2024 technical tracks, recent IDUG website updates and logistics for 2024 NA conference. The 2024 IDUG conference offers a comprehensive and flexible experience, combining the benefits of in-person and virtual participation. With a diverse range of session tracks, interactive workshops, and extensive networking opportunities, the conference aims to cater to the varied interests and needs of the Db2 community. The logistics are designed to ensure a smooth and enjoyable experience for all attendees, with a focus on accessibility, safety, and technical support.	Chris Muncan, IDUG CPC Chair 2024
#256	DB2 LUW	Watch Replay	Machine Learning Optimizer Feature in Db2 This presentation looks at the Machine Learning Optimizer in Db2. In particular, the first use is for better cardinality estimation (estimating the number of rows within the optimizer plan). We look at capabilities in the Tech Preview that has been available for some time now. We will also look at the what will be done towards getting it out for production use. Some usage scenarios comparing the new functionality with the traditional optimizer functionality will be presented. Click register for details...	Calisto Zuzarte, IBM Toronto Lab
#255	DB2 LUW	Watch Replay	Db2 Always-On Architecture The IT landscape has changed in the past 10+ years with IT systems and customers being global rather local. This has created a number of problems as peak times can now come in waves from around the globe and batch windows have shortened. This volume increase has driven an explosion in data volumes and server horsepower for even simple applications. Leading IT organizations need to handle this change and react as quickly as the business requires.	Dale McInnis @dalemcinnis
#254	DB2 LUW	Watch Replay	Db2 UDFs : Beyond the Basics Db2 User Defined Functions (UDFs) are a largely ignored tool in the developer's armoury, providing exciting and in some cases unique capabilities. This presentation will go beyond creating simple UDFs to look at more complex use cases and capabilities. A particular focus will be on table UDFs and why they sometimes are better than stored procedures.	Philip Nelson
#253	DB2 LUW	Watch Replay	Explain Essentials for Query Optimization One of the most important factors in query performance is the access plan chosen by the Db2 query optimizer. This presentation will cover the most important techniques for collecting and using explain information so that you can quickly and effectively understand your access plans to achieve and maintain the best possible query performance.	John Hornibrook, STSM, IBM Toronto Lab @rld_box
#252	DB2 LUW	Watch Replay	SQL in Action: SQL Traps and Solutions In this session I will show some SQL traps and how to escape them.	Michael Tiefenbacher @globomike
#251	DB2 LUW	Watch Replay	What's New in Db2 11.5.8 The Show's opening monologue will start with an description of the v11.5.8 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.8 roadmap.	Keri Romanufa @RomanufaKeri
#250	Db2 LUW	Watch Replay	A Db2 Security Primer Security demands continue to grow and you need to be aware of all the tools and capabilities that Db2 provides you in this area. This session provides a review of the Db2 security landscape for those new to Db2 and to grizzled veterans. We will look at the various features and functions available across the four primary security domains: authentication ; authorization ; auditing ; and encryption. Along the way ; we will discover a couple of potential "gotchas" and some lesser known aspects of Db2 security.	Greg Stager @GregStager
#249	DB2 LUW	Watch Replay	Db2 Warehouse Reference Architectures for X86 & Power We are announcing two new Reference Architectures which are designed to optimize Db2 for high end - petabyte scale - warehouse/OLAP workloads. These reference architectures are called "Db2 Warehouse Reference Architecture for X86" and "Db2 Warehouse Reference Architecture for Power" and are designed to be on-premises follow-ons to our Db2-based analytic appliances (PDOA and IIAS). In this session we will review the next generation of Db2-based platforms for warehouse/analytic workloads and drill down into the architecture and other details of these two new offerings..	Les King @LesKing00
#248	DB2 LUW	Watch Replay	Db2 pureScale on AWS - The New Experience With the availability of Db2 pureScale on AWS as a self-managed service, not only does it continue to provide the same value propositions as in on-premise deployments, it opens up many other opportunities. This session introduces the new revolutionary journey, unveils the added benefits, covers the new use cases that break the traditional "time-barrier" in on-premises deployments and drastically reduces the total cost of ownership. The session wraps up with a sneak peek at the next phase of enhancement in this AWS journey as well as the path on other public clouds.	Alan Lee @ykalee1
#247	DB2 LUW	Watch Replay	Db2 Click-2-Containerize Deploying an existing Db2 to OpenShift or Cloud Pak for Data usually involves some form of export and import and a lot of work! Rather than you having to do all of the hard work, we introduced the Click to Containerize tool to help you move your on premise Db2 Linux database directly to the Cloud - with no exporting of data! A lot has changed in the last year and Click to Containerize Version 2 is now in technical preview! This session will take you through the new enhancements to the IBM Db2 C2C program and how it can help modernize your Db2 databases quickly and efficiently!	George Baklarz @upintheairyyz
#z138	DB2 z/OS	Watch Replay	Db2 User Experience Transformation Strategy This is an of Db2z app dev capabilities. Click register for details...	Sowmya Kameswaran, IBM SVL
#Z137	DB2 z/OS	Watch Replay	Db2 Java Performance Best Practices Version X Learn how to achieve blazing-fast Db2 and Java performance with these proven best practices. In this presentation, we'll cover essential Db2 coding techniques, Java class frameworks, and debugging/tracing practices to identify and resolve performance bottlenecks in record time. Whether you need to improve Db2 access, optimize Java runtimes, minimize CPU usage, or process billions of rows, this presentation's real world expert advice will help you achieve top-tier performance. Click register for details...	Dave Beulke @DBeulke
#z136	DB2 z/OS	Watch Replay	Examples of Db2 Mistakes for others to Avoid It may be one summer, collection, package or one query brings your CPU to its knees. These are the war stories that I will cover so you can learn from others’ mistakes. Examples of seriously delayed filtering, not following performance rules, checking to see if Db2 is up, and many other tricky but painful techniques will be divulged.	Sheryl Larsen @smlsql
#Z135	Db2 z/OS	Watch Replay	Use Profiles to Monitor and Control Db2 Application Context With increased popularity of distributed applications, related Db2 system and application definitions were defined in distributed application servers. Sub-optimal definitions could impact on overall Db2 health. Db2 z/OS provides capabilities to create profiles to monitor and control various aspects of a Db2 specific system and application contexts in Db2 profile tables. Db2 13 extends the profile tables to new attributes for local and remote applications. Maryela will review existing profile capabilities and introduce Db2 13 extensions as well as discuss use case examples. Click register for details...	Maryela Weihrauch
#z134	DB2 z/OS	Watch Replay	An Audit a day keeps the lawyers at bay! Stricter government regulations for Data Protection, Monitoring and Auditing require even more vigilance for the CSO, not only to control prohibited access, but also database activities of authorized entities to do their jobs. Beside the organizational issues, cost based challenges should be in focus: Is this 360 degree solution achieved CPU friendly (e.g. z/OS OPx buffer technology)? Are reports and audit preparation based on IBM GUI standards (Eclipse, Zowe)? Is used technology IBM compliant or Vendor specific (Code or appliances)? Click register for details...	Roy Boxwell, Software Engineering @rld_box
#z133	DB2 z/OS	Watch Replay	A Row's Life Rows in a DB2 z/OS database get mauled and moved and wholly and partially duplicated. There are different ways to find them and different surroundings. And most DBAs find they need to understand these transformations thoroughly to manage performance and recovery and even security. In this presentation, we take a light-hearted view of one row's life to emphasize some of the internals of DB2 on the z/OS platform.	Marcus Davage, BMC @spufidoo
#z132	DB2 z/OS & LUW	Watch Replay	Temporary Tables in DB2 SQL. DGTT and CGTT and more. How to use effectively. Lessons learned! The SQL concept of 'temporary tables' allows for creation of powerful SQL. Understanding the different types of temporary tables will allow the end-user the option to create useful SQL that may be relatively simpler to understand and allows great flexibility. The presentation will attempt to clearly drive home the difference between DGTT and CGTT. I will share the experience of how a simple DGTT was used in a new high-volume transaction and cost was relatively high. Switching to CGTT fantastically reduced cost!	Brian Laube, Manulife
#z131	DB2 z/OS	Watch Replay	Transforming Db2 for z/OS Application Development Experience Db2 for z/OS supports mission-critical applications that power the businesses of many Fortune 100 companies. Our customers rely daily on transactional and analytical applications to gain useful insights from data residing on Db2 for z/OS. This makes application development and debugging essential to our customers' daily operations. Join us as we discuss and demonstrate how the application development landscape has changed and how were bringing Db2 to your favorite code editors.	Katherine Soohoo, IBM
#z130	DB2 z/OS	Watch Replay	Db2 13 for z/OS Technical Overview The purpose of this presentation is to introduce the new migration process for the new Db2 13 for z/OS release. The Db2 13 release migration process is significantly different from any previous Db2 release migration. The changes are, in fact, revolutionary. We will detail the Db2 12 to Db2 13 migration process, the Db2 13 Installation process, and go into details regarding application compatibility and the Continuous Delivery process as it relates to Db2 13. Each release brings new migration processes and challenges we will detail the nuts and bolts of the significant Db2 13 process and procedure changes.	Robert Catterall, IBM
#z129	DB2 z/OS	Watch Replay	UTS - Past, Present & Future The UTS has been with us since DB2 V9 and now in Db2 12 it got an upgrade with the UTS PBR RPN type. In this presentation I wish to show you how to use which variant, and when, for the best performance and utility balance. I will also briefly review the history of UTS and its probable future development. Click register for details...	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

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.5 :: 11.1 PDFs :: 10.5

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