The Activity Summary window gives a quick access to the activity of a DB2 instance.
Connected Indicates the number of applications that are currently connected to the database. Active Indicates the number of applications that are currently connected to the database, and for which the database manager is currently processing a request.
Waiting Token The percentage of registered database agents currently waiting on processing tokens within the database manager instance. Waiting Locks The percentage of registered database agents wainting for locks within the database manager instance. Non Pooled The percentage of all active database agents not retrieved from the agent pool.
Buffer Pool (%)
HR Overall The buffer pool hit ratio indicates the percentage of time that the database manager did not need to load a page from disk in order to service a page request because the page was already in the buffer pool. The greater the buffer pool hit ratio, the lower the frequency of disk I/O. HR Index Indicates the percentage of all read request for index pages that were satisfied by a page found in the buffer pool. HR Package The number of package cache lookups that have resulted in applications retrieveing required SQL information from package cache. HR Catalog The number of times that catalog cache was accessed to retrieve table descriptor information. Sorts Overflows The percentage of total sorts and hash joins that ran out of sort heap space. Sort Thresholds The amount of the sort heap currently being used (expressed as a percentage of the sort heap threshold for the database).
Dynamic The number of dynamic SQL statements that were attempted. Static The number of static SQL statements that were attempted. Completed The total number of SQL COMMIT and ROLLBACK statements that have been attempted.
Direct R The number of read operations that do not use the buffer pool. Direct W The number of write operations that do not use the buffer pool. Log R The number of log pages read from disk by the logger. Log W The number of log pages written to disk by the logger. Total W Indicates the number of times a buffer pool data page, data page for an XML storage object (XDA), index page were physically written to disk. Sync W The number of physical data, index write requests performed synchronously (include on XML storage object data pages). That is, physical page writes that were performed by database manager agents. Async W The number of times a buffer pool data page, data page for an XML storage object (XDA), index page were physically written to disk by either an asynchronous page cleaner, or a prefetcher. A prefetcher may have written dirty pages to disk to make space for the pages being prefetched. Total R Indicates the number of data pages, data pages for an XML storage object (XDA), index pages read in from the table space containers (physical) for temporary, regular and large table spaces. Sync R The number of physical reads performed synchronously (include on XML storage object data pages) (that is, physical data and index page reads that were performed by database manager agents (include on XML data)). Async R Indicates the number of data pages, index pages and XML storage object (XDA) data pages read in from the table space containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of table spaces.
I/O Agents (%)
Victim Cleans The percentage of defined page cleaners that were invoked to perform victim page cleans. Thresh Cleans The percentage of page cleans that were a result of a buffer pool reaching the dirty page threshold. Log Cleans The percentage of page cleans that were the result of log space shortage.
Used The percentage of active log space currently holding uncommited transactions in the database.
SMS The percentage of space in a SMS tablespace that is already used. DMS The percentage of space in a DMS tablespace that is already used.
Copyright © AgileLoad. All rights reserved.