SAP ABAP Table SYB_VIEW_DEVICEIO (SYB: View data structure for Device IO)

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_DEVICEIO	Table Relationship Diagram
Short Description	SYB: View data structure for Device IO

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	DEVICEIO	☐	SYBMON_DEVICEIO_TAB		TTYP	0	0
2	TOTALS	☐	SYBMON_DEVICEIO		STRU	0	0
3	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
4	READS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
5	APFREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
6	WRITES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
7	DEVSEMAPHOREREQUESTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
8	DEVSEMAPHOREWAITS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
9	IOTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
10	LOGICALNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
11	PHYSICALNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
12	TIME_PERIOD	☐			INT4	10	0
13	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
14	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
15	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
16	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
17	AVG_IOTIME	☐			DEC	20	3
18	AVG_READTIME	☐			DEC	20	3
19	AVG_WRITETIME	☐			DEC	20	3
20	READTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
21	WRITETIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
22	POT_READS	☐			DEC	5	2
23	POT_WRITES	☐			DEC	5	2
24	POT_READTIME	☐			DEC	5	2
25	POT_WRITETIME	☐			DEC	5	2

History

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