SAP ABAP Table SYB_VIEW_ASEINSTANCE_DTL (SYB: view data for ASE server / instance 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_ASEINSTANCE_DTL	Table Relationship Diagram
Short Description	SYB: view data for ASE server / instance 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	ASEINSTANCE	☐	SYBMON_ASEINSTANCE		STRU	0	0
2	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
3	ASE_VERSION	☐	DB6DBREL		CHAR	10	0	DB6: Database Release Level
4	NUMDEADLOCKS	☐			INT4	10	0
5	CONNECTIONS	☐			INT4	10	0
6	TRANSACTIONS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
7	LOCKSHELD	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
8	PROCESSMEMUSAGEKB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
9	NET_PACKETSSENT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
10	NET_PACKETSRECEIVED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
11	NET_MB_SENT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
12	NET_MB_RECEIVED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
13	ROLLBACKS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
14	SELECTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
15	UPDATES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
16	INSERTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
17	DELETES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
18	MERGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
19	UDIM_TOTAL	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
20	TABLEACCESSES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
21	INDEXACCESSES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
22	TEMPDBOBJECTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
23	WORKTABLES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
24	ULCFLUSHES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
25	ULCFLUSHFULL	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
26	ULCMBWRITTEN	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
27	PAGESREAD	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
28	PAGESWRITTEN	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
29	PHYSICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
30	PHYSICALWRITES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
31	LOGICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
32	STARTDATE	☐			STRG	0	0
33	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
34	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
35	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
36	TIME_PERIOD	☐			INT4	10	0
37	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
38	DETAILS	☐	SYBMON_ASEINSTANCE_TAB		TTYP	0	0

History

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