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

History

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