Page History
...
The following table describes the different elements of the Bufferpool activity table.
Table 3-4 Bufferpool 4 Bufferpool activity table
| Column |
|---|
...
| name | Description | Sortable |
|---|---|---|
| Launch | Launch to activity's bufferpool. You will be able to see the bufferpool's activity over time. |
...
| No | |
| Name | The |
...
| bufferpool name. |
...
| Yes | |
| Total I/O |
...
| time | A stacked bar of I/O time break into the following:
|
...
|
...
|
...
|
...
|
...
|
...
| Yes | |
| Hit |
...
| ratio | Bufferpool hit ratio. | Yes |
| Size | Bufferpool size (in MB) |
...
| . | Yes |
| Bufferpool size (in MB) |
...
| Bufferpool page size. | Yes | |
| Response Time (Avg) |
...
| Bufferpool’s average response |
...
| time. | No | |
| Logical Read | Logical reads. | Yes |
...
| Total I/O |
...
| Count | Bufferpool’s total I/O count, broken down into the following:
|
...
|
...
|
...
|
...
|
...
| Yes | |
| Physical Reads | Total physical reads. | Yes |
| Pages | Number of pages. | Yes |
Physical Reads Total physical reads Yes
...
The Application tab
The Application tab displays information in three views:■ Programs
- Programs
...
- Modules
...
- DB Users
All views share the same columns headings. The following table describes the different elements of these tables.
Table 3-5 Application 5 Application tab tables
| Column |
|---|
...
| name | Description | Sortable |
|---|---|---|
| Program | Name of the program. |
...
| Yes | |
| In DB2 (summed) |
...
| The In DB2 view displays a stacked bar graph on the In DB2 resource consumption over time, for the selected time frame, broken down into the In DB2 application states. |
...
| Yes | |
| % | Percentage |
...
| of time the program took out of the total In DB2 time for the selected database partition. |
...
| Yes | |
| Executions | Number |
...
| of program executions. |
...
| Yes | |
| Applications | Number of applications opened by the program. |
...
| Yes |
| Info |
|---|
If you are working with SAP and ERP support is installed, the Application tab is named SAP instead, and the entities displayed are Work Types, Transactions, and Modules. |
Launching from the Dashboard to other tabs
When you open the Dashboard tab and select a row on the Main area (left pane) and then click on another tab, the target tab is opened in the context of the selected database partition.
...
You can identify a performance problem by doing one or more of the following:■ Identifying
...
...
...
| Anchor | ||||
|---|---|---|---|---|
|
Precise for DB2 enables you to determine which are the most resource-consuming database partitions, indicating a potential performance problem.
...
To identify the most resource-consuming database partition1 In
- In the Database Partition list, choose the Database Partition you want to analyze.
...
- In the Time Frame list, choose the period of time you want to analyze.
...
- In the Database Partition Details area view the In DB2 (Summed) overtime resource consumption graph. You can then launch to the Activity tab to check what the application was doing during the specified time period.
...
- In the Database Partition Details area view the Top Consumers grid to see which were the top statements and objects (tables and indexes) that consumed most of the resources. Then launch in context to the SQL tab to further investigate the heavy statement, or directly launch in context to the Activity tab to see which statements were using the heavy object.
...
- In the Database Partition Details area view the Buffer pool Activity grid to see which buffer pools were most active, and what are the statistics regarding these buffer pools. Then launch in context to the Activity tab to view overtime and extended information on these buffer pools.
...
- Use any of the following options to investigate further:
...
- Launch to the Statistics tab for the selected database partition.
...
- Launch to the Activity tab to check what the application was doing at the specified time.
| Anchor | ||||
|---|---|---|---|---|
|
Precise for DB2 enables you to determine which are the most resource-consuming statements and objects (tables and indexes), as measured by the total time spent executing In DB2, indicating a potential performance problem.
...
To identify the top resource consumers (statements and objects)1 In
- In the Database Partition list, choose the Database Partition you want to analyze.
...
- In the Time Frame list, choose the period of time you want to analyze.
...
- In the Database Partition Details area view the Top Consumers grid to see which were the top statements and objects (tables and indexes) that consumed most of the resources.
...
- In case of a heavy statement directly launch in context to the SQL tab to further investigate the heavy statement.
In case of a heavy table or index directly launch in context to the Activity tab to see which statements were using the heavy object.
| Anchor | ||||
|---|---|---|---|---|
|
Precise for DB2 enables you to determine which are the most activated buffer pools. It also presents additional statistics-related information on each buffer pool, such as hit ratio, average response time etc.
The following example shows how to identify the top active buffer pools. To identify the top active buffer pools1 In
- In the Database Partition list, choose the Database Partition you want to analyze.
...
- In the Time Frame list, choose the period of time you want to analyze.
...
- In the Database Partition Details area view the Buffer pool Activity grid to see which were the most active buffer pools. Examine additional statistics information on the active buffer pool.
...
- In case you are interested in other statistics (e.g. the hit ratio), order the grid according to the required column.
...
- Launch directly to the Activity tab (using the launch icon) to view overtime and additional information on the specified buffer pool. Then drill from there to tablespaces and objects to see which were the most activated tablespaces and objects within the specified buffer pool.
| Anchor | ||||
|---|---|---|---|---|
|
A look at the Applications tab quickly helps you identify the top resource-consuming entities. The following example shows how to identify the top resource-consuming entities.
To identify the top resource consumers in various entities1 In
- In the Database Partition list, choose the Database Partition you want to analyze.
...
- In the Time Frame list, choose the period of time you want to analyze.
...
- In the Database Partition Details area, click Applications. For example, a SAP database, PS8 on hp8, is monitored by a SAP extension.
The Application tab shows the following SAP-related top entities:
...
- - Background work type
...
- - SAP user SUPER
...
- - Transaction SAP_CCMS_MONI_BATCH_DP
Most likely, these entities are related.
...
- To investigate further, click an entity to launch the Activity tab. In the Activity tab you can confirm the connection between the problematic entities. For this example, you can identify a background transaction run by the SAP CCMS administration tool.
Precise. Performance intelligence from click to storage. Learn more > >
...