Show | OS | Date & Duration | Theme | Guest(s)
@Twitter_ID |
Photos-
Click to see profiles! |
Show | OS | Replay Link | Theme | Guest(s) | Photos |
#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. |
@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_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. |
@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 |
![]() |
#242 | DB2 LUW |
Watch
Replay |
V12 Plans & New Watson Query!
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. |
@piotrm42 |
![]() |
#241 | DB2 LUW |
Watch
Replay |
The Db2 Access Plan Troubleshooting Handbook
Optimal query access plans are essential for good query performance and it is the Db2 query optimizer's job to choose the best one. This presentation will cover monitoring and explain facility techniques to help you determine why an access plan is performing poorly and how to correct some common sub-optimal access plan problems. Attend this session to learn the essentials of access plan troubleshooting and query performance tuning. |
John Hornibrook, STSM, IBM Toronto Lab
@rld_box |
![]() |
#240 | DB2 LUW |
Watch
Replay |
Techniques for Optimal DB Performance Part 1
In this presentation, Jim Bean 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 |
![]() |
#239 | DB2 LUW |
Watch
Replay |
Db2 Blu Improvements
Satya presents an important update to many features: - Db2 BLU Storage and Compression Features - Db2 Runtime Features - Db2 Catalog Features - Db2 Connectivity and Spatial Features |
@satya_ksr |
![]() |
#238 | DB2 LUW |
Watch
Replay |
Lessons Learned with Building Db2 HADR Clusters on AWS
Running Db2 on "the cloud" is now very common. There are a number of ways to do this - everything from "roll your own" (IaaS) all the way through to using one of the IBM DBaaS offerings. This presentation looks at lessons learnt while building fully automated Db2 clusters on top of IaaS on Amazon's AWS cloud. After discussing why we might want to use IaaS rather than a fully managed service, we will look at what producing a Db2 build for AWS teaches us both about Db2 features and the AWS (and other) cloud platforms. |
Philip Nelson |
![]() |
#237 | DB2 LUW |
Watch
Replay |
Db2 REST - From Movie Recommendation to... Shazam!?
Let's dive into Db2 REST, a modern, REST-based interface for your data, that's flexible enough to be applied practically anywhere. Let's take a look at a real-world movie recommendation application powered by Db2 REST. We'll also have some fun exploring a music discovery app - similar to Shazam - powered by Db2 and Db2 REST. Click register for details... |
@TajyMany |
![]() |
#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 |
|
![]() |
#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! |
@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. |
@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. |
|
![]() |
#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. |
@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. |
@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! |
@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. |
@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. |
@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. |
@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. |
@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. |
|
![]() |
Please inquire about sponsorship opportunities. Email "db2nightshow" "at" "dbisoftware.com". |
![]() www.IDUG.org |
![]() www.DBISoftware.com |