Output of Shredding | Teradata Vantage - 17.00 - 17.05 - Output of Shredding - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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