Feb 26, 2018 8:14:00 AM by Robert Catterall
SQL statements executed by way of the Db2 for z/OS distributed data facility (DDF) are not, of course, the only workload that uses zIIP MIPs, but in my experience this does tend to be the main driver of zIIP utilization in a z/OS system on which Db2 runs. I posted an entry to this blog, a few years ago, on the importance of avoiding zIIP engine contention . In that blog entry, I described how to calculate the "zIIP spill-over ratio" for a Db2 DDF workload (the percentage of zIIP-eligible ...read more
Tags: Toad for IBM DB2 IBM DB2 DB2 z/OS
Written by Robert Catterall
We use cookies to improve your experience with our site. By continuing to use this site, you consent to our use of cookies. Learn more.