Page History
This section includes the following topics:
...
...
...
| Anchor |
|---|
...
|
...
|
The Activity tab allows you to analyze performance behavior over time or within a given time period. When investigating a performance issue, the Activity tab is an excellent place to start. You can easily identify the performance profile of your DB2 database partition and determine who is executing which application, what they are waiting for and how many resources they are consuming. This is the critical information you need to identify the top consumers of your DB2 database partition and its major latencies. By focusing on the top consumers and latencies (wait states) you can maximize the tuning impact on your system while minimizing the time it takes to obtain results.
...
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.
When working in the Activity tab, you can choose to work on a specific entity or to view information on all the databases in the application.
Note: You usually switch to the Activity tab, after focusing on a database partition in the Dashboard tab, or by launching Precise for DB2 from another product (Insight, Alerts, or Report Manager). In these cases, the product automatically focuses on the relevant database partition.
When you do not select a specific database partition to view in-context, a summary of the performance information on All database partitions in the application is displayed. You can analyze the average behavior of the entire Precise for DB2 Tier. You can then identify the database partition which consumes the most resources in your system and focus on it to further your investigation.
When you focus on a specific database partition (either as a result of launching or from the Activity tree) you can also identify which is the dominant resource consumed, in terms of CPU, I/O lock, etc. By identifying your system’s wait type you can formulate an idea as to what kind of solutions will help you improve your system.
Note: If you are working with SAP, PeopleSoft, or Siebel, and ERP support is installed, the Activity tab displays information on the historical Precise for DB2 activity in relation to the ERP application and users, and specific information on executed views and transactions.
| Anchor | ||
|---|---|---|
|
...
|
...
Figure 5-1 Precise for DB2 Activity tab
Tree pane
Details pane
Time frame
Precise bar
Tab Selection bar
When you open the Activity tab from the Dashboard tab, information on the database partition selected in the Dashboard is displayed, or on All DB2 Databases if the All row was selected. When you open the Activity tab from another tab, the settings from your last visit to the Activity tab are retained, such as a drill down to a Statement entity. This is similar to clicking the History button and returning to a previous tab.
...
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.
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.
About the Tree pane in the Activity tab
Which entries are displayed, and how many items are displayed can be changed in the Settings menu.
...
See “About configuring your settings” on page 17.
Determining what information is displayed in the Tree
You can also control the number of entries displayed and the order in which they are displayed in the tree using the sort and filter feature.
To determine what information to display in the tree
1 Right-click on an entity in the tree, and then click Sort and Filter.
2 In the Associate With dialog box, on the Entries tab, select the entity you want to associate data with from the Populate table with list.
3 In the Sort entries by list, determine according to which criteria you want the information to be sorted and in which order.
4 From the Display top list, select the number of rows to display.
5 On the Criteria tab, do the following for each entity you want to associate data with:
From the left drop-down list Select an entity.
...
If you select the operator Like or Not Like, you can use the % wildcard character. If you select the operator In or Not In, type a comma to separate values.
6 Click OK.
About viewing information for entities associated with a selected entity
You can drill down to the entities that are associated with the selected entity by clicking on the plus sign (+) located next to each entity. When you drill down on an entity, associated entities are displayed on the tree and entity details are displayed in the Details pane. When you drill down on an instance that is associated with the selected entity, you display the instances that are associated with the selected entity and you can view additional information for the selected instance in the Details pane.
Viewing information from a different time frame
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 of the entity you have selected is refreshed.
To select a different time frame
1 Click on the entity in the tree.
2 In the Time Frame list, select a different time frame than the one already being displayed.
Notice that only the information for the selected entity is refreshed, and it is moved up to the top of the tree.
Refreshing a view
The Refresh option refreshes the display from the PMDB. To refresh the information displayed
1 Right-click on an entity in the tree.
2 Click Refresh.
Printing the Tree display
You can print an image of what is displayed on the Tree. To print the Tree display
1 Right-click on an entity in the tree.
2 Click Print.
3 Use the print functions of your browser to print out an image of the information displayed on the Tree.
About the Details pane in the Activity tab
The Details pane displays information corresponding to the entity (category) or instance selected in the Tree pane. If an entity (category) is selected, the Details pane displays a Comparison view of all the instances displayed under the selected category in the Tree pane. If an item is selected, the Details pane displays detailed information regarding the selected item.
The Details pane displays information corresponding only to the selected tree branch (displayed in the Tree pane). For example, if you drill down on the Programs category associated to a selected Database Partition item, the Details pane displays only information for the Programs under the selected Database Partition item. The selection you make is reflected in the Details pane only; the Tree display remains unchanged.
Note: When drilling down in the tree, we filter according to the parent entity. There are two exceptions to this rule: drilling down from Tablespaces to Objects and drilling down from Objects to other entities. For example, drilling down from Objects to Statements does not filter Statements in DB2.
For some entities, tabs at the top of the Details pane enable you to view additional information. For example, the tabs displayed for a Statement entity are: General and In DB2. Clicking a tab displays different table columns with the same type of associated entities.
...
You can also launch a different tab altogether. For example, clicking the Tune icon next to a statement will take you to the SQL tab, in context, to allow detailed investigation and tuning of the SQL statement.
| Anchor |
|---|
...
|
...
|
...
The Activity tab displays information on different entities. This section provides an overview of all entities, their meaning, and their views.
...
The following entities can be examined in the Activity tab:
■ About All DB2 Databases
■ About Database Partitions
■ About Databases
■ About Programs
■ About Statements
■ About Objects
■ About Machines
■ About Modules
■ About Actions
■ About OS Users
■ About DB Users
■ About Tablespaces
■ About Bufferpools
About All DB2 Databases
DB2 instances aggregate information from all the databases.
The following table describes the information displayed in the Over Time tab.
Table 5-1 Over Time tab
Item Description
In DB2 (Summed) The In DB2 breakdowns over time
...
Commits and Rollbacks The time the application spent for commits and rollbacks over time.
The following table describes the information displayed in the Overview tab.
Table 5-2 Overview tab
Item Description
Details Summed information for the chosen time frame of Total In db2, Sessions, etc.
...
Statistics Summed statistics information such as locks escalations, locks timeouts, etc
The following table describes the information displayed in the Statistics tab.
Table 5-3 Statistics tab
Item Description
Rows Read/Written The number of rows read and written over time.
...
Locks Locks escalations and locks timeouts over time.
About Database Partitions
Database partitions list all the information taking place in the database partitions.
Database Partition Comparison
The following table describes the information displayed in the General tab.
Table 5-4 General tab
Column Description
Database Partition The name of the database:
...
Sessions Number of sessions
Note: As pointed out in the About the Details pane in the Activity tab section, the graph at the bottom of the screen displays detailed information for the Data Partition selected in the table above.
The following table describes the information displayed in the In DB2 tab.
Table 5-5 In DB2 tab
Column Description
Database Partition The name of the database:
...
Utility Active In DB2 breakdown description
The following table describes the information displayed in the Statistics tab.
Table 5-6 Statistics tab
Column Description
Database Partition The name of the database:
...
Internal Row Affected Number of internal rows affected
Selected Database Partition
The following table describes the information displayed in the Over Time tab.
Table 5-7 Over Time tab
Item Description
In DB2 (Summed) The In DB2 breakdowns over time
...
Commits and Rollbacks The time the application spent for commits & rollbacks over time
The following table describes the information displayed in Overview tab.
Table 5-8 Overview tab
Item Description
Details Detailed activity information
...
Statistics Statistic counters overview
The following table describes the information displayed in the Statistics tab.
Table 5-9 Statistics tab
Item Description
Rows Read/Written Number of rows read/written
Table 5-9 Statistics tab
Item Description
Rows Selected/Affected Number of rows selected/affected
...
Locks Number of lock escalations and lock timeouts over time
The following table describes the information displayed in the Storage tab.
Table 5-10 Storage tab
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 I/O Rate Historical overtime graph for I/O rate (Sec/Req) on the selected device.
About Databases
Databases list activity by database. All database partition information is aggregated to the database level.
Database Comparison
The following table describes the information displayed in the General tab.
Table 5-11 General tab
Column Description
Database Name of the database where the statement is running
...
Sessions Number of sessions
The following table describes the information displayed in the In DB2 tab.
Table 5-12 In DB2 tab
Column Description
Database Name of the database where the statement is running
...
Utility Active In DB2 breakdown description
The following table describes the information displayed in the Statistics tab.
Table 5-13 Statistics tab
Column Description
Database Name of the database where the statement is running
...
Internal Row Affected Number of internal rows affected
Selected Database
The following table describes the information displayed in the Over Time tab.
Table 5-14 Over Time tab
Item Description
In DB2 (Summed) The In DB2 breakdowns over time
...
Sessions Number of sessions
Table 5-14 Over Time tab
Item Description
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
The following table describes the information displayed in the Overview tab.
Table 5-15 Overview tab
Item Description
Details Detailed activity information
...
Statistics Statistic counters overview
The following table describes the information displayed in the Statistics tab.
Table 5-16 Statistics tab
Item Description
Rows Read/Written Number of rows read/written
...
Locks Number of lock escalations and lock timeouts over time
The following table describes the information displayed in the Storage tab.
...