16.10 - Output of Shredding - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

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