Page History
...
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’. |
...
Anchor | ||||
---|---|---|---|---|
|
Figure 3- 1 Precise for DB2 Dashboard tab
...
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.
Precise. Performance intelligence from click to storage. Learn more > >
...