LISTTHREADS view
The DVSYS.LISTTHREADS view provides a list of all the Java virtual machine (JVM) threads.
For more information on JVM threads, see Thread.
| Column | Type | Description |
|---|---|---|
| NODE_NAME | VARCHAR(80) | Name of the node where the query ran. |
| ID | BIGINT | The thread identifier. |
| GRP | VARCHAR(80) | The thread group, which represents a set of threads. |
| NAME | VARCHAR(128) | The name of the thread. |
| PRIORITY | INTEGER | The priority of the thread. |
| STATE | VARCHAR(20) | The state of the thread. |
| CPU | SMALLINT | The CPU utilization percentage of the thread. |
| CPUSYS | SMALLINT | The CPU system utilization percentage after deducting from the user percentage. |
| ISSUSPENDED | BOOLEAN | Indication of whether the thread is suspended. |
| ISINNATIVE | BOOLEAN | Indication of whether the thread is in native. |
| BLOCKCOUNT | BIGINT | The total number of times a thread is blocked. |
| BLOCKTIME | BIGINT | The elapsed time in milliseconds (ms) that the thread is blocked. |
| WAITCOUNT | BIGINT | The total number of times the thread waited for a notification to resume. |
| WAITTIME | BIGINT | The elapsed time in milliseconds (ms) that the thread waits for notification. |
| STACKDIGEST | VARCHAR(32672) | The thread stack trace. |