Page History
...
The Activity tab was designed to answer questions such as, "What happened yesterday, as well as a month ago and a year ago?" and "What has been the performance level of my applications over time.".
Data in the Activity tab is available up to the last time slice that ended (information on the last minute is available in the Current tab). The Activity tab is usually the place to identify and investigate tuning problems.
...
You can use the Filter dialog box to filter the Details pane so that only the contribution of certain entities is included. See “Filtering data” on page 19 Filtering data.
The Activity tab is divided into two areas, the Tree pane and the Details pane. A breakdown of the entities that are associated with the selected entity is displayed in the Tree pane. Information on the entity you selected is displayed in the Details pane.
...
The duration value displayed next to each entry reflects the duration of each instance in the selected entity, according to the sort parameter you selected. The sort parameter is displayed next to each entity. The default entity for the top entity in the tree is In DB2 time. See “About About configuring your settings” on page 17settings.
Determining what information is displayed in the Tree
...
You can switch to a different time frame and view additional information on the selected entity that was collected for that time frame. Only the information in the subnodes sub-nodes of the entity you have selected is refreshed.
...
When database files are stored on an EMC Storage unit and the Precise for Storage agent is installed, a tab named Storage is displayed. The tab presents a list of storage device used by the DB Partition entity. For each storage device it displays statistics regarding Cache Hit Ratio, Containers and Table Spaces, Requests amounts, Throughput, and I/O rate. See “Storage tab” on page 46 Storage tab.
When information on a selected entity is displayed in table and graph format in the Details pane, there is a direct correlation between the selected entry in the table and the information displayed in the graph below the table. Selecting a different row changes the information displayed in the graph displayed below the table.
...
The Activity tab displays information on different entities. This section provides an overview of all entities, their meaning, and their views. See “The The Precise for DB2 Time Model” on page 12Model.
The following entities can be examined in the Activity tab:
...
The following table describes the information displayed in the Storage tab.
Table 10 Storage tab Anchor StorageTabTable StorageTabTable
Item | Description |
---|---|
Devices in Use | List of devices used by DB2 database partition. Storage Statistics information is shown for each device. Selecting one of devices will present detailed information about the selected device in other components below. |
Device <unit name> <device number>’s Cache Hits | Historical overtime graph of read, write, and combined cache hit ratio (%) of the selected device. |
Containers and Tablespaces on Device <unit name><device number> | List of Containers and Table spaces stored on the selected device. |
Device <unit name> <device number>’s Requests | Historical overtime bars graph for read and write requests for the selected device. |
Device <unit name> <device number>’s Throughput | Historical overtime graph for Throughput (Mb/Sec) of the selected device. |
Device <unit name> <device number>’s I/O Rate | Historical overtime graph for I/O rate (Sec/Req) on the selected device. |
...
Item | Description |
---|---|
In DB2 (Summed) | The In DB2 breakdowns over time. |
Overall Activity (Summed) | The application’s application's overall activity including In DB2 over time. |
Sessions | Number of sessions. |
Compile and Recompile | The time the application spent for commits & recompiles over time. |
Commits and Rollbacks | The time the application spent for commits & rollbacks over time. |
...
Item | Description |
---|---|
In DB2 (Summed) | The In DB2 breakdowns over time. |
Overall Activity (Summed) | The application’s application's overall activity including In DB2 over time. |
Sessions | Number of sessions. |
Compile and Recompile | The time the application spent for commits & recompiles over time. |
Commits and Rollbacks | The time the application spent for commits & rollbacks over time. |
...
Item | Description |
---|---|
Details | Details about the selected bufferpool. |
I/O Time | Total I/O time breakdowns. |
I/O Count | Total I/O Count breakdowns. |