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 > >
...