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”

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 on Multi-cloud environments, including new fully managed AWS options

Download PDF

Session title: Db2 on Multi-cloud environments, including new fully managed AWS options

Session abstract: In this talk, we will discuss the new offerings for Db2 on AWS and upcoming Azure offerings. It will include Db2 on Cloud’s AWS Technical Preview as well as Db2 Warehouse on Cloud for AWS. Basic architectures and roadmaps will be covered. In addition, DIY options for AWS as well as Kubernetes options will briefly be discussed, as well as advantages and tradeoffs between the different options.

Continue reading “Db2 on Multi-cloud environments, including new fully managed AWS options”

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”

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

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 2”

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

Download PDF

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

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”

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”