SAP ABAP Table SYB_XCHG_TABLE_DTL (SYB: xchg data structure for table detail)

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_TABLE_DTL	Table Relationship Diagram
Short Description	SYB: xchg data structure for table detail

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	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
2	TABOWNER	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
3	TABNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
4	TIME_SELECTION	☐	DBA_WD_TIMESLIDER		STRU	0	0
5	FROM_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
6	FROM_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
7	TO_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
8	TO_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
9	TIME_FRAME	☐	DBA_LISTBOX_VALUE	DBA_LISTBOX_VALUE	CHAR	40	0	DBA Cockpit: Listbox Value
10	RANGETYPE	☐			INT4	10	0
11	TIME_ZONE	☐			STRG	0	0
12	GRANULARITY	☐			INT4	10	0
13	TIME_RANGE_READONLY	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
14	CONFIRM_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
15	GRANULARITY_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
16	AGGREGATE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
17	TABLE_PERF	☐	SYBMON_TABLE_PERF		STRU	0	0
18	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
19	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
20	TABOWNER	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
21	TABNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
22	PARTITIONNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
23	ID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
24	PARTITIONID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
25	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
26	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
27	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
28	TIME_PERIOD	☐			INT4	10	0
29	ROWSWRITTEN	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
30	ROWSINSERTED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
31	ROWSUPDATED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
32	ROWSDELETED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
33	OPERATIONS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
34	LOCKREQUESTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
35	LOCKWAITS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
36	LASTUSEDDATE	☐			STRG	0	0
37	LASTOPTSELECTDATE	☐			STRG	0	0
38	USEDCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
39	OPTSELECTCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
40	PAGESREAD	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
41	PAGESWRITTEN	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
42	LOGICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
43	PHYSICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
44	PHYSICALWRITES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
45	APFREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
46	HKGCOVERFLOWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
47	HKGCPENDING_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
48	HKGCREQUESTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
49	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
50	TOTALLOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
51	SHAREDLOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
52	UPDATELOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
53	EXCLUSIVELOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
54	HKGCOVERFLOWSDCOMP	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
55	HKGCPENDINGDCOMP_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
56	HKGCREQUESTSDCOMP	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
57	IOSIZE1PAGE	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
58	IOSIZE2PAGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
59	IOSIZE4PAGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
60	IOSIZE8PAGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
61	LASTPRSREWRITEDATE	☐			STRG	0	0
62	LASTPRSSELECTDATE	☐			STRG	0	0
63	PRSREWRITECOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
64	PRSSELECTCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
65	CACHE_HIT_RATIO	☐			DEC	6	2
66	TABLE_SPACE	☐	SYBMON_TABLE_SPACE		STRU	0	0
67	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
68	TABOWNER	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
69	TABNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
70	PARTITIONNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
71	ID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
72	PARTITIONID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
73	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
74	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
75	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
76	TIME_PERIOD	☐			INT4	10	0
77	ROW_COUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
78	ROW_COUNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
79	TAB_RESERVED_LOB_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
80	TAB_RESERVED_LOB_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
81	TAB_USED_LOB_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
82	TAB_USED_LOB_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
83	TAB_DATA_LOB_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
84	TAB_DATA_LOB_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
85	TAB_DATA_UTL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
86	TAB_DATA_UTL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
87	TAB_DATAPGCLRATIO	☐			DEC	5	2
88	TAB_DATAPGCLRATIO_MIN	☐			DEC	5	2
89	TAB_LRGIOEFF	☐			DEC	5	2
90	TAB_LRGIOEFF_MIN	☐			DEC	5	2
91	DATACHANGE	☐			DEC	12	2
92	DATACHANGE_MAX	☐			DEC	12	2
93	FORWROWCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
94	FORWROWCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
95	DELROWCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
96	DELROWCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
97	EXTENT0PGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
98	EXTENT0PGCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
99	OAMAPGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
100	OAMAPGCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
101	OAMPAGECNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
102	OAMPAGECNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
103	STATMODDATE	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
104	DATAROWSIZE	☐			INT2	5	0
105	DATAROWSIZE_MAX	☐			INT2	5	0
106	TAB_DATA_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
107	TAB_DATA_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
108	TAB_DATA_UTL_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
109	TAB_DATA_UTL_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
110	TAB_USED_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
111	TAB_USED_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
112	TAB_RESERVED_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
113	TAB_RESERVED_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
114	TAB_UNUSED_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
115	TAB_UNUSED_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
116	TAB_DATA_DELTA_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
117	TAB_USED_DELTA_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
118	TAB_RESERVED_DELTA_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
119	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
120	TOP_BY	☐			STRG	0	0

History

Last changed by/on	SAP	20140121
SAP Release Created in	731