The following figure shows the deadlock information that is output.

Figure 8-7 Deadlock information that is output

The following explains the deadlock information that is output:

1. deadlock-detection-date-and-time
   Displays the date and time (mmm dd hh:mm:ss yyyy) when HiRDB detected the deadlock.
   

   Information on the server that sent the transaction that resulted in deadlock

   Items 2 to 14 provide information about the first resource that was occupied by the transaction that resulted in the deadlock.

2. UAP-identification-information
   Displays the identification name of the UAP connected to the server that sent the transaction that resulted in the deadlock.
   The information displayed here corresponds to the PROGRAM information displayed by the pdls -d prc or pdls -d trn command. Some utilities cannot display this information; in this case, ******** is displayed. Rerun is displayed for a transaction that is being restored during restart processing.
   
3. server-name
   Displays the name of the server that sent the transaction that resulted in the deadlock.
   
4. process-ID
   Displays the ID of the server process that sent the transaction that resulted in the deadlock.
   
5. transaction-identifier
   Displays the identifier of the transaction that resulted in the deadlock.
   If the identifier begins with _cmd, the lock was secured by the pdhold command. If the identifier begins with _utl, the lock was secured by the pdcopy command.
   

   Information about all resources occupied by the transaction that resulted in deadlock

   Items 6 to 9 provide information about all resources occupied by the transaction that caused the deadlock. If this transaction did not occupy any resources, these items are left blank.

6. server-name
   Displays the name of the server used by the transaction that resulted in the deadlock to issue the resource occupancy request.
   
7. lock-mode
   Displays the lock mode applied to the resource that was occupied by the transaction that resulted in the deadlock. For details on the lock modes, see the HiRDB Version 9 UAP Development Guide.
   
8. occupied-resource-type
   Displays the type of resource that was occupied by the transaction that resulted in the deadlock. For details on the resource types, see 8.6.4 Resource types and resource information.
   
9. occupied-resource-information
   Displays information about the resource that was occupied by the transaction that resulted in the deadlock. For details on the resource information, see 8.6.4 Resource types and resource information.
   

   Information about the resource that caused the transaction that resulted in the deadlock to be placed in lock-release wait status

   Items 10 to 14 provide information about the resource that caused the deadlock.

10. server-name
    Displays the name of the server used by the transaction that resulted in the deadlock to issue the resource occupancy request.
    
11. lock-mode
    Displays the lock mode the transaction that resulted in the deadlock attempted to apply to the resource in lock-release wait status. For details on the lock modes, see the HiRDB Version 9 UAP Development Guide.
    
12. locked-resource-type
    Displays the type of resource that caused the transaction that resulted in the deadlock to be placed in lock-release wait status. For details on the resource types, see 8.6.4 Resource types and resource information.
    
13. locked-resource-information
    Displays information about the resource that caused the transaction that resulted in the deadlock to be placed in lock-release wait status. For details on the resource types, see 8.6.4 Resource types and resource information.
    
14. lock-occurrence-time
    Displays the time (hh:mm:ss) the transaction that resulted in the deadlock was placed in lock-release wait status.
    

    Information about the server that sent the transaction involved in deadlock

    Items 15 to 29 provide information about the first resource that was occupied by the transaction involved in the deadlock. This information might be output more than once.

15. UAP-identification-information
    Displays the identification name of the UAP connected to the server that sent the transaction involved in the deadlock.
    The information displayed here corresponds to the PROGRAM information displayed by the pdls -d prc or pdls -d trn command. Some utilities cannot display this information; in this case, ******** is displayed. Rerun is displayed for a transaction that is being restored during restart processing.
    
16. server-name
    Displays the name of the server that sent the transaction involved in the deadlock.
    
17. process-ID
    Displays the ID of the server process that sent the transaction involved in the deadlock.
    
18. transaction-identifier
    Displays the identifier of the transaction involved in the deadlock.
    

    Information about all resources occupied by the transaction involved in deadlock

    Items 19 to 22 provide information about all resources that caused the deadlock. If this transaction did not occupy any resources, these items are left blank.

19. server-name
    Displays the name of the server used by the transaction involved in the deadlock to issue the resource occupancy request.
    
20. lock-mode
    Displays the lock mode applied to the resource that was occupied by the transaction involved in the deadlock. For details on the lock modes, see the HiRDB Version 9 UAP Development Guide.
    
21. occupied-resource-type
    Displays the type of resource that was occupied by the transaction involved in the deadlock. For details on the resource types, see 8.6.4 Resource types and resource information.
    
22. occupied-resource-information
    Displays information about the resource that was occupied by the transaction involved in the deadlock. For details on the resource information, see 8.6.4 Resource types and resource information.
    

    Information about the resource that caused the transaction involved in the deadlock to be placed in lock-release wait status

    Items 23 to 29 provide information about the resource that caused the deadlock.

23. server-name
    Displays the name of the server used by the transaction involved in the deadlock to issue the resource occupancy request.
    
24. lock-mode
    Displays the lock mode the transaction involved in the deadlock attempted to apply to the resource in lock-release wait status. For details on the lock modes, see the HiRDB Version 9 UAP Development Guide.
    
25. locked-resource-type
    Displays the type of resource that caused the transaction involved in the deadlock to be placed in lock-release wait status. For details on the resource types, see 8.6.4 Resource types and resource information.
    
26. locked-resource-information
    Displays information about the resource that caused the transaction involved in the deadlock to be placed in lock-release wait status. For details on the resource types, see 8.6.4 Resource types and resource information.
    
27. lock-occurrence-time
    Displays the time (hh:mm:ss) the transaction involved in the deadlock was placed in lock-release wait status.
    
28. user-identifier
    Displays the sequence numbers assigned dynamically by HiRDB to identify the individual user.
    
29. deadlock-priority-value
    Displays the deadlock priority value for the transaction that resulted in the deadlock.
    

The following figure shows an output example of deadlock information.

Figure 8-8 Output example of deadlock information