SAP ABAP Table SYB_XCHG_SEGMENT (SYB: exchange data structure for ASE segments)

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_SEGMENT	Table Relationship Diagram
Short Description	SYB: exchange data structure for ASE segments

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	SEGMENT	☐	SYB_SYSSEGMENTS		STRU	0	0
2	SEGMENT	☐			INT2	5	0
3	NAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
4	STATUS	☐			INT2	5	0
5	SEGM_TOTAL_MB	☐			INT4	10	0
6	SEGM_FREE_MB	☐			INT4	10	0
7	AEXP_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
8	AEXP_ENABLED_ICON	☐			STRG	0	0
9	AEXP_ENABLED_TEXT	☐			STRG	0	0
10	AEXP_GROWBY_VALUE	☐			INT4	10	0
11	AEXP_GROWBY_UNIT	☐			CHAR	2	0
12	AEXP_MAXSIZE_MB	☐			INT4	10	0
13	AEXP_THRESHOLD_MB	☐			INT4	10	0
14	AEXP_INH_FROM_DEFAULT	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
15	SEGBIT	☐			INT2	5	0
16	DBID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
17	BGCOLOR	☐	LVC_CIFNM	CHAR30	CHAR	30	0	ALV control: Field name with simple row color coding
18	DATABASE	☐	SYB_SYSDATABASES		STRU	0	0
19	NAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
20	DBID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
21	SUSER_NAME	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
22	SUID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
23	STATUS	☐			INT2	5	0
24	LOGPTR	☐			INT4	10	0
25	CRDATE	☐			STRG	0	0
26	DUMPTRDATE	☐			STRG	0	0
27	STATUS2	☐			INT2	5	0
28	STATUS3	☐			INT4	10	0
29	STATUS4	☐			INT4	10	0
30	DURABILITY	☐			CHAR	20	0
31	SIZE_MB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
32	VDEVNO	☐			INT2	5	0
33	IN_DROP	☐			CHAR	3	0
34	MIXEDLOG	☐			CHAR	3	0
35	SUSPECT_PAGES	☐			CHAR	3	0
36	BGCOLOR	☐	LVC_CIFNM	CHAR30	CHAR	30	0	ALV control: Field name with simple row color coding
37	SUSPECT_DB	☐			CHAR	3	0
38	LOG_FREE_PAGES	☐			INT4	10	0
39	LOG_FREE_MB	☐			INT4	10	0
40	LOG_TOTAL_MB	☐			INT4	10	0
41	DATA_RESERVED_PCT	☐			DEC	6	2
42	LOG_RESERVED_PCT	☐			DEC	6	2
43	DATA_MB	☐			INT4	10	0
44	DATA_FREE_MB	☐			INT4	10	0
45	AEXP_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
46	AEXP_ENABLED_ICON	☐			STRG	0	0
47	AEXP_ENABLED_TEXT	☐			STRG	0	0
48	AEXP_LAST_DATA_EXP	☐			STRG	0	0
49	AEXP_LAST_LOG_EXP	☐			STRG	0	0
50	AEXP_INH_FROM_DEFAULT	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False

History

Last changed by/on	SAP	20140117
SAP Release Created in	740