SYSTEM_INFO

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Built-in Functions > General Management Functions >

SYSTEM_INFO

Previous pageReturn to chapter overviewNext page

Populates a table of global information about the running system.

Returns table

Field

Type

category

varchar(128)

subcategory

varchar(128)

source_name

varchar(128)

item_name

varchar(1024)

item_units

varchar(128)

item_value

varchar(65535)

Syntax

SELECT * FROM TABLE(SYS_BOOT.MGMT.THREADS());

 

5_2_indicator

Version 5.2 Feature

As of version 5.2, you no longer need to use the preface SYS_BOOT.MGMT.

Example

SELECT * FROM TABLE(SYS_BOOT.MGMT.THREADS());

 

0: jdbc:sqlstream:sdp://Home-Comp> SELECT * FROM TABLE(SYS_BOOT.MGMT.THREADS());

'THREAD_ID','THREAD_GROUP_NAME','THREAD_NAME','THREAD_PRIORITY','THREAD_STATE','IS_ALIVE','IS_DAEMON','IS_INTERRUPTED'

'5','system','Signal Dispatcher','9','RUNNABLE','true','true','false'

'22','main','Thread-9','5','RUNNABLE','true','false','false'

'20','main','Thread-7','5','RUNNABLE','true','false','false'

'13','main','Active Reference Queue Daemon','1','WAITING','true','true','false'

'18','main','PumpManagerThread','5','TIMED_WAITING','true','true','false'

'53','main','Thread-37','5','RUNNABLE','true','false','false'

'32','main','Thread-17','5','RUNNABLE','true','false','false'

'3','system','Finalizer','8','WAITING','true','true','false'

'2','system','Reference Handler','10','WAITING','true','true','false'

'30','main','Thread-15','5','RUNNABLE','true','false','false'

'21648','main','AnonymousJavaUdxRel.#21159:482867','5','WAITING','true','false','false'