Tridex Db2 z/OS – March 11th 2021 agenda

9:45 – 10:45Roy Boxwell, SEGUS Inc
Are you happy or are you still deprecated?
11:00 – 12:00David Nguyen, Frances Villafuerte, IBM
Huffman Compression Usability
12:00 – 1:00Tammie Dang, IBM
Rebind Phase-In

 

Are you happy or are you still deprecated?

Download PDF

Watch recording (logged in Tridex members only)

Session title: Are you happy or are you still deprecated?

Session abstract: Db2 has grown a lot over the years and, partly due to this, it carries around a ton of old baggage. It is definitely the right time to start crawling through the Db2 catalog and review any and all of the “deprecated” objects that are hanging around still nailed to their perches! Continue reading “Are you happy or are you still deprecated?”

Huffman Compression Usability

Download PDF

Watch recording (logged in Tridex members only)

Session title: Huffman Compression Usability

Session abstract: Db2 12 for z/OS delivered the Huffman compression feature as an additional compression option. The Huffman compression feature exploits the Z hardware-based Huffman entropy encoding compression within the IBM z14 Compression Coprocessor (CMPSC). Continue reading “Huffman Compression Usability”

Rebind Phase-In

Download PDF

Watch recording (logged in Tridex members only)

Session title: Rebind Phase-In

Session abstract: In a busy Db2 system, applications are continuously executed by several threads. In order for a DBA to rebind application packages to enable new features by changing bind options or make changes to access paths for the static SQL statements, the DBA must wait for a window in which the applications aren’t running, must take an application outage, or must use a cumbersome workaround. Continue reading “Rebind Phase-In”

Tridex Db2 z/OS – November 12th 2020 agenda

10:00 – 11:00John Campbell, Distinguished Engineer, IBM
Starter Guide to Data Sharing Monitoring and Tuning
11:00 – 11:15Break
11:15 – 1:15John Campbell, Distinguished Engineer, IBM
JC’s Greatest Hits, War Stories and Best Practices 2020

 

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”

Tridex Db2 z/OS – September 10th 2020 agenda

09:30 – 10:30Robert Catterall, IBM
The Most Important Stuff You Should Know About Db2 12 for z/OS
10:30 – 11:30Robert Catterall, IBM
Db2 for z/OS: Exploiting Large Real Storage Resources on IBM Z
11:45 – 12:45John Anderson, Broadcom
Help! I’m overwhelmed with all these metrics in my Db2 monitor