Collector for SAP Lock entries (SM12)

The technical name of the Collector for SAP Lock Entries (SM12) is /DVD/MON_CL_COL_LOCKS.

This collector collects information about existing lock entries (SM12) on the system. By default, it collects all lock entries, but you can customize the scope of the lock monitoring via the input table.

Default KPIs Delivered with This Collector

The following default KPIs are delivered with this collector:

KPI name

Description

Unit

Detail table

LOCK_LONGEST_DURATION

Duration of the longest lock entry

Hours

No

LOCK_NUM_ALL

Number of all existing lock entries

Number

No

LOCK_NUM_ALL_SPECIFIC

Number of all existing lock entries specified in inputs

Number

Yes

LOCK_NUM_LONG_RUNNING

Number of lock entries exceeding the time limit

Number

Yes

LOCK_NUM_MODE_E

Number of exclusive locks (lock mode E)

Number

Yes

LOCK_NUM_MODE_O

Number of optimistic locks (lock mode O)

Number

Yes

LOCK_NUM_MODE_S

Number of shared locks (lock mode S)

Number

Yes

LOCK_NUM_MODE_X

Number of exclusive, non-cumulative locks (lock mode X)

Number

Yes

Input Table

The collector uses the input table /DVD/MON_LOCK_I, where you can specify what type of locks will be processed and output as KPI values and displayed in the detail table /DVD/MON_T_LOCK_DETAIL.

NOTE Wildcards are supported for the fields Client, Table name and Lock argument. If you leave the input table /DVD/MON_LOCK_I empty, all existing lock entries are included in the monitoring.

Technical name

Column name 

Description

KPI_RULE_NUMBER

KPI rule number

Sequence of rules. To add a new rule, always increment the previous KPI rule number.

GCLIENT

Client

Client for the lock entry. You can use the wildcard * in this field.

If you use the wildcard *, existing lock entries on all clients will be processed.

GNAME

Table name

Table name for a lock entry. You can use the wildcard * in this field.

If you use the wildcard *, existing lock entries for all tables will be processed.

GTARG

Lock argument

Lock argument for a lock entry. You can use the wildcard * in this field.

If you use the wildcard *, existing lock entries with any lock arguments will be processed.

TIMELIMIT

Time [min]

Time limit in minutes for long-existing locks. If any lock entry exists longer than this time limit, it is included in the KPI that calculates the number of lock entries exceeding the time limit.

PRIORITY

Rule priority

Rule priority. Rules with a higher priority are processed first.

ADD_TO_DETAIL

Add to details

If a relevant lock entry matches this rule, its additional information is added to the detail table (if this field set to X). If this field is set to space, no additional information about lock entry is reported in the detail table.

AGGR_TO_DETAIL

Aggregate to details

If a relevant lock entry matches this rule, its additional information is added to the detail table. This occurs in either aggregation mode (set to X) or non-aggregation mode (set to <empty>).

Aggregation mode: Lock entries are aggregated into the detail table per Client, Host, Table name and Lock mode. If more records with the same aggregation field values exist, the lock count for this record is incremented in the detail table.

Non-aggregation mode: Lock entries are not aggregated. All existing lock entries that match the rule criteria are reported in the detail table as separate records. One lock entry in SM12 represents one record in the detail table.

REPORT_ONCE

Only once

Report the same entry in the detail table:

  • X: Report the same lock entry only once.

  • <empty>: Report the same lock entry after every collector execution in the detail table.

ACTIVE

Active

Whether this rule is active X or not <empty>.

Detail Table

The collector provides the detail table Lock entries (SM12). The technical name of the detail table is /DVD/MON_T_LOCK_DETAIL.

The detail table Lock entries (SM12) reports all existing lock entries based on the configured custom rules in the input table. By default, if you do not define any inputs, all lock entries are processed in the detail table in aggregation mode. Records in the detail table are aggregated per Client, Host, Table name and Lock mode. It contains the following fields:

Technical name

Description

TIMESTAMP

Time when the records are saved to the detail table

SID

System ID

CLIENT

Client in the lock entry

HOST

Host name in the lock owner ID

TABLE_NAME

Elementary lock of the lock entry (table name)

LOCK_MODE

Lock mode of a lock entry. Possible values: Shared; Exclusive

AGGREGATED

Lock entry: Whether the lock is aggregated

LOCKS_COUNT

Lock entry: Number of aggregated records

LOCK_ARG

Argument string (key fields) of the lock entry

START_TIME

Lock entry: Start timestamp

UNAME

Username in the lock entry

AVG_DURATION

Lock entry: Average duration in minutes

MAX_DURATION

Lock entry: Maximum duration in minutes