Tri-State Db2 Technology Exchange
Db2 Users Group
Session title: What’s New with BLU in Db2 11.5 (and beyond!)
Session abstract: Db2 with BLU Acceleration provides industry leading performance for analytical applications running complex queries through its advanced column-organized table technology. Continue reading “What’s New with BLU in Db2 11.5 (and beyond!)”
Session title: Db2 – The AI database for Enterprises – A modern outlook
Session abstract: We live in an age of data. There is a proliferation of devices resulting in multitude types and uses of data. To effectively use the data and to obtain the needed insights organizations are looking for added tools and technologies that come packaged along with the data store. Continue reading “Db2 – The AI database for Enterprises – A modern outlook”
Session title: Db2 Query Optimization 101
Session abstract: Optimal query access plans are essential for good data server performance and it is the Db2 query optimizer’s job to choose the best access plan. The optimizer is a very sophisticated component of the data server, tasked with the challenging job of choosing good access paths for the variety of features and table organizations supported by Db2.
Continue reading “Db2 Query Optimization 101”
Session title: Insight Into Db2 for z/OS Performance Key Metrics and How to Use Them
Session abstract: This session will firstly discuss the existing key performance metrics in Db2 for z/OS, and then introduce new and updated metrics in the following areas and how to interpret them: Accounting Trace Class 3, EDM pools, Dynamic Statement Cache, and RID Pool. Continue reading “Insight Into Db2 for z/OS Performance Key Metrics and How to Use Them”
Session title: Best Practices for Continuous Delivery
Session abstract: This session will introduce and discuss continuous delivery to provide an overview, what changes and the impact, and what are the recommended besty practices. Continue reading “Best Practices for Continuous Delivery”
Session title: JC Greatest Hits, War Stories, & Best Practices, 2019 – Part 2
Session abstract: Two part session introduces and discusses some of most common and/or most important issues based on worldwide customer engagements. There are two main objectives. Firstly, learn recommended best practice. Secondly, learn from the positive and negative experiences from other customer installations. Continue reading “JC Greatest Hits, War Stories, & Best Practices, 2019 – Part 2”
Session title: JC Greatest Hits, War Stories, & Best Practices, 2019 – Part 1
Session abstract: Two part session introduces and discusses some of most common and/or most important issues based on worldwide customer engagements. There are two main objectives. Firstly, learn recommended best practice. Secondly, learn from the positive and negative experiences from other customer installations. Continue reading “JC Greatest Hits, War Stories, & Best Practices, 2019 – Part 1”
Session title: Solving an Intermittent Production Problem Using Db2 for z/OS System Profile Monitoring
Session abstract: Based on actual customer experience, this session describes how to implement Db2 System Profile Monitoring to optimize and manage access by applications or clients using DRDA to interact with Db2 data. What is Db2 System Profile Monitoring? Continue reading “Solving an Intermittent Production Problem Using Db2 for z/OS System Profile Monitoring”
Session title: Data Virtualization and Visualization
Session abstract: Virtualizing mainframe data sources and taking advantage of zIIP engines can ease the process of data access and assembly. Using extracted SMF Log data, we can explore how QMF can be used to easily visualize data that would otherwise be hard to consume. Continue reading “Data Virtualization and Visualization”
Session title: Db2 12 for z/OS and Asynchronous Lock Structure Duplexing: Update
Session abstract: Db2 12 for z/OS delivered support for Asynchronous Lock Structure Duplexing at General Availability, but most enterprise’s configurations that would benefit from this technology were not able to deploy it right away. Continue reading “Db2 12 for z/OS and Asynchronous Lock Structure Duplexing: Update”