...
Log into the managed system and execute the dbacockpit transaction code. Expand the Diagnostics menu option on the left side of the screen and double-click the Deadlock Monitor option. The information displayed will match the data that is extracted and sent to Splunk.
...
Field Mapping
...
Field
...
Description
...
Unit of Measure
...
ABAPLOCAT
...
Offset of a Processing Control Block
...
Number
...
ABAPREPORT
...
Name of the ABAP report
...
String
...
CURRENT_TIMESTAMP
...
The date time stamp when the information was collected
...
YYYYMMDDHHMMSS
...
EVENT_SUBTYPE
...
String
...
EVENT_TYPE
...
MSS_DB02_DDLK
...
String
...
HOSTNAME
...
Name of the Host Server
...
String
...
HOSTPID
...
Process ID on app. server
...
Number
...
MESSAGE
...
Deadlock message
...
String
...
OCCURTSTMP
...
Timestamp for deadlock tracking
...
YYYYMMDDHHMMSS
...
SEQ
...
Deadlock sequence number
...
Number
...
SPID
...
MS SQL Server process ID
...
Number
...
SPNAME
...
Stored procedure name
...
String
...
TCODE
...
Transaction code
...
String
...
TNAME
...
Table name
...
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.
...
+ | -
...
WINNER
...
Survivor of deadlock flag
...
Boolean
...
WP_NUM
...
Work process number
...
Number
...
WP_TYPE
...
Work process type
...
String