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
Toad for SAP Solutions – How to organize your content
Watch how to organize your content in Toad for SAP Solutions from Quest....
Toad for Oracle – How to tell what columns would be good for indexes
Ever wonder how to tell what columns would be good for indexes? Once the index is created, ever wonder why you never see it in SQL explain plans you would expect to see it in??? There are 2 useful st...
Getting started with Oracle 18c Express edition
Introduction to Oracle 18c Express edition (XE) Oracle 18c Express edition (XE) is a lightweight database that can be used to host small applications and is often used by students or developers to tes...
