Page History
...
Anchor | ||||
---|---|---|---|---|
|
The Current tab displays near real-time information on all applications that were connected to your DB2 database during the last minute or, in the Application context, from the beginning of the time slice. If you have discerned an immediate performance issue and are looking for an indication as to where to begin your analysis, start with the Current tab. It is also worthwhile to start with the Current tab if your system appears to be 'hung' and there is no throughput.
You can use this tab to monitor your system’s system's current activities and resource consumption and to identify performance problems, such as current locking problems and applications involved in locks, as they occur.
...
Info |
---|
The Current tab displays information on the last minute of activity or, in the Application context, from the beginning of the time slice. For example, if you’ve you've worked at your screen for ten 10 minutes and then refresh the information displayed on your screen, you will be able to view new information that occurred during the last minute of activity or from the beginning of the time slice in the Application context. |
See “Analyzing Analyzing currently held locks” on page 38 and “Getting locks and Getting an overview of your application” on page 23application.
Anchor | ||||
---|---|---|---|---|
|
...
If you want to view detailed information on a specific application holding lock, click the row of the applications holding locks you want to view detailed information for. The Tab heading indicates the newly selected entity; the Main area displays locking and In DB2 information on the application you drilled down to, and the Association area shows information on the statements associated with this application.
See “Precise Precise for DB2 basics” on page 14 and “Getting basics and Getting an overview of your application” on page 23application.
Anchor | ||||
---|---|---|---|---|
|
...
The following table describes the information displayed in the Database Overview view.
Table 4- 1 Database Overview view
View area | Description | ||
---|---|---|---|
Application | Displays the following application-related information:
| ||
In DB2 | Displays the resource consumption breakdown of the database during the last minute or, in the Application context, from the beginning of the time slice. In addition to the resource distribution, the view displays the number of applications in each state during the last sample. The following information is displayed:
|
About viewing Database locks
...
Info |
---|
Since the Lock tree represents the locks that are currently occurring, and the lock breakdown represents the duration of locks occurring during the last minute, it is possible that a situation may occur whereby a lock was freed, but since the last minute has not yet passed, the lock tree will display the message ‘No , "No locks detected' ," while the Lock Breakdown grid still shows lock duration. |
The following table provides a detailed explanation of the Lock Tree
Table 4- 2 Database Locks view
View area | Description |
---|---|
Lock tree | It is important to determine the following information for each blocking chain:
The Lock Tree provides the necessary information to get to the root of the problem by providing information on applications currently involved in the blocking situation. A yellow lock indicates that the application is currently locking other applications but is not itself blocked. A red lock indicates the application is currently blocked by another application. Note that an application application may also block other applications while being blocked by itself. To gain a better understanding of the lock tree take a closer look at its structure. Notice that the application located in the root of each chain is the application that blocks all others. Each application directly blocks all applications positioned one level beneath it. The Lock Tree displays the application handle, program name, the object being blocked and the lock type. |
Anchor | ||||
---|---|---|---|---|
|
...
When one of these attributes changes, a new application is recorded and displayed. The following table describes the information displayed in the Application overview.
Table 4- 3 Application Overview
View area | Description |
---|---|
Application tab | Displays the following information:
|
In DB2 tab (last minute) | Displays the resource consumption breakdown of the application during the last minute (that is, 60 samples of the Collector). In addition to the resource distribution, the view displays the number of applications in each state during the last sample. It is important to remember that since this view only displays the last minute's activities, you will always be viewing the activities that occurred during the last minute and not the activities that occurred since the last refresh action. The following information is displayed:
|
Connection tab | A connection includes application identifiers such as User, Login, and Machine. The following information is displayed:
|
The following table describes the information displayed in the Application Text view.
Table 4-4 Application Text view
View area | Description |
---|---|
Text | Displays the text of the current statement. If the application is not active and executing a statement, a message notifying you that the application is not active and that no text is available is displayed. |
Anchor | ||||
---|---|---|---|---|
|
...
The following table describes the information displayed by the Application Holding Locks overview.
Table 4- 5 Applications Holding Locks overview
View area | Description |
---|---|
Application tab | Displays the following information:
|
In DB2 tab (last minute) | Displays the resource consumption breakdown of the application during the last minute (that is, 60 samples of the Collector). In addition to the resource distribution, the view displays the number of applications in each state during the last sample. It is important to remember that since this view only displays the last minute's activities, you will always be viewing the activities that occurred during the last minute and not the activities that occurred since the last refresh action. The following information is displayed:
|
Connection tab | A connection includes application identifiers such as User, Login, and Machine. The following information is displayed:
|
About viewing information on the lock breakdown of an application that is holding locks
...
The Lock Tree displays the SPID, program name, the object being blocked and the lock type. The following table describes the information displayed in this view.
Table 4- 6 Locks view for the Application Holding Locks entity
View area | Description | ||
---|---|---|---|
Lock Tree | The Lock tree provides the necessary information to determine the following information for each blocking chain:
|
About viewing the text of an application that is holding locks
...
The following table describes the information displayed in the Statement Overview view.
Table 4- 7 Statement Overview view
View area | Description |
---|---|
General tab |
|
In DB2 (Last minute) | The following information is displayed:
|
About viewing current Statement text
...
- In the database partition list, choose the item you want to analyze.
- On the View controls in the Main area, click Locks and examine the locking contentions. Move the cursor over the locked application in the tree to display the text of the locked application.
...
Precise. Performance intelligence from click to storage. Learn more > >
...
Newtabfooter |
| |||||||||||
Newtabfooter | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...