Return
-
Title
"Attributes" column in Locks Held for Locks tab -
Description
What does the "Attributes" column in the Locks tab of Client Application Analysis stand for and how is it collected and what is the meaning of 'RR'? See screenshot attached.
-
Resolution
"Attributes" refers to the properties of the application holding the lock. Spotlight gets the metric from the SNAP_GET_LOCK table function. This monitor element and the table function has been deprecated, and should probably be removed from Spotlight and replaced with the most current metric.
You can look up all the possible values in the DB2 doc at http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jspRR means an application has an open cursor on a table.