Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Determine overview of locked objects(tables) i.e. lock types, SAP Server locking the objectsobject type, object name, etc.

  • Monitor to determine if critical objects(tables) are locked and send alerts

  • Determine how frequently the critical objects are locked

  • Can be used to find which Transactions lock critical objects and schedule the execution of such transactions accordingly

...

Log in to the SAP system (having a HANA database) and execute the transaction DB01. Navigate to Diagnostics->Locks->Object Locks and currently locked objects will be displayed.

...

Field Mapping

...

Field

...

Description

...

Unit of Measure

...

EVENT_TYPE

...

SECPOL_LOG

...

String

...

EVENT_SUBTYPE

...

Not Applicable for this Event Type (always blank)

...

String

...

CURRENT_TIMESTAMP

...

The date time stamp when the information was collected

...

YYYYMMDDHHMMSS

...

HOST

...

Host Name

...

String

...

PORT

...

Internal Port

...

String

...

LOCK_OWNER_TRANSACTION_ID

...

Transaction object ID owning the lock

...

String

...

LOCK_OWNER_UPDATE_TRANSACTION_

...

Write transaction ID owning the lock

...

String

...

ACQUIRED_TIME

...

Lock acquisition time

...

YYYYMMDDHHMMSS

...

OBJECT_OID

...

Object OID

...

String

...

SCHEMA_NAME

...

Schema Name

...

String

...

OBJECT_NAME

...

Object Name

...

String

...

OBJECT_TYPE

...

Object Type

...

String

...

LOCK_MODE

...

Lock mode: EXCLUSIVE, INTENTIONAL EXCLUSIVE

...

String

...

UTCDIFF

...

The UTC OFFSSET in HHMMSS that the data was collected in

...

HHMMSS

...

UTCSIGN

...

The UTC positive or negative OFFSET indicator. Positive (+) means add UTCDIFF to find the time zone of the data, negative (-) means subtract the UTCDIFF to find the time zone adjusted date time the data was collected in.

...