Articles & Content

Robert Catterall

Robert Catterall is a well-known DB2 z/OS expert. He is a regular speaker at IDUG events and a Past President of IDUG

Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG and should not be construed as reflecting official positions of the IBM Corporation. .

 

 
The Two Paths to the Db2 for z/OS Distributed Data FacilityIt's been almost two years since the general availability date of Db2 12 for z/OS and, by way of that new version, the availability of Db2's native REST interface (retrofitted to Db2 11 for z/OS via APARs PI66828 and PI70477). While the REST interface to Db2 is relatively new, the foundation on whic…
How Big is Big? (2018 Update - Db2 for z/OS Buffer Pools and DDF Activity)Almost 5 years ago, I posted to this blog an entry on the question, "How big is big?" in a Db2 for z/OS context. Two areas that I covered in that blog entry are buffer pool configuration size and DDF transaction volume. Quite a lot has changed since October 2013, and it's time for a Db2 "How big is …
Db2 for z/OS: Using the Profile Tables to Direct DDF Applications to Particular Package CollectionsI've posted several entries to this blog on the topic of high-performance DBATs (for example, one from a few years ago covered a MAXDBAT implication related to high-performance DBAT usage). You may well be aware that a "regular" DBAT (a DBAT being a DDF thread) becomes a high-performance DBAT when a…
Db2 for z/OS PBG Table Spaces: The Ins and Outs of Partition AdditionIn an entry posted to this blog about three years ago, I advocated for putting some thought into the PBG versus PBR decision (partition-by-growth versus partition-by-range) for larger tables (for smaller tables, PBG is often the sensible choice, especially when the associated table space is likely t…
Db2 for z/OS Buffer Pools: Index Root Pages and the Data Management ThresholdSometimes, a change in the way Db2 for z/OS manages its resources is introduced, and the change "flies under the radar" (i.e, it escapes the notice of most Db2 users) because it is relatively small in terms of scope and impact and is not widely highlighted in the product documentation, and it delive…
Db2 for z/OS Buffer Pools - Time to Give AUTOSIZE(YES) a Try?Db2 9 for z/OS became generally available back in 2007. In the years since, most of the features introduced with Db2 9 have been broadly put to use. An interesting exception is the auto-sizing of buffer pools, implemented via the AUTOSIZE(YES) option of the -ALTER BUFFERPOOL command. Based on my exp…
Another Db2 for z/OS Blog You Should Check OutIf 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 block: Db2 for z/OS News from the Lab. What makes the Db2 for z/OS News from the Lab blog particular…
Db2 for z/OS: CACHEPAC is Another ZPARM You Should CheckSometimes, 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 stick with the old default value for the ZPARM, and going that route can have a negative impact on the…
Db2 for z/OS: DDF, zIIP Engines, and SMT2SQL 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 …
Db2 12 for z/OS and Insert Algorithm 2: Faster, More-Efficient INSERTs than Ever BeforeNear the end of the blog entry I most recently posted prior to this one, I mentioned that a specification of MEMBER CLUSTER for a Db2 for z/OS universal table space could help maximize INSERT throughput and efficiency, in situations where the importance of that objective outweighs that of keeping da…