DB2 Database Performance (DB2DB_PERFORMANCE)
The DB2DB_PERFORMANCE application class serves as a container for consumer parameters related to database performance.
Application class attributes
Item | Description |
---|---|
Active | Yes |
Created by | Discovery |
Parent class | DB2_DB_PARTITION |
Child class | None |
Attributes (parameters)
The following attributes are available for this monitor type:
- Average direct read time (AveDirReadTime)
- Average direct write time (AveDirWriteTime)
- Average number sectors read per direct read (AveNumSectorsRead)
- Average number sectors written per direct write (AveNumSectorsWritten)
- Average sort time (AveSortTime)
- Catalog cache hit ratio (CtlgCacheHitRatio)
- Largest size reached by the package cache (MaxPkgCacheSize)
- Number of database files closed (DBFilesClosed)
- Number of hash join overflows (HashJoinOverflows)
- Number of hash join small overflows (HashJoinSmallOverflows)
- Number of total hash joins (TotHashJoins)
- Number of total hash loops (TotHashLoops)
- Package cache hit ratio (PkgCacheHitRatio)
- Package cache overflowes (PkgCacheOverflows)
- Percentage of catalog cache heap used (PctCtlgCacheHeapUsed)
- Percentage of database heap used (PctDBHeapUsed)
- Percentage of lock heap used (PctLockHeapUsed)
- Percentage of overflow sort requests (PctOverflowSortReqs)
- Percentage of package cache heap used (PctPkgCacheHeapUsed)
- Percentage of utility heap used (PctUtilHeapUsed)
- Total throughput (TotThroughput)
- Total units of work (TotUOW)
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.