Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

8.6.3 Timeout information that is output

The following figure shows the timeout information that is output.

Figure 8-9 Timeout information that is output

[Figure]

The following explains the timeout information that is output:

  1. timeout-detection-date-and-time
    Displays the date and time (mmm dd hh:mm:ss yyyy) when HiRDB detected the timeout.
    Information on the server that sent the transaction that resulted in the timeout
    Items 2 to 13 provide information about the first resource that was occupied by the transaction that resulted in the timeout.
  2. UAP-identification-information
    Displays the identification name of the UAP connected to the server that sent the transaction that resulted in the timeout. If the transaction was sent by a utility, the name of the utility is displayed.
    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 timeout.
  4. process-ID
    Displays the ID of the server process that sent the transaction that resulted in the timeout.
  5. transaction-identifier
    Displays the identifier of the transaction that resulted in the timeout.
    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 the timeout
    Items 6 to 9 provide information about all resources occupied by the transaction that caused the timeout. 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 timeout to issue the resource occupancy request.
  7. lock-mode
    Displays the type of lock mode applied to the resource that was occupied by the transaction that resulted in the timeout. 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 timeout. 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 timeout. 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 timeout to be placed in lock-release wait status
    Items 10 to 13 provides information about the resource that caused the transaction that resulted in the timeout to be placed in lock-release wait status.
  10. server-name
    Displays the name of the server used by the transaction resulting in the timeout to issue the resource occupancy request.
  11. lock-mode
    Displays the lock mode the transaction that resulted in the timeout 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 timeout 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 timeout to be placed in lock-release wait status. For details on the resource types, see 8.6.4 Resource types and resource information.
    Information about the server that sent the transaction that caused the timeout
    Items 14 to 27 provide information about the first resource that was occupied by the transaction that caused the timeout. This information might be output more than once.
  14. UAP-identification-information
    Displays the identification name of the UAP connected to the server that sent the transaction that caused the timeout. If the transaction was sent by a utility, the name of the utility is displayed.
    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.
  15. server-name
    Displays the name of the server that sent the transaction that caused the timeout.
  16. process-ID
    Displays the ID of the server process that sent the transaction that caused the timeout.
  17. transaction-identifier
    Displays the identifier of the transaction that caused the timeout.
    Information about all resources occupied by the transaction that caused the timeout
    Items 18 to 21 provide information about all resources that caused the timeout. If this transaction did not occupy any resources, these items are left blank.
  18. server-name
    Displays the name of the server used by the transaction that caused the timeout to issue the resource occupancy request.
  19. lock-mode
    Displays the lock mode applied to the resource that was occupied by the transaction that caused the timeout. For details on the lock modes, see the HiRDB Version 9 UAP Development Guide.
  20. occupied-resource-type
    Displays the type of resource that was occupied by the transaction that caused the timeout. For details on the resource types, see 8.6.4 Resource types and resource information.
  21. occupied-resource-information
    Displays information about the resource that was occupied by the transaction that caused the timeout. For details on the resource information, see 8.6.4 Resource types and resource information.
    Information about the resource that caused the transaction that caused the timeout to be placed in lock-release wait status
    Items 22 to 27 provide information about the resource that caused the timeout. Item wait and the subsequent items might not be displayed.
  22. server-name
    Displays the name of the server used by the transaction that caused the timeout to issue the resource occupancy request.
  23. lock-mode
    Displays the lock mode the transaction that caused the timeout 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.
  24. locked-resource-type
    Displays the type of resource that caused the transaction that caused the timeout to be placed in lock-release wait status. For details on the resource types, see 8.6.4 Resource types and resource information.
  25. locked-resource-information
    Displays information about the resource that caused the transaction that caused the timeout to be placed in lock-release wait status. For details on the resource types, see 8.6.4 Resource types and resource information.
  26. user-identifier
    Displays the sequence numbers assigned dynamically by HiRDB to identify the individual user.
  27. deadlock-priority-value
    Displays the deadlock priority value for the transaction that resulted in the deadlock.

The following figure shows an output example of timeout information.

Figure 8-10 Output example of timeout information

[Figure]