17.00 - 17.05 - シュレッディングの出力 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - データベースの管理

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
2020年6月
Content Type
管理
Publication ID
B035-1093-170K-JPN
Language
日本語 (日本)

Shredded_LockTblでDBQLXMLLockTblのXMLTextInfo列の出力をシュレッディングし、それをShredded_TransTblのシュレッドされた出力と結合すると、結果は次のようになります。

GlobalDeadLockフィールドには、グローバル デッドロックの状態を示すTRUE値があります。

*** 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