SAP ABAP Table SYBMON_INDEX_SPACE (SYB: Index related data (space only))

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	SYBMON_INDEX_SPACE	Table Relationship Diagram
Short Description	SYB: Index related data (space only)

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	PARTITIONNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
5	INDNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
6	ID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
7	INDID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
8	PARTITIONID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
9	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
10	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
11	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
12	TIME_PERIOD	☐			INT4	10	0
13	NUM_PARTITIONS	☐			INT4	10	0
14	NUM_PARTITIONS_MAX	☐			INT4	10	0
15	IND_INDEXPGCLRATIO	☐			DEC	5	2
16	IND_INDEXPGCLRATIO_MIN	☐			DEC	5	2
17	IND_DATAPGCLRATIO	☐			DEC	5	2
18	IND_DATAPGCLRATIO_MIN	☐			DEC	5	2
19	IND_DATAROWCLRATIO	☐			DEC	5	2
20	IND_DATAROWCLRATIO_MIN	☐			DEC	5	2
21	IND_LRGIOEFF	☐			DEC	5	2
22	IND_LRGIOEFF_MIN	☐			DEC	5	2
23	INDEXHEIGHT	☐			INT2	5	0
24	INDEXHEIGHT_MAX	☐			INT2	5	0
25	LEAFCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
26	LEAFCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
27	EXTENT0PGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
28	EXTENT0PGCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
29	OAMAPGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
30	OAMAPGCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
31	OAMPAGECNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
32	OAMPAGECNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
33	STATMODDATE	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
34	LEAFROWSIZE	☐			INT2	5	0
35	LEAFROWSIZE_MAX	☐			INT2	5	0
36	IND_DATA_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
37	IND_DATA_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
38	IND_DATA_UTL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
39	IND_DATA_UTL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
40	IND_USED_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
41	IND_USED_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
42	IND_RESERVED_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
43	IND_RESERVED_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
44	IND_UNUSED_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
45	IND_UNUSED_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
46	IND_DATA_DELTA_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
47	IND_USED_DELTA_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
48	IND_RESERVED_DELTA_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
49	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname

History

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