Output of Shredding
After shredding the output of the DBQLXMLLockTbl XMLTextInfo column in Shredded_LockTbl and joining it with the shredded output of Shredded_TransTbl, the result looks like this.
The GlobalDeadLock field has a TRUE value, showing a global deadlock condition.
*** Query completed. 6 rows found. 31 columns returned.
*** Total elapsed time was 1 second.
QUERYID 307184741735817865.
Lock_DatabaseName DB1
Lock_TableName TVFields
Lock_UserName USER2
Lock_AccountName ?
Lock_MessageClass 21
Lock_MessageKind 11
Lock_MessageClassName SYSMSGS2SCLASS
Lock_MessageKindName AAR
Lock_WorkLevel 128
Lock_OperationType Asynch Abort Release lock message
Lock_JobType AmpStep
Lock_LockTypeRequested Read4W
Lock_LockObjectRequested R
Lock_BlockedLockTypeRequested Write
Lock_BlockedLockObjectRequested T
Lock_LockDelay 26400.
Lock_LocalDeadLock false
Lock_GlobalDeadLock true
Lock_MultipleBlocker true
Lock_ErrorText Amp deadlocking
Lock_AbortFlag TRUE
Lock_ErrorCode 2631
COMMON QUERYID 307184741735817865.
Trans_DatabaseName ?
Trans_TableName ?
Trans_unique_1 ?
Trans_unique_2 ?
Trans_PEVproc ?
Trans_LockTypeRequested Write
Trans_LockObjectRequested R
QUERYID 307184741735817865.
Lock_DatabaseName DB1
Lock_TableName TVFields
Lock_UserName USER2
Lock_AccountName ?
Lock_MessageClass 21
Lock_MessageKind 11
Lock_MessageClassName SYSMSGS2SCLASS
Lock_MessageKindName AAR
Lock_WorkLevel 128
Lock_OperationType Asynch Abort Release lock message
Lock_JobType AmpStep
Lock_LockTypeRequested Write
Lock_LockObjectRequested R
Lock_BlockedLockTypeRequested Write
Lock_BlockedLockObjectRequested T
Lock_LockDelay 26400.
Lock_LocalDeadLock false
Lock_GlobalDeadLock true
Lock_MultipleBlocker true
Lock_ErrorText Amp deadlocking
Lock_AbortFlag TRUE
Lock_ErrorCode 2631
COMMON QUERYID 307184741735817865.
Trans_DatabaseName ?
Trans_TableName ?
Trans_unique_1 ?
Trans_unique_2 ?
Trans_PEVproc ?
Trans_LockTypeRequested Write
Trans_LockObjectRequested R
QUERYID 307184741735817865.
Lock_DatabaseName DB1
Lock_TableName TVFields
Lock_UserName USER2
Lock_AccountName ?
Lock_MessageClass 21
Lock_MessageKind 11
Lock_MessageClassName SYSMSGS2SCLASS
Lock_MessageKindName AAR
Lock_WorkLevel 128
Lock_OperationType Asynch Abort Release lock message
Lock_JobType AmpStep
Lock_LockTypeRequested Read4W
Lock_LockObjectRequested R
Lock_BlockedLockTypeRequested Write
Lock_BlockedLockObjectRequested T
Lock_LockDelay 26400.
Lock_LocalDeadLock false
Lock_GlobalDeadLock true
Lock_MultipleBlocker true
Lock_ErrorText Amp deadlocking
Lock_AbortFlag TRUE
Lock_ErrorCode 2631
COMMON QUERYID 307184741735817865.
Trans_DatabaseName DB1
Trans_TableName TVFields
Trans_unique_1 14
Trans_unique_2 61610
Trans_PEVproc 30719
Trans_LockTypeRequested Write
Trans_LockObjectRequested R
QUERYID 307184741735817865.
Lock_DatabaseName DB1
Lock_TableName TVFields
Lock_UserName USER2
Lock_AccountName ?
Lock_MessageClass 21
Lock_MessageKind 11
Lock_MessageClassName SYSMSGS2SCLASS
Lock_MessageKindName AAR
Lock_WorkLevel 128
Lock_OperationType Asynch Abort Release lock message
Lock_JobType AmpStep
Lock_LockTypeRequested Write
Lock_LockObjectRequested R
Lock_BlockedLockTypeRequested Write
Lock_BlockedLockObjectRequested T
Lock_LockDelay 26400.
Lock_LocalDeadLock false
Lock_GlobalDeadLock true
Lock_MultipleBlocker true
Lock_ErrorText Amp deadlocking
Lock_AbortFlag TRUE
Lock_ErrorCode 2631
COMMON QUERYID 307184741735817865.
Trans_DatabaseName DB1
Trans_TableName TVFields
Trans_unique_1 14
Trans_unique_2 61610
Trans_PEVproc 30719
Trans_LockTypeRequested Write
Trans_LockObjectRequested R
QUERYID 307184741735817865.
Lock_DatabaseName DB1
Lock_TableName TVFields
Lock_UserName USER2
Lock_AccountName ?
Lock_MessageClass 21
Lock_MessageKind 11
Lock_MessageClassName SYSMSGS2SCLASS
Lock_MessageKindName AAR
Lock_WorkLevel 128
Lock_OperationType Asynch Abort Release lock message
Lock_JobType AmpStep
Lock_LockTypeRequested Read4W
Lock_LockObjectRequested R
Lock_BlockedLockTypeRequested Write
Lock_BlockedLockObjectRequested T
Lock_LockDelay 26400.
Lock_LocalDeadLock false
Lock_GlobalDeadLock true
Lock_MultipleBlocker true
Lock_ErrorText Amp deadlocking
Lock_AbortFlag TRUE
Lock_ErrorCode 2631
COMMON QUERYID 307184741735817865.
Trans_DatabaseName DB1
Trans_TableName TVFields
Trans_unique_1 14
Trans_unique_2 61610
Trans_PEVproc 30719
Trans_LockTypeRequested Write
Trans_LockObjectRequested R
QUERYID 307184741735817865.
Lock_DatabaseName DB1
Lock_TableName TVFields
Lock_UserName USER2
Lock_AccountName ?
Lock_MessageClass 21
Lock_MessageKind 11
Lock_MessageClassName SYSMSGS2SCLASS
Lock_MessageKindName AAR
Lock_WorkLevel 128
Lock_OperationType Asynch Abort Release lock message
Lock_JobType AmpStep
Lock_LockTypeRequested Write
Lock_LockObjectRequested R
Lock_BlockedLockTypeRequested Write
Lock_BlockedLockObjectRequested T
Lock_LockDelay 26400.
Lock_LocalDeadLock false
Lock_GlobalDeadLock true
Lock_MultipleBlocker true
Lock_ErrorText Amp deadlocking
Lock_AbortFlag TRUE
Lock_ErrorCode 2631
COMMON QUERYID 307184741735817865.
Trans_DatabaseName DB1
Trans_TableName TVFields
Trans_unique_1 14
Trans_unique_2 61610
Trans_PEVproc 30719
Trans_LockTypeRequested Write
Trans_LockObjectRequested R