Page History
...
The Dashboard tab provides answers to questions like: "Are all my DB2 database partitions up and running?"; "Which database partition is consuming the most resources?"; "Which application is consuming the most resources for the specified database partition and across all database partitions?", “Is "Is the problem related to a slow I/O, a low hit-ratio, a memory shortage, high CPU consumption, or another specific problem?”"
The All row in the All DB2 Databases table located in the Main area (left pane) displays the average availability of all database partitions. When you select the All row, a summary of the activities of all the database partitions and a comparison of application identifiers is displayed in the tab views in the Database Details area (right pane).
...
When an extension for ERP is installed, the Precise for DB2 Collector divides DB2 activities into several groups, called work types.
Technology | Work type |
---|---|
SAP Dialog | Activities generated from the SAP Dialog work process. |
SAP Update | Activities generated from the SAP Update work process. |
SAP Spool | Activities generated from the SAP Spool work process. |
SAP Background | Activities generated from the SAP Background work process. |
Info |
---|
All databases, including those with only one partition, are referred to as database partitions. In the Multipartition column, databases with only one partition will have a value = ‘No’. |
See “Precise for DB2 basics” on page 14, “Getting current application information” on page 30, “Examining performance over time” on page 39, “Examining the relationship between database objects” on page 67, “Analyzing Statement plans” on page 73, “Simulating the effect of changes” on page 82, and “Examining DB2 database statistics” on page 86.
No. |
Anchor | ||||
---|---|---|---|---|
|
Figure 3- 1 Precise for DB2 Dashboard tab
...
You can filter the information shown in the Details area so that only the contribution of certain entities is included. See “Filtering data” on page 19 Filtering data.
About the general tab structure
The following table displays information on the general structure of the Dashboard tab.
Table 3- 1 Elements of the Dashboard tab
Element | Description | ||
---|---|---|---|
Time Frame | Allows selecting the time frame we want to work with. The time frame influences all counters displayed (e.g., executions, I/O time). | ||
Filter On/Off | Allows filtering the displayed information according to user-defined conditions. | ||
Tab heading | Displays All DB2 databases. | ||
Main area | Each row displays a single database or a single database partition. It displays all databases/partitions which belong to the current tab. Also displayed is a summary row (All). | ||
Details area heading | Displays either a database partition and the name of the server it is running on, or all databases running on all servers.
| ||
Details area | Displays graphs and tables describing the row selected in the Main area. | ||
Details area tabs | Allows switching between the different views (Overview, Application) |
About the Main area in the Dashboard tab
...
The following table displays information on the different database partitions in the application.
Table 3- 2 Database partitions table
Column name | Description | Sortable | ||
---|---|---|---|---|
Status | Icon representing the status of the collector (running, stopped, starting, etc.) | No | ||
Server | Name of the server on which the database partition is running. | Yes | ||
Database partition | <instance>.<database>[.number] | Yes | ||
In DB2 (summed) | Stacked bar of 'In DB2' data with regular 3 display modes. Information limited to time frame. | Yes | ||
Executions | # of statements executed in time frame.
| Yes | ||
Total lock time | Time period this database partition spent in lock wait. | Yes | ||
Multi-partitioned | Icon representing if this is part of a multi-partitioned installation or not. | Yes | ||
Availability | % of availability (0-100) | Yes | ||
Catalog partition | Name of the database partition (see format above) which contains the database catalog. For single partition, this column will be left blank. | Yes |
Info |
---|
When you open the Dashboard tab, only the first six columns are displayed. To view additional columns (such as: Executions and Last Update columns), use the left and right arrows to the right of the column titles. |
...
The following table describes the different elements of the Top consumers table.
Table 3-3 Top consumers table
Column name | Description | Sortable |
---|---|---|
Launch | Launch to the activity's statement or object. You will see activity over time. From a statement, launch to the SQL tab. From an Index or Table, Launch to the Activity tab. | No |
Consumer Type | Table, Index or Statement. | Yes |
Text | Table name, index name or statement unformatted text. | Yes |
In DB2 (summed) | In DB2 time consumed by the object during the time period. | Yes |
% | % (0-100) representing the percentage of time (of the total In DB2 time of the database partition) spent on that statement or object. | Yes |
Executions | Total statement executions within the selected time frame. Available for statements, tables, and indexes. | Yes |
The Bufferpool activity view
...
The following table describes the different elements of the Bufferpool activity table.
Table 3- 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 |
The Application tab
The Application tab displays information in three views:
...
All views share the same columns headings. The following table describes the different elements of these tables.
Table 3- 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. |
...
- 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.
Scroll Ignore | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
Newtabfooter |
|
...
Precise. Performance intelligence from click to storage. Learn more > >
...
...