IFCID 199 – “DNA” for “Investigating” Db2 Buffer Pool Performance
Db2 IFCID 199 data provides buffer pool statistics at the dataset level. Integrating this with SMF 42 dataset I/O performance data provides extensive insights into I/O activity and response time data at the Db2 buffer pool and database levels.
Integrating Db2 IFCID 199 with SMF 42 Dataset Performance Data
A primary benefit of integrating Db2 SMF 42 data with IFCIP 199 is exploring that when it getpage cannot be satisfied from a buffer and thus a sync read IO occurs, what are the performance characteristics of that IO?
Db2 Accounting Data: Exploring Analysis by Connection Type
Learn what insights you can gain by exploring Db2 Accounting Data by Connection Type.
z/OS Memory and Db2 – A Match Made in Heaven
Leveraging z/OS memory so that almost all data referenced by Db2 already resides in a buffer pool significantly improves performance and CPU efficiency.
Db2 Buffer Pool Tuning: Analysis by Connection Type
See how to analyze and tune Db2 buffer pools by viewing the SMF data aggregated by connection type.
Db2 Buffer Pool Tuning: Measuring Benefits
Learn what insights you can gain into Db2 Buffer Pool tuning by viewing the elapsed time profile for the work coming from CICS over time
zAcademy: Is Your Mainframe Being Maintained like a Ford F-150 Lightning or a Model T?
This webinar covers in detail the modern-day equivalents of yester-year's antique performance tools.
Is Some Automation Unnecessary Noise or Just Lower Priority Work?
Computers are great at doing what we tell them. They don’t get tired, bored, or complain about the endless work we have them doing. But sometimes automation is running in not so obvious places. Learn some practical guidance for managing those workloads.
Job-level CPU Saving Opportunities in an Enterprise Consumption Environment
Analysts involved in leading CPU reduction efforts will have to focus limited staff resources on the top potential savings opportunities. This article focuses on job-level CPU reduction opportunities.