16.13 Statistical information operations (when the multi-node function is being used)
When the multi-node function is being used, statistical information is controlled separately for each node. Therefore, execute the adbstat command on the node whose statistical information you want to output.
Note that the system might decide which node executes transactions in some cases. Therefore, when you output connection operation information or SQL statement statistical information, information is output only for the transactions executed on the node where you executed the adbstat command.
For details about the nodes where transactions are executed, see 16.5.3 Node that executes transactions.
For details about how to check statistical information, see 10.10 Performing statistical analysis (checking HADB server operation information).
- ▪ When obtaining access path statistical information
-
Access path statistical information is output in the SQL trace information. When the multi-node function is being used, SQL trace information is managed separately for each node. Therefore, when outputting statistical information for nodes, only the information for the SQL statement of the transaction executed on the local node is output. Accordingly, when obtaining statistical information for the access paths of all transactions, make sure that you obtain all nodes' SQL trace information. For details about how to obtain SQL trace information, see 10.11.5 Preparations for outputting SQL trace information.