31.3 Example
This example displays information about the real threads and pseudo-threads.
Explanation of the output items
- THREAD-NO
-
Displays the real thread numbers.
- T-ID(OS)
-
Displays the real thread IDs (OS).
The value having the same format as the real thread ID output to the message log file is displayed.
- TOTAL_PSEUDO_THREAD
-
Displays the number of pseudo-threads that are running within each real thread. Pseudo-threads used in HADB are included.
- TYPE
-
Displays the real thread type. One of the following is displayed:
-
SYSTEM: Thread being used by the system
-
CONNECT: Connection thread (including a connection thread being used by the system)
-
PROCESS: Processing thread
-
- CNUMBER
-
Displays the connection sequence number of the processing that is using the real thread.
- SQL_ID
-
Displays the SQL statement sequence number of the SQL statement that is running using the real thread.
- CLIENT_GROUP
-
Displays the name of the client group to which the HADB client that executed the SQL statement belongs. If the command or HADB client that executed the SQL statement belongs to a command group, command is displayed.
If the command or HADB client that executed the SQL statement does not belong to any group, nothing is displayed.