5. Monitoring Lock Information : Resource Lock Display Screen
 
Share this page                  
Resource Lock Display Screen
The Resource Lock Display screen is displayed when you select Resource_Info from the Lock Detail Display screen. All the locks held on the resource related to the lock specified on the Lock Detail Display screen are displayed.
If the specified lock belonged to page 0 of the foo table, the Resource Lock Display screen displays all locks held on that same resource (page 0, foo table).
For example, if the specified lock is a table lock, it is useful to see what other locks are held on that table because it is an indication of how much activity is occurring there.
The Resource Lock Display has the following items:
Resource ID
Resource block identifier of the resource on which the blocking lock is held
Resource Type
Type of resource. For a list of resource types, see Resource Type--Display Specific Resource.
Convert
Mode to which this resource is converting. For a list of possible modes, see Mode Values.
Granted
Mode in which this resource is granted. For a list of possible modes, see Mode Values.
DB Name
Name of the database
Table
Table name to which this resource belongs. If the resource is not a table or page resource type, this field does not appear.
Page
Page number of this resource. If the resource is not a page resource type, this field does not appear.