SAP ABAP Table DB6_VIEW_HADR_DETAIL (DB6: View Data HADR)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Basic Data

Table Category	INTTAB	Structure
Structure	DB6_VIEW_HADR_DETAIL	Table Relationship Diagram
Short Description	DB6: View Data HADR

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	HADR_HISTORY	☐	DB6_HADR_TAB		TTYP	0	0
2	HADR_SUMMARY	☐	DB6_HADR		STRU	0	0
3	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
4	TIME_PERIOD	☐			INT4	10	0
5	HADR_ROLE	☐			CHAR	13	0
6	REPLAY_TYPE	☐			CHAR	9	0
7	HADR_SYNCMODE	☐			CHAR	10	0
8	STANDBY_ID	☐			INT4	10	0
9	LOG_STREAM_ID	☐			INT4	10	0
10	HADR_STATE	☐			CHAR	23	0
11	PRIMARY_MEMBER_HOST	☐			STRG	0	0
12	PRIMARY_INSTANCE	☐			SSTR	128	0
13	PRIMARY_MEMBER	☐			INT4	10	0
14	STANDBY_MEMBER_HOST	☐			STRG	0	0
15	STANDBY_INSTANCE	☐			SSTR	128	0
16	STANDBY_MEMBER	☐			INT4	10	0
17	HADR_CONNECT_STATUS	☐			CHAR	12	0
18	HADR_CONNECT_STATUS_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
19	HEARTBEAT_INTERVAL	☐			DEC	22	0
20	HADR_TIMEOUT	☐			DEC	22	0
21	TIME_SINCE_LAST_RECV	☐			DEC	22	0
22	PEER_WAIT_LIMIT	☐			DEC	22	0
23	LOG_HADR_WAIT_CUR	☐			DEC	22	0
24	LOG_HADR_WAIT_TIME	☐			DEC	22	0
25	LOG_HADR_WAITS_TOTAL	☐			DEC	22	0
26	SOCK_SEND_BUF_REQUESTED	☐			DEC	22	0
27	SOCK_SEND_BUF_ACTUAL	☐			DEC	22	0
28	SOCK_RECV_BUF_REQUESTED	☐			DEC	22	0
29	SOCK_RECV_BUF_ACTUAL	☐			DEC	22	0
30	PRIMARY_LOG_FILE	☐			CHAR	12	0
31	PRIMARY_LOG_PAGE	☐			DEC	22	0
32	PRIMARY_LOG_POS	☐			DEC	22	0
33	PRIMARY_LOG_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
34	STANDBY_LOG_FILE	☐			CHAR	12	0
35	STANDBY_LOG_PAGE	☐			DEC	22	0
36	STANDBY_LOG_POS	☐			DEC	22	0
37	STANDBY_LOG_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
38	AVG_HADR_LOG_GAP	☐			DEC	22	0
39	STANDBY_REPLAY_LOG_FILE	☐			CHAR	12	0
40	STANDBY_REPLAY_LOG_PAGE	☐			DEC	22	0
41	STANDBY_REPLAY_LOG_POS	☐			DEC	22	0
42	STANDBY_REPLAY_LOG_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
43	STANDBY_RECV_REPLAY_GAP	☐			DEC	22	0
44	STANDBY_REPLAY_DELAY	☐			DEC	22	0
45	STANDBY_RECV_BUF_SIZE	☐			DEC	22	0
46	AVG_STANDBY_RECV_BUF_PERCENT	☐			DEC	5	2
47	MAX_STANDBY_RECV_BUF_PERCENT	☐			DEC	5	2
48	STANDBY_SPOOL_LIMIT	☐			DEC	22	0
49	PEER_WINDOW	☐			DEC	22	0
50	PEER_WINDOW_END	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
51	TAKEOVER_APP_REMAINING_PRIMARY	☐			DEC	22	0
52	TAKEOVER_APP_REMAINING_STANDBY	☐			DEC	22	0
53	READS_ON_STANDBY_ENABLED	☐			CHAR	10	0
54	STANDBY_REPLAY_ONLY_WINDOW_ACT	☐			CHAR	10	0
55	STANDBY_REPLAY_ONLY_WINDOW_STA	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
56	STANDBY_REPLAY_ONLY_WINDOW_TRA	☐			DEC	22	0
57	PRIMARY_LOG_VOL_MB	☐			DEC	22	0
58	STANDBY_LOG_VOL_MB	☐			DEC	22	0
59	STANDBY_REPLAY_LOG_VOL_MB	☐			DEC	22	0
60	STANDBY_REPLAY_GAP_MB	☐			DEC	22	0
61	STANDBY_REPLAY_GAP_SECONDS	☐			DEC	22	0
62	AVG_LOG_WAIT_TIME	☐			DEC	22	2
63	MAX_HADR_LOG_GAP	☐			DEC	22	0
64	AVG_REPLAY_LOG_VOL_MB_PER_MIN	☐			DEC	22	2
65	AVG_PRIMARY_LOG_VOL_MB_PER_MIN	☐			DEC	22	2
66	HADR_HISTORY_DETAIL	☐	DB6_HADR		STRU	0	0
67	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
68	TIME_PERIOD	☐			INT4	10	0
69	HADR_ROLE	☐			CHAR	13	0
70	REPLAY_TYPE	☐			CHAR	9	0
71	HADR_SYNCMODE	☐			CHAR	10	0
72	STANDBY_ID	☐			INT4	10	0
73	LOG_STREAM_ID	☐			INT4	10	0
74	HADR_STATE	☐			CHAR	23	0
75	PRIMARY_MEMBER_HOST	☐			STRG	0	0
76	PRIMARY_INSTANCE	☐			SSTR	128	0
77	PRIMARY_MEMBER	☐			INT4	10	0
78	STANDBY_MEMBER_HOST	☐			STRG	0	0
79	STANDBY_INSTANCE	☐			SSTR	128	0
80	STANDBY_MEMBER	☐			INT4	10	0
81	HADR_CONNECT_STATUS	☐			CHAR	12	0
82	HADR_CONNECT_STATUS_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
83	HEARTBEAT_INTERVAL	☐			DEC	22	0
84	HADR_TIMEOUT	☐			DEC	22	0
85	TIME_SINCE_LAST_RECV	☐			DEC	22	0
86	PEER_WAIT_LIMIT	☐			DEC	22	0
87	LOG_HADR_WAIT_CUR	☐			DEC	22	0
88	LOG_HADR_WAIT_TIME	☐			DEC	22	0
89	LOG_HADR_WAITS_TOTAL	☐			DEC	22	0
90	SOCK_SEND_BUF_REQUESTED	☐			DEC	22	0
91	SOCK_SEND_BUF_ACTUAL	☐			DEC	22	0
92	SOCK_RECV_BUF_REQUESTED	☐			DEC	22	0
93	SOCK_RECV_BUF_ACTUAL	☐			DEC	22	0
94	PRIMARY_LOG_FILE	☐			CHAR	12	0
95	PRIMARY_LOG_PAGE	☐			DEC	22	0
96	PRIMARY_LOG_POS	☐			DEC	22	0
97	PRIMARY_LOG_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
98	STANDBY_LOG_FILE	☐			CHAR	12	0
99	STANDBY_LOG_PAGE	☐			DEC	22	0
100	STANDBY_LOG_POS	☐			DEC	22	0
101	STANDBY_LOG_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
102	AVG_HADR_LOG_GAP	☐			DEC	22	0
103	STANDBY_REPLAY_LOG_FILE	☐			CHAR	12	0
104	STANDBY_REPLAY_LOG_PAGE	☐			DEC	22	0
105	STANDBY_REPLAY_LOG_POS	☐			DEC	22	0
106	STANDBY_REPLAY_LOG_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
107	STANDBY_RECV_REPLAY_GAP	☐			DEC	22	0
108	STANDBY_REPLAY_DELAY	☐			DEC	22	0
109	STANDBY_RECV_BUF_SIZE	☐			DEC	22	0
110	AVG_STANDBY_RECV_BUF_PERCENT	☐			DEC	5	2
111	MAX_STANDBY_RECV_BUF_PERCENT	☐			DEC	5	2
112	STANDBY_SPOOL_LIMIT	☐			DEC	22	0
113	PEER_WINDOW	☐			DEC	22	0
114	PEER_WINDOW_END	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
115	TAKEOVER_APP_REMAINING_PRIMARY	☐			DEC	22	0
116	TAKEOVER_APP_REMAINING_STANDBY	☐			DEC	22	0
117	READS_ON_STANDBY_ENABLED	☐			CHAR	10	0
118	STANDBY_REPLAY_ONLY_WINDOW_ACT	☐			CHAR	10	0
119	STANDBY_REPLAY_ONLY_WINDOW_STA	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
120	STANDBY_REPLAY_ONLY_WINDOW_TRA	☐			DEC	22	0
121	PRIMARY_LOG_VOL_MB	☐			DEC	22	0
122	STANDBY_LOG_VOL_MB	☐			DEC	22	0
123	STANDBY_REPLAY_LOG_VOL_MB	☐			DEC	22	0
124	STANDBY_REPLAY_GAP_MB	☐			DEC	22	0
125	STANDBY_REPLAY_GAP_SECONDS	☐			DEC	22	0
126	AVG_LOG_WAIT_TIME	☐			DEC	22	2
127	MAX_HADR_LOG_GAP	☐			DEC	22	0
128	AVG_REPLAY_LOG_VOL_MB_PER_MIN	☐			DEC	22	2
129	AVG_PRIMARY_LOG_VOL_MB_PER_MIN	☐			DEC	22	2

History

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