If you’re responsible for Db2 performance tuning, read part 2 in this blog series. This second blog takes a deep dive into the Db2 Process Model and shows you a time-saving shortcut. DBAs, are you ...
DBAs, are you responsible for Db2 LUW database performance? Is Db2 LUW relatively new to you? If you answer yes to either of these questions, I think this post will help. What is the Db2 Process Mo...
![Coffee with Toad® 2019 [Toad World® blog monthly recap]](https://s38063.pcdn.co/wp-content/uploads/2025/09/fi-CoffeeWithToad2019-300x220-1.png)
Welcome to Coffee with Toad® 2019, the Toad World® blog monthly recap. Published the first Tuesday of every month, Coffee with Toad is organized by month, then by product, followed by each blog title ...
DB2 LUW DBAs are no different than DBAs who manage other types of databases—they are constantly pulled in many directions at once, and they are asked to keep databases and applications that use those ...
We are pleased to announce the 7.0 release of Toad for DB2 which went GA on April 15, 2019. This Blog highlights many of the new features and enhancement introduced in Toad for DB2 v7.0. General En...
How many times have you been working away in Toad and you come to a point where you aren’t sure how to do something and you ask yourself, “I wonder if there is a way to get an answer to this?” Or may...
Comparing schemas across database platforms, like DB2 LUW and DB2 z/OS, is sometimes necessary and often puzzling. No matter your motivation for comparing them, this can be a daunting task. Maybe you’...
DB2 LUW indexes, like any database indexes, can be extremely helpful for queries that need data that’s scattered in the database. They act, of course, like a book’s index – rather than methodically ...
If you're reading this, it's probably because you've found blogs to be a useful source of technical Db2 for z/OS information. I want to direct your attention to one of the newer kids on the Db2 blog b...
Sometimes, the default value of a Db2 ZPARM parameter is changed to reflect new realities of Db2 workloads and of systems on which Db2 for z/OS runs. When that happens, a Db2-using organization may st...
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 ...
Not long ago, a veteran Db2 for z/OS DBA contacted me with an interesting question. He had, in the system he supported, a table with a clustering index, and he wanted to know how he could get Db2 to a...
