Starter Guide to Data Sharing Monitoring and Tuning

Download PDF

Watch recording (logged in Tridex members only)

Session title: Starter Guide to Data Sharing Monitoring and Tuning

Session abstract: This session will introduce and discuss: Firstly,  global locking and the Db2 LOCK1 structure, and global lock contention monitoring and tuning; Secondly, group buffer pools, GBP reads, GBP writes, GBP castout, and GBP monitoring and tuning. Continue reading “Starter Guide to Data Sharing Monitoring and Tuning”

JC’s Greatest Hits, War Stories and Best Practices 2020

Download PDF (Part 1) (Part 2)

Watch recording (logged in Tridex members only)

Session title: JC’s Greatest Hits, War Stories and Best Practices 2020

Session abstract: This session will introduce and discuss: recommended best practice; lessons to be learned from the good, bad and ugly experiences from other installations; answers to important, frequent or difficult questions. Specific topics to be included: Continue reading “JC’s Greatest Hits, War Stories and Best Practices 2020”

Db2 Turbo Statistics – How to Accelerate Your Query Performance

Download PDF

Watch recording (logged in Tridex members only)

Session title: Db2 Turbo Statistics – How to Accelerate Your Query Performance

Session abstract: Catalog statistics are what fuel the Db2 optimizer, and its tank is always full because of automatic statistics collection. However there are some extra buttons on the dashboard that you can use to enable even better statistics to really boost your query performance.

Continue reading “Db2 Turbo Statistics – How to Accelerate Your Query Performance”

The Most Important Stuff You Should Know About Db2 12 for z/OS

Download PDF

Watch recording (logged in Tridex members only)

Session title: Db2 for z/OS: Exploiting Large Real Storage Resources on IBM Z

Session abstract: Db2 12 for z/OS is packed with new features and functions. It’s easy to talk all day about Db2 12, and I do that on a regular basis. For this session, I’ve boiled down what I consider to be the most important Db2 12-related information into a 75-minute presentation. Continue reading “The Most Important Stuff You Should Know About Db2 12 for z/OS”