Converse agora com nosso suporte
Chat com o suporte

Spotlight on DB2 6.9.3 - Getting Started Guide

Client Application Analysis drilldown Locks tab

The Locking tab on the Client Application Analysis drilldown provides details about each lock that the application currently holds and each lock on which the application is waiting. This information can help you pinpoint deadlocks that this application is causing or experiencing. You can also determine whether this application is reaching the maximum number of locks available to it.

Application identification

These details identify the application:

Auth ID

Appl Name

Agent ID

If you want Spotlight to collect and display information on the Locking tab for all applications, select Collect lock information for all applications. Otherwise, the Locking tab shows lock information for the currently selected application only.

Locks Held information

The Locks Held list grid shows the total of number of locks the application is holding and provides the following information about each lock. Since you can choose to hide, display, or rearrange any column in the grid, some columns below might not appear in your current list view, or be in the order in which they are shown here.

Lock Mode

Object ID

Object Type

Lock Status

Table Schema

Escalated

Table Name

Freeze First Column

Tablespace

 

Use this information to determine the locations and types of locks being held and whether the application is reaching the maximum number of locks available to it.

Locks Waiting information

The Locks Waiting list grid shows the total number of locks on which the application is waiting and provides the following information about each of these locks. Since you can choose to hide or display any column in the grid, some columns below might not appear in your current list view.

Lock Mode

Tablespace

Object Type

Holder's Agent ID

Table Schema

Holder's App ID

Table Name

Freeze First Column

Use this information to determine both the sources of contention in the database and the applications in contention for these sources.

 

Related topics

 

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação