I well remember the first time I saw it. August, 2016. I was looking at output from the DB2 for z/OS command -DISPLAY BUFFERPOOL(ACTIVE) DETAIL, issued on a DB2 11 system, that a client had sent to me for review. I appreciated the fact that I could see in this command output information about DB2’s use of large real storage page frames for page-fixed buffer pools (in a DB2 10 environment, one had to issue -DISPLAY BUFFERPOOL — for an individual pool, versus for all active pools — with an odd …read more
Related Articles
Relation Theory videos by CJ Date
Here is a series of videos by CJ Date on Relational Theory. Introduction video An Introduction to set theory (videos on O’Reilly website) Nullology (Videos on O’Reilly website) ...
Db2 12 for z/OS and Insert Algorithm 2: Faster, More-Efficient INSERTs...
Near 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 through...
Simplify SQL Trace with Quest® Toad® for Oracle DBA edition
Based on my experience, I believe that Quest® Toad® for Oracle is the best SQL Trace analysis tool for SQL performance tuning. This blog, and related articles around using Toad for Oracle Expert Editi...
