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
Amphibian Evolution, GDPR and Sensitive Data Protection
Who says that a Toad can’t evolve? Refusing to be typecast and constrained within one branch of the evolutionary tree, the Quest® Toad® continues to transform and develop as it strives to meet DBA nee...
Spotlight on Oracle – Library cache latches (SOO32)
Library cache latches The library cache latches protect the cached SQL statements and object definitions held in the library cache within the shared pool. The library cache latch must be obtained ...
Why can’t database ops align with DevOps processes?
The Toad is on the case. As the Toad evolves to ease challenges presented by DevOps, the November, new release of Toad for Oracle 13.2 will include a new utPLSQL unit test creation module in all Toad ...
