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