SAP ABAP Table SYB_VIEW_DATACACHE_DTL (SYB: View data structure for datacache / cachepool 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_DATACACHE_DTL	Table Relationship Diagram
Short Description	SYB: View data structure for datacache / cachepool 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	CACHEPOOL	☐	SYBMON_CACHEPOOL		STRU	0	0
2	CACHEID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
3	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
4	IOBUFFERSIZE	☐			INT4	10	0
5	PHYSICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
6	STALLS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
7	PAGESTOUCHED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
8	PAGESREAD	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
9	BUFFERSTOMRU	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
10	BUFFERSTOLRU	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
11	CACHENAME	☐			CHAR	30	0
12	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
13	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
14	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
15	TIME_PERIOD	☐			INT4	10	0
16	IOBUFFERSIZE_GUI	☐			STRG	0	0
17	LOGICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
18	PHYSICALWRITES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
19	APFREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
20	HIT_RATIO	☐			DEC	5	2
21	RUNSIZE	☐			INT4	10	0
22	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
23	DETAILS	☐	SYBMON_CACHEPOOL_TAB		TTYP	0	0
24	CACHE_AGGREGATION	☐			CHAR	1	0
25	CACHE_AGGREGATION_NEG	☐			CHAR	1	0

History

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