Db2 – The AI database for Enterprises – A modern outlook

Download PDF

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”

Db2 Query Optimization 101

Download PDF

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”

Insight Into Db2 for z/OS Performance Key Metrics and How to Use Them

Download PDF

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”

JC Greatest Hits, War Stories, & Best Practices, 2019 – Part 2

Download PDF

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”

JC Greatest Hits, War Stories, & Best Practices, 2019 – Part 1

Download PDF

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”

Solving an Intermittent Production Problem Using Db2 for z/OS System Profile Monitoring

Download PDF

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”

Db2 12 for z/OS and Asynchronous Lock Structure Duplexing: Update

Download PDF

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”