SAP ABAP Table SYB_XCHG_THREAD (SYB: exchange data structure for ASE thread)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	SYB_XCHG_THREAD	Table Relationship Diagram
Short Description	SYB: exchange data structure for ASE thread

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	THREAD	☐	SYBMON_THREAD		STRU	0	0
2	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
3	THREADID	☐			INT4	10	0
4	KTID	☐			INT4	10	0
5	OSTHREADID	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
6	ALTOSTHREADID	☐			INT4	10	0
7	THREADPOOLID	☐			INT4	10	0
8	TASKRUNS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
9	TOTALTICKS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
10	IDLETICKS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
11	SLEEPTICKS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
12	BUSYTICKS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
13	USERTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
14	SYSTEMTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
15	MINORFAULTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
16	MAJORFAULTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
17	VOLUNTARYCTXTSWITCHES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
18	NONVOLUNTARYCTXTSWITCHES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
19	STATE	☐			CHAR	30	0
20	THREADPOOLNAME	☐			CHAR	30	0
21	THREADAFFINITY	☐			INT4	10	0
22	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
23	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
24	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
25	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
26	TIME_PERIOD	☐			INT4	10	0
27	PCT_IDLE	☐			DEC	5	2
28	PCT_SLEEP	☐			DEC	5	2
29	PCT_BUSY	☐			DEC	5	2
30	TIME_SELECTION	☐	DBA_WD_TIMESLIDER		STRU	0	0
31	FROM_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
32	FROM_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
33	TO_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
34	TO_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
35	TIME_FRAME	☐	DBA_LISTBOX_VALUE	DBA_LISTBOX_VALUE	CHAR	40	0	DBA Cockpit: Listbox Value
36	RANGETYPE	☐			INT4	10	0
37	TIME_ZONE	☐			STRG	0	0
38	GRANULARITY	☐			INT4	10	0
39	TIME_RANGE_READONLY	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
40	TIME_RANGE_HIDDEN	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
41	TIME_RANGE_DESCR	☐			STRG	0	0
42	CONFIRM_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
43	GRANULARITY_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
44	AGGREGATE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False

History

Last changed by/on	SAP	20141013
SAP Release Created in	732