SAP ABAP Table SYB_XCHG_OBJECT_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_OBJECT_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	INDNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
5	PARTNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
6	TIME_SELECTION	☐	DBA_WD_TIMESLIDER		STRU	0	0
7	FROM_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
8	FROM_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
9	TO_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
10	TO_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
11	TIME_FRAME	☐	DBA_LISTBOX_VALUE	DBA_LISTBOX_VALUE	CHAR	40	0	DBA Cockpit: Listbox Value
12	RANGETYPE	☐			INT4	10	0
13	TIME_ZONE	☐			STRG	0	0
14	GRANULARITY	☐			INT4	10	0
15	TIME_RANGE_READONLY	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
16	TIME_RANGE_HIDDEN	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
17	TIME_RANGE_DESCR	☐			STRG	0	0
18	CONFIRM_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
19	GRANULARITY_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
20	AGGREGATE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
21	TABLE_PERF	☐	SYBMON_TABLE_PERF		STRU	0	0
22	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
23	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
24	TABOWNER	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
25	TABNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
26	PARTITIONNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
27	ID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
28	PARTITIONID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
29	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
30	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
31	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
32	TIME_PERIOD	☐			INT4	10	0
33	ROWSWRITTEN	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
34	ROWSINSERTED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
35	ROWSUPDATED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
36	ROWSDELETED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
37	OPERATIONS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
38	LOCKREQUESTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
39	LOCKWAITS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
40	LASTUSEDDATE	☐			STRG	0	0
41	LASTOPTSELECTDATE	☐			STRG	0	0
42	USEDCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
43	OPTSELECTCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
44	PAGESREAD	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
45	PAGESWRITTEN	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
46	LOGICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
47	PHYSICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
48	PHYSICALWRITES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
49	APFREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
50	HKGCOVERFLOWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
51	HKGCPENDING_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
52	HKGCREQUESTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
53	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
54	TOTALLOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
55	SHAREDLOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
56	UPDATELOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
57	EXCLUSIVELOCKWAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
58	HKGCOVERFLOWSDCOMP	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
59	HKGCPENDINGDCOMP_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
60	HKGCREQUESTSDCOMP	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
61	IOSIZE1PAGE	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
62	IOSIZE2PAGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
63	IOSIZE4PAGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
64	IOSIZE8PAGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
65	LASTPRSREWRITEDATE	☐			STRG	0	0
66	LASTPRSSELECTDATE	☐			STRG	0	0
67	PRSREWRITECOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
68	PRSSELECTCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
69	LEVEL0WAITS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
70	TOTALLEVEL0WAITTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
71	CACHE_HIT_RATIO	☐			DEC	6	2
72	TABLE_SPACE	☐	SYBMON_TABLE_SPACE		STRU	0	0
73	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
74	TABOWNER	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
75	TABNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
76	PARTITIONNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
77	ID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
78	PARTITIONID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
79	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
80	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
81	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
82	TIME_PERIOD	☐			INT4	10	0
83	NUM_PARTITIONS	☐			INT4	10	0
84	NUM_PARTITIONS_MAX	☐			INT4	10	0
85	ROW_COUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
86	ROW_COUNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
87	TAB_RESERVED_LOB_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
88	TAB_RESERVED_LOB_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
89	TAB_USED_LOB_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
90	TAB_USED_LOB_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
91	TAB_DATA_LOB_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
92	TAB_DATA_LOB_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
93	TAB_DATA_UTL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
94	TAB_DATA_UTL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
95	TAB_DATAPGCLRATIO	☐			DEC	5	2
96	TAB_DATAPGCLRATIO_MIN	☐			DEC	5	2
97	TAB_LRGIOEFF	☐			DEC	5	2
98	TAB_LRGIOEFF_MIN	☐			DEC	5	2
99	DATACHANGE	☐			DEC	12	2
100	DATACHANGE_MAX	☐			DEC	12	2
101	FORWROWCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
102	FORWROWCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
103	DELROWCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
104	DELROWCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
105	EXTENT0PGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
106	EXTENT0PGCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
107	OAMAPGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
108	OAMAPGCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
109	OAMPAGECNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
110	OAMPAGECNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
111	STATMODDATE	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
112	DATAROWSIZE	☐			INT2	5	0
113	DATAROWSIZE_MAX	☐			INT2	5	0
114	TAB_DATA_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
115	TAB_DATA_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
116	TAB_DATA_UTL_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
117	TAB_DATA_UTL_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
118	TAB_USED_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
119	TAB_USED_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
120	TAB_RESERVED_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
121	TAB_RESERVED_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
122	TAB_UNUSED_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
123	TAB_UNUSED_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
124	TAB_DATA_DELTA_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
125	TAB_USED_DELTA_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
126	TAB_RESERVED_DELTA_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
127	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
128	INDEX_PERF	☐	SYBMON_INDEX_PERF		STRU	0	0
129	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
130	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
131	TABOWNER	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
132	TABNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
133	PARTITIONNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
134	INDNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
135	ID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
136	INDID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
137	PARTITIONID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
138	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
139	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
140	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
141	TIME_PERIOD	☐			INT4	10	0
142	OPERATIONS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
143	LASTUSEDDATE	☐			STRG	0	0
144	LASTOPTSELECTDATE	☐			STRG	0	0
145	USEDCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
146	OPTSELECTCOUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
147	PAGESREAD	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
148	PAGESWRITTEN	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
149	LOGICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
150	PHYSICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
151	PHYSICALWRITES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
152	APFREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
153	HKGCOVERFLOWS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
154	HKGCPENDING_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
155	HKGCREQUESTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
156	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
157	IOSIZE1PAGE	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
158	IOSIZE2PAGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
159	IOSIZE4PAGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
160	IOSIZE8PAGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
161	CACHE_HIT_RATIO	☐			DEC	6	2
162	INDEX_SPACE	☐	SYBMON_INDEX_SPACE		STRU	0	0
163	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
164	TABOWNER	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
165	TABNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
166	PARTITIONNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
167	INDNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
168	ID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
169	INDID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
170	PARTITIONID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
171	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
172	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
173	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
174	TIME_PERIOD	☐			INT4	10	0
175	NUM_PARTITIONS	☐			INT4	10	0
176	NUM_PARTITIONS_MAX	☐			INT4	10	0
177	IND_INDEXPGCLRATIO	☐			DEC	5	2
178	IND_INDEXPGCLRATIO_MIN	☐			DEC	5	2
179	IND_DATAPGCLRATIO	☐			DEC	5	2
180	IND_DATAPGCLRATIO_MIN	☐			DEC	5	2
181	IND_DATAROWCLRATIO	☐			DEC	5	2
182	IND_DATAROWCLRATIO_MIN	☐			DEC	5	2
183	IND_LRGIOEFF	☐			DEC	5	2
184	IND_LRGIOEFF_MIN	☐			DEC	5	2
185	INDEXHEIGHT	☐			INT2	5	0
186	INDEXHEIGHT_MAX	☐			INT2	5	0
187	LEAFCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
188	LEAFCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
189	EXTENT0PGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
190	EXTENT0PGCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
191	OAMAPGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
192	OAMAPGCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
193	OAMPAGECNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
194	OAMPAGECNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
195	STATMODDATE	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
196	LEAFROWSIZE	☐			INT2	5	0
197	LEAFROWSIZE_MAX	☐			INT2	5	0
198	IND_DATA_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
199	IND_DATA_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
200	IND_DATA_UTL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
201	IND_DATA_UTL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
202	IND_USED_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
203	IND_USED_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
204	IND_RESERVED_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
205	IND_RESERVED_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
206	IND_UNUSED_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
207	IND_UNUSED_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
208	IND_DATA_DELTA_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
209	IND_USED_DELTA_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
210	IND_RESERVED_DELTA_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
211	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
212	KEEP_INDEXES	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
213	TOP_BY	☐			STRG	0	0

History

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