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!
#248	DB2 LUW	7 Oct 75 Mins	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. Click below to register.	Alan Lee @ykalee1
#z130	DB2 z/OS	14 OCT 75 Mins	Db2 13 for z/OS Technical Overview 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...	Robert Catterall, IBM

Recent Popular Replays

Show	OS	Replay Link	Theme	Guest(s)	Photos
#247	DB2 LUW	9 Sep 75 Mins	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! Click below to register.	George Baklarz @upintheairyyz
#246	DB2 LUW	Watch Replay	Db2 Advanced Log Space Management - Unleashed Trying to figure out the ins and outs of Db2 Log Space Management? Db2 11.5 GA introduced Advanced Log Space Management as a technical preview. Now fully supported, 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
#245	DB2 LUW	Watch Replay	Db2U Current Capabilities and Future Direction Db2 on CPD/OpenShift/k8s (a.k.a. Db2U) current capabilities and future direction will be focused around overall Db2U current and next-gen architecture, cloud native features, deployment patterns and supported platforms.	Aruna De Silva @aruna_desilva Janpreet Singh Chandhok @chandhok97
#244	DB2 LUW	Watch Replay	Db2 AIX to X86 Linux Migration Db2 customers currently running AIX have a challenge when then plan to migrate to a cloud based environment. All major cloud vendors provide X86 Linux support whereas AIX support is only available on IBM Cloud through the Power Server Virtual Server offering. As such, the majority of customers planning on migrating to an cloud environment will be required to migrate the database to an X86 Linux deployment. This presentation will examine several aspects of such a migration, e.g. how it affects HA, how to physically move the data as well as what would be the required amount to resources to run the same workload in an X86 environment.	Dale McInnis @dalemcinnis
#243	DB2 LUW	Watch Replay	Techniques for Optimal DB Performance Part 2 Jim continues his excellent presentation where he covers many performance improvement considerations and techniques that can be applied to relational databases; many of the examples come from Db2 LUW and Db2 on zOS. We'll see the impact of these types of changes, and look at several recent features not commonly used.	Jim Bean, Cigna
#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
#z128	DB2 z/OS	Watch Replay	Achieving high availability, efficiency and application stability with Db2 13 for z/OS Db2 13 reduces application outages to accommodate application workload growth to simplify processes for DBAs. This session gives you an overview of following key features: - Exploits partition-by-range (PBR) to Partition-by-growth(PBG) table spaces conversion with minimal impact to applications - Performance improvement for PBG table space - Provides Application Timeout and Deadlock control - Turns on/off special registers and global variables without updating applications	Frances Villafuerte
#z127	DB2 z/OS	Watch Replay	Db2 V13 Migration Planning Join us to hear about planning and considerations for migrating to the recently announced Db2 V13!	Anthony Ciabattoni @aciabattoni John Lyle
#z126	DB2 z/OS	Watch Replay	Tuning SQL that Still Works V2 Gone are the days of manually tuning queries. NOT SO FAST! Sheryl will cover all kinds of techniques that are still best practice rules to follow. Perfect for newbies to Db2 for z/OS due to all the pictures used to demonstrate techniques, as well as oldies, who need a refresher.	Sheryl Larsen @smlsql
#Z125	DB2 z/OS	Watch Replay	Things About Db2 I wish I'd Remember When... With all the changes and enhancements made to Db2 over the years, it is getting more and more challenging to know the exact command, syntax or option to use for any given feature/function. Continuous Delivery has not made it any easier. This presentation will cover some of the more overlooked or forgotten options, commands, syntax that could prove to be invaluable in managing your Db2 environment.	Michael Cotignola
#Z124	DB2 z/OS	Watch Replay	Db2 for z/OS Utilities Update The Db2 for z/OS Utilities team continues to deliver significant new performance, availability and usability enhancements through the V12 maintenance stream. This session will cover recent deliverables, explain what the improvements are, why they matter and how to take advantage of them.	Haakon Roberts @db2tools
#Z123	DB2 z/OS	Watch Replay	Latest news in Db2 for z/OS Data Studio and DSM strategic replacement Are you wondering what's going on with Data Studio, and what the future will bring for developers of Db2 for z/OS applications? Patrick will demonstrate SQL function capabilities, creation of native rest services, the IBM Z Open Editor for JCL, COBOL, PL1, and using the Zowe extension to connect to z/OS and explore and edit files on z/OS. Get a taste of the art of the possible, where we're going, and offer suggestions for what you'd really like to see.	Patrik Bossman @Bossman2day
#z122	DB2 z/OS	Watch Replay	Data Gate: Current and Consistent Db2 for z/OS Data on any Cloud Data Gate is the most simple, fast and and resource efficient way to provide a read-only copy of your Z data on Cloud for your modern applications that operate on Z data. This presentation includes a demo.	Sowmya Kameswaran, IBM SVL
#z121	DB2 z/OS	Watch Replay	Esoteric Functions in Db2 In this presentation Roy will delve into FTB/FIT, Spatial Indexes, Regular Expressions, Clone tables and Scrollable cursors. All of these could be called esoteric as most shops do not use or even know of their existence! I would hope that after this presentation the viewers will have learned something new about Db2 and perhaps could use one or more of these esoteric functions so that it becomes "well known" function and not a hidden gem!	Roy Boxwell, Software Engineering @rld_box
#z120	DB2 z/OS	Watch Replay	Building Blocks of Db2 Have you ever wondered what those cryptic values for the columns in PLAN_TABLE mean? This beginner level presentation answers your questions. The RDS and Data Manager use a relatively small number of types of simple requests which are set oriented, like retrieving all rows from a table through a matching index scan, sorting a workfile, etc. This presentation delves into these in depth; we try to pretend we are the DB2 Optimizer and select the best block for the job!	Jim Dee @dee_jim
#Z119	DB2 z/OS & LUW	Watch Replay	Secure by design: Best practices to design security into your database and applications This presentation details Db2 z/OS and LUW database design security techniques, steganography procedures and application audit practices. You will learn about systems/application security vulnerabilities, security design techniques for your data tables and recommended audit mitigation strategies/checklists/SQL Scripts. These system and application security best practices will help you secure your database designs and improve your application security profile.	Dave Beulke @DBeulke
#Z118	DB2 z/OS	Watch Replay	Favorite Db2 z/OS Performance and Optimization Features V9-V12 Want to know more about the optimization improvements since V9? There were many and this presentation provides some of best and favorites that all developers should know about. As with all Db2 z/OS releases, Db2 delivers a large number of new features, functions, enhancements, and optimization improvements with many specific to the developers. Come away with a better understanding of the Db2 z/OS optimizer.	Tony Andrews @TonyAndrews12
#Z117	Db2 z/OS	Watch Replay	A very untraditional approach implementing schema changes! The most commonly used methodology implementing Db2 schema changes is to compare new/old structures and create the worklist to execute the changes - being online or deferred or the DBA nightmare of UDCL. This approach can result in some surprises like the requirement to fall back or access path changes due to altered indexes/tables/columns/programs. This presentation will illustrate how a complete different approach can be implemented mitigating most of the risks/challenges - done by real customers.	Steen Rasmussen @DB2rasmussen
#Z116	Db2 z/OS	Watch Replay	Integrate Db2 for z/OS database changes in your enterprise DevOps pipeline Typically, the first focus for a Development team is implementing a DevOps pipeline for application changes, whereas, in practice, many application changes also require Db2 z/OS database changes. That introduces a dependency on DBAs to deploy code with multiple hand-offs between DBA, application developer, and Data Modeler, which in turn creates unnecessary bottlenecks and deployment delays. Click register for details...	Maryela Weihrauch
#Z115	Db2 z/OS	Watch Replay	Db2 Java Performance Best Practices This presentation details Db2 and Java performance best practices. Db2 coding best practices, java class frameworks and debugging/tracing practices will be presented that can immediately identify your performance bottlenecks. After this discussion you will be able to dramatically improve your Db2 access, Java runtimes, minimize CPU and quickly access billions of rows with the best performance possible. Click register for details...	Dave Beulke @DBeulke
#z114	DB2 z/OS	Watch Replay	Tuning SQL that Still Works! Gone are the days of manually tuning queries. NOT SO FAST! Sheryl will cover all kinds of techniques that are still best practice rules to follow. Perfect for newbies to Db2 for z/OS due to all the pictures used to demonstrate techniques, as well as oldies, who need a refresher.	Sheryl Larsen @smlsql
#z113	DB2 z/OS	Watch Replay	Mitigating migration mayhem in a deprecated world Db2 has grown a lot over the years and, partly due to this, it carries around a ton of old baggage. It is definitely the right time to start crawling through the Db2 catalog and review any and all of the "deprecated" objects that are hanging around still nailed to their perches!	Roy Boxwell, Software Engineering @rld_box
#Z112	Db2 z/OS	Watch Replay	Db2 For z/OS Index Performance Recommendations Many considerations can be made regarding design choices when building and maintaining Db2 for z/OS indexes with regard to high performance. This webcast is going to attempt to address many of those choices, but it is the combination of knowing how an application is going to use the database as well as adequate testing to make the appropriate design decisions.	Daniel Luksetich @DanL_Database
#Z111	Db2 z/OS	Watch Replay	Distributed access to Db2: must know A refresher about must know about Distributed access to Db2. DRDA best practices and what is new. A new look into a classic topic.	Cristian Molaro @cristianmolaro
#Z110	Db2 z/OS	Watch Replay	Db2 for z/OS Visual Studio Code support, read all about it! Come one, come all developers - and get a taste of where we are and where we're going! Are you wondering what's going on with Data Studio, and what the future will bring for developers of Db2 for z/OS applications? Attend this session to see a demo of available, and near term features integrated into Visual Studio Code.	Patrick Bossman @Bossman2day
#Z109	Db2 z/OS	Watch Replay	Exploit DB2's Log Relational DBMS have a transaction log for recovery purposes in case of failure. However, the information stored in the log is also well suited for other purposes. Think of undoing bad transactions, data propagation, and auditing. The DB2 log is a potential gold mine if you know how to seamlessly filter and make complex log data usable. We will show you how the DB2 log is structured, what data DB2 stores in the log besides table contents, and how to find the information you are looking for.	Kai Stroh

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