SAP ABAP Table SYB_VIEW_HADR_RAT_DET (SYB: view data for HADR RAT 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_HADR_RAT_DET	Table Relationship Diagram
Short Description	SYB: view data for HADR RAT 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	SCANNER_HISTORY	☐	SYBMON_REPSCANNERS_TAB		TTYP	0	0
2	SCANNER_SUMMARY	☐	SYBMON_REPSCANNERS		STRU	0	0
3	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
4	DBID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
5	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
6	SCANNERSPID	☐			INT4	10	0
7	PATHNAME	☐			STRG	0	0
8	ENGINEBINDING	☐			INT4	10	0
9	LOGRECORDSSCANNED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
10	LOGRECORDSPROCESSED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
11	TRUNCPOINTREQUESTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
12	TRUNCPOINTMOVES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
13	STATUS	☐			CHAR	30	0
14	SLEEPSTATUS	☐			CHAR	30	0
15	STARTMARKER	☐			CHAR	30	0
16	ENDMARKER	☐			CHAR	30	0
17	CURRENTMARKER	☐			CHAR	30	0
18	OLDESTTRANSACTION	☐			CHAR	30	0
19	LOGSCANS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
20	UPDATES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
21	INSERTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
22	DELETES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
23	STOREDPROCEDURES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
24	SQLSTATEMENTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
25	DDL	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
26	WRITETXT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
27	LOBCOLUMNS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
28	CLRS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
29	CHECKPOINTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
30	BEGINTRANSACTION	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
31	COMMITTRANSACTION	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
32	ABORTEDTRANSACTION	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
33	PREPAREDTRANSACTION	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
34	DELAYEDCOMMIT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
35	MAINTUSERTRANSACTION	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
36	LOGEXTENTIONS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
37	SCHEMAFWDLOOKUPS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
38	SCHEMABCKWLOOKUPS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
39	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
40	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
41	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
42	TIME_PERIOD	☐			INT4	10	0
43	SENDER_HISTORY	☐	SYBMON_REPSENDERS_TAB		TTYP	0	0
44	SENDER_SUMMARY	☐	SYBMON_REPSENDERS		STRU	0	0
45	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
46	DBID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
47	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
48	SENDERSPID	☐			INT4	10	0
49	SCANNERSPID	☐			INT4	10	0
50	DATASERVER	☐	SYBSRVNAME	SYBSRVNAME	CHAR	30	0	SYB: Server Name
51	REPLICATIONSERVER	☐	SYBSRVNAME	SYBSRVNAME	CHAR	30	0	SYB: Server Name
52	USERNAME	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
53	STATUS	☐			CHAR	30	0
54	SLEEPSTATUS	☐			CHAR	30	0
55	PATHNAME	☐			STRG	0	0
56	ENGINEBINDING	☐			INT4	10	0
57	MESSAGEQUEUESIZE	☐			INT4	10	0
58	MESSAGESINQUEUE	☐			INT4	10	0
59	SCANNERYIELDS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
60	SCANNERSLEEPS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
61	MB_SENT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
62	AVGBYTESPERCMD	☐			INT4	10	0
63	LASTREPSERVERERROR	☐			INT4	10	0
64	RETRIES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
65	EMPTYQUEUE_SLEEPS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
66	EMPTYQUEUE_SLEEPTIME	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
67	EMPTYQUEUE_MAXSLEEPTIME	☐			INT4	10	0
68	QUEUEFLUSHES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
69	MAXQUEUESIZE	☐			INT4	10	0
70	CMDSPROCESSED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
71	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
72	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
73	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
74	TIME_PERIOD	☐			INT4	10	0

History

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