SAP ABAP Table SYB_VIEW_DATABASE_DTL (SYB: View data structure for device details)

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_VIEW_DATABASE_DTL	Table Relationship Diagram
Short Description	SYB: View data structure for device details

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	SYBDATABASE	☐	SYB_SYSDATABASES		STRU	0	0
2	NAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
3	DBID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
4	SUSER_NAME	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
5	SUID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
6	STATUS	☐			INT2	5	0
7	LOGPTR	☐			INT4	10	0
8	CRDATE	☐			STRG	0	0
9	DUMPTRDATE	☐			STRG	0	0
10	STATUS2	☐			INT2	5	0
11	STATUS3	☐			INT4	10	0
12	STATUS4	☐			INT4	10	0
13	DURABILITY	☐			CHAR	20	0
14	SIZE_MB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
15	VDEVNO	☐			INT2	5	0
16	IN_DROP	☐			CHAR	3	0
17	MIXEDLOG	☐			CHAR	3	0
18	SUSPECT_PAGES	☐			CHAR	3	0
19	BGCOLOR	☐	LVC_CIFNM	CHAR30	CHAR	30	0	ALV control: Field name with simple row color coding
20	SUSPECT_DB	☐			CHAR	3	0
21	LOG_FREE_PAGES	☐			INT4	10	0
22	LOG_FREE_MB	☐			INT4	10	0
23	LOG_TOTAL_MB	☐			INT4	10	0
24	DATA_RESERVED_PCT	☐			DEC	6	2
25	LOG_RESERVED_PCT	☐			DEC	6	2
26	DATA_MB	☐			INT4	10	0
27	DATA_FREE_MB	☐			INT4	10	0
28	AEXP_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
29	AEXP_ENABLED_ICON	☐			STRG	0	0
30	AEXP_ENABLED_TEXT	☐			STRG	0	0
31	AEXP_LAST_DATA_EXP	☐			STRG	0	0
32	AEXP_LAST_LOG_EXP	☐			STRG	0	0
33	AEXP_INH_FROM_DEFAULT	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
34	SEGMENTS	☐	SYBSPACE_PHYSICAL_TAB		TTYP	0	0
35	DEVICES	☐	SYB_SYSDEVICES_TAB		TTYP	0	0
36	USAGES	☐	SYB_SYSUSAGES_TAB		TTYP	0	0
37	DB_OPTIONS	☐	SYB_DB_DETAILS		STRU	0	0
38	DBID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
39	BULKCOPY	☐			CHAR	3	0
40	TRUNC_LOG_ON_CHKPT	☐			CHAR	3	0
41	NO_CHKPT_ON_RECOVERY	☐			CHAR	3	0
42	RECOVERY_STARTED	☐			CHAR	3	0
43	DDL_IN_TRAN	☐			CHAR	3	0
44	READ_ONLY	☐			CHAR	3	0
45	DBO_USE_ONLY	☐			CHAR	3	0
46	SINGLE_USER	☐			CHAR	3	0
47	NULLS_BY_DEFAULT	☐			CHAR	3	0
48	ABORT_TRAN_ON_LOG_FULL	☐			CHAR	3	0
49	NO_FREE_SPACE_ACCTG	☐			CHAR	3	0
50	AUTO_IDENTITY	☐			CHAR	3	0
51	IDENTITY_IN_NONUNIQUE_IDX	☐			CHAR	3	0
52	AUTO_IDENTITY_UNIQUE_CONSTR	☐			CHAR	3	0
53	ASYNC_LOG_SERVICE	☐			CHAR	3	0
54	DELAYED_COMMIT	☐			CHAR	3	0
55	SCRATCH_DB	☐			CHAR	3	0

History

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