Identifiers Used in Locking
Note: For an introduction to the Locking report set and general locking
information refer to the Reporting User's Guide.
In addition to the standard OMEGAMON for Db2® Performance Expert identifiers, Locking reports and traces use two other identifiers to show the type of resource and event type:
- RESOURCETYPE-Resource type
- The type of lock resource. You can specify one of the values shown in Table 1.
- TYPE-Event type
- Specifies which event types are to be included in, or excluded
from, the lock detail trace. The valid values for this field are
shown in Table 1.
Table 1. Event Types Type Events IRLMREQ Lock, unlock, change, query, and notify requests CLAIMREQ Claim acquire, claim change, and claim release DRAINREQ Drain request and drain release PLOCKREQ Page set or partition as well as page P-Lock requests IRLMSUSP The beginning of lock, unlock, change, query, and notify suspensions DRAINSUSP The beginning of drain suspensions LATCHSUSP The beginning of page latch suspensions IRLMRES The end (resumption) of lock, unlock, change, query, and notify suspensions DRAINRES The end (resumption) of drain suspensions LATCHRES The end (resumption) of page latch suspensions TIMEOUT Timeouts DEADLOCK Deadlocks LOCKSUMMARY Lock summary events LOCKAVOID Successful lock avoidance events The default is all event types.
Note: TYPE can also be used with the REDUCE and FILE subcommands of locking. These subcommands support a limited number of types, as follows:- Valid types for REDUCE are: IRLMRES, DRAINRES, and LATCHRES.
- Valid types for FILE are: IRLMREQ, CLAIMREQ, DRAINREQ, and LOCKAVOID.
If a non-valid type for REDUCE or FILE is used with EXCLUDE, the event type is not filtered.
If no valid types for REDUCE or FILE are used with INCLUDE, an empty report or file is produced.