Page History
...
- About the Current tab
- How the Current tab is structured
- About examining entities in the Current tab
- How the Current tag can help you identify performance problems
Anchor | ||||
---|---|---|---|---|
|
...
In the Current tab, data on a current application is continuously updated to provide information on what happened during the last minute or time slice. Because the displayed application information is derived from a dynamic application, it is recommended to regularly refresh the screen, either manually or automatically, to ensure that the information displayed is up-to-date.Note:
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 worked at your screen for ten 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 currently held locks” on page 38 and “Getting an overview of your application” on page 23.
...
From the Association area, you can also drill down to another entity by clicking a table row. A drilldown drill-down affects the entire tab. When you drill down to another entity, the Tab heading displays the new selection, the Main area displays information on the newly selected entity, and the Association area displays the entities associated with the selected entity.
...
The following entities can be examined in the Current tab:
- About the Database Partition
- About the Application entity
- About the Application Holding Locks entity
- About the Statement entity
Anchor | ||||
---|---|---|---|---|
|
Displays information on the activity and resource consumption of the database, including the number of applications connected to the database during the last sample taken and the database resource consumption breakdown for the last minute.
About getting an overview of current Database activities
Displays information on the activity and resource consumption of the database, including the number of applications connected to the database during the last sample taken and the database resource consumption breakdown for the last minute.
...
Note: All the information displayed in this table represents information collected during the last minute, with the exception of the Applications column, which represents the number of applications, in the last sample, that were in a particular state.
About viewing Database locks
Displays lock wait duration for the selected Database during the last minute. The applications that are currently involved in a locking or blocking situation are displayed in tree format.
...
The Lock Tree displays the application handle, program name, the object being blocked and the lock type.
Anchor | ||||
---|---|---|---|---|
|
Displays information on a single connection with Microsoft SQL Server. Precise for SQL Server identifies an application by the following attributes:
...
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 fact that a currently active application is holding a resource does not necessarily mean that there is a contention between resources. The Application Holding Locks entity displays information that lets you differentiate between applications that are locking resources and applications that are holding resources.
About getting an overview of current applications holding locks
Displays information on the application identifier, including connection details, application-related statistics and a breakdown of application resource consumption, during the last minute.
...
■ Machine
■ Module
■ Action
About viewing information on the lock breakdown of an application that is holding locks
The Locks view displays lock wait duration broken down into lock levels such as Table, Page and Key, for the selected application, during the last minute.
...
Note that an application may also block other applications while being blocked by itself.
About viewing the text of an application that is holding locks
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 Statement entities display information on an SQL statement that is executed by the selected application during the last time slice.
About getting an overview of current Statement entities
Displays general information on the statement, including overall properties, its breakdown In DB2 during the last time slice, and the breakdown of the locks during the last time slice.
...
■ Lock Wait
■ I/O Error Wait
About viewing current Statement text
Displays text of the selected statement.
Anchor | ||||
---|---|---|---|---|
|
You can identify a performance problem by doing one or more of the following:
...