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”

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

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: z/OS LPAR real storage resources are getting larger and larger: it is no longer unusual to see LPARs with several hundred gigabytes of memory. As real storage sizes have grown, Db2 for z/OS has expanded the opportunities available for exploiting this resource for enhanced system and application performance and CPU efficiency. Continue reading “Db2 for z/OS: Exploiting Large Real Storage Resources on IBM Z”

Help! I’m overwhelmed with all these metrics in my Db2 monitor

Download PDF

Watch recording (logged in Tridex members only)

Session title: Help! I’m overwhelmed with all these metrics in my Db2 monitor

Session abstract: You want to improve Db2 performance, but what do I look for? There are many different monitors and tools hundreds of screens and over 1500 of metrics. It can be overwhelming, especially if you are not familiar with the application or new to Db2 or the mainframe. Continue reading “Help! I’m overwhelmed with all these metrics in my Db2 monitor”