What is the overhead associated with a Subsystem Analyzer extent and volume collection?
Article ID: 188924
Updated On:
Products
Bind Analyzer for DB2 for z/OS
SQL-Ease for DB2 for z/OS
SYSVIEW Performance Management Option for DB2 for z/OS
Plan Analyzer for DB2 for z/OS
Subsystem Analyzer for DB2 for z/OS
Database Management for DB2 for z/OS - Performance Suite
Database Management for DB2 for z/OS - SQL Performance Suite
Insight Performance Monitor for DB2 UDB for z/OS
Issue/Introduction
This document gives a rough estimate of the overhead associated with a Subsystem Analyzer extent and volume collection.
Environment
Release : 19.0
Component : CA Subsystem Analyzer for Db2 for z/OS
Resolution
These are rough estimates as exact measurements are difficult to obtain, because of the variability of the state of the overall system when tests are run.
Here, there's around a 5% PSA overhead reduction with the Volume and Extent collection off - meaning, for example, 10% with Volume and Extent collection off, and 10.5% with Volume and Extent collection on.
Here, there's around a 5% PSA overhead reduction with the Volume and Extent collection off - meaning, for example, 10% with Volume and Extent collection off, and 10.5% with Volume and Extent collection on.
Feedback
Yes
No
Powered by
