THREAD_STACK_ENTRIES

<< Click to Display Table of Contents >>

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

THREAD_STACK_ENTRIES

Previous pageReturn to chapter overviewNext page

Returns table of currently executing threads stack entries.

Syntax

SYS_BOOT.MGMT.THREAD_STACK_ENTRIES();

 

Field

Type

thread_id

bigint

stack_level

int

entry_string

varchar(1024)

class_name

varchar(128)

method_name

varchar(128)

file_name

varchar(1024)

line_num

int

is_native

boolean)

Syntax

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

 

5_2_indicator

Version 5.3 Feature

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

Example

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

 

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

'THREAD_ID','STACK_LEVEL','ENTRY_STRING','CLASS_NAME','METHOD_NAME','FILE_NAME','LINE_NUM','IS_NATIVE'

'13','0','java.lang.Object.wait(Native Method)','java.lang.Object','wait','Object.java','-2','true'

'13','1','java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143)','java.lang.ref.ReferenceQueue','remove','ReferenceQueue.java','143','false'