Output of Shredding | Teradata Vantage - Output of Shredding - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

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