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!
#z133	DB2 z/OS & LUW	27 JAN 75 Mins	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
#252	DB2 LUW	10 FEB 75 Mins	SQL in Action: SQL Traps and Solutions In this session I will show some SQL traps and how to escape them.	Michael Tiefenbacher @globomike
#253	DB2 LUW	10 MAR 75 Mins	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
#254	DB2 LUW	14 APR 75 Mins	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

Recent Popular Replays

Show	OS	Replay Link	Theme	Guest(s)	Photos
#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
#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