Previous Topic: Database LocksNext Topic: SQL Processing


Longterm Locks

Useful Statistics to Monitor

Statistic

Meaning

Possible action

Tasks having areas locked

Shows which tasks have areas locked

Use this information to identify tasks that ready an area in protected or exclusive mode, since this increases the potential for throughput degradation

Longterm/ notify locks

Displays longterm or notify lock statistics by logical terminal

Use this information to identity tasks that hold a large number of longterm and/or notify locks

Where the Statistics are Reported