Lock Detail (8.0)
- Organization of this page
Overview
The Lock Detail (8.0) report displays detailed information related to each lock. This report is displayed as a list. It is a drilldown report. From the displayed drilldown report, you can display more detailed drilldown reports.
Storage location
Reports/SQL/Troubleshooting/Real-Time/Drilldown Only/
Record
Lock Detail (PD_LD)
Fields
|
Field name |
Description |
|---|---|
|
Blocking Flag |
This flag indicates whether or not the lock is a blocking lock. The following values are valid:
|
|
DB Name |
Database name related to lock resource |
|
DBID |
Database ID related to lock resource |
|
Demand Flag |
This flag indicates whether or not the lock is a request lock. The following values are valid:
|
|
Lock Type |
Lock type (lock request mode and lock resource type) |
|
Orphan Flag |
This flag indicates whether or not the lock is an isolated lock. The following values are valid:
|
|
Page # |
Number of pages allocated to lock resource |
|
Program |
Name of the application program that is requesting the lock |
|
SPID |
Process ID that is requesting the lock |
|
Table |
Table name if the lock resource is a table or row |
|
User |
Logon name of the user who issued the command |
Drilldown reports (field level)
|
Report name |
Description |
|---|---|
|
Session Detail (8.0) |
Displays detailed information related to resource usage in each session. To display this report, click the SPID field. |