16.9.3 When application or command execution takes a long time
If the processing time of an application or command is longer than expected, use the following procedure to identify the node that is executing the application or command.
Procedure:
-
Execute the adbls -d cnct command.
Refer to the command execution result to determine the node number of the node that is executing the application or command.
-
Execute the adbls -d node command.
Refer to the command execution result to identify the node that corresponds to the node number.
-
Investigate the cause.
After identifying the node, investigate the cause of the issue based on the explanation in 10.8 Checking the transaction processing status.
For details about the information that is output when the adbls -d cnct command is executed, see adbls -d cnct (Display the Connection Status) in the manual HADB Command Reference.
For details about the information that is output when the adbls -d node command is executed, see adbls -d node (Display the HADB Server Status on Each Node) in the manual HADB Command Reference.