SAP ABAP Table DB6_XCHG_HADR (DB6: HADR XCHG)

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_XCHG_HADR	Table Relationship Diagram
Short Description	DB6: HADR XCHG

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	TIME_SELECTION	☐	DBA_WD_TIMESLIDER		STRU	0	0
2	FROM_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
3	FROM_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
4	TO_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
5	TO_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
6	TIME_FRAME	☐	DBA_LISTBOX_VALUE	DBA_LISTBOX_VALUE	CHAR	40	0	DBA Cockpit: Listbox Value
7	RANGETYPE	☐			INT4	10	0
8	TIME_ZONE	☐			STRG	0	0
9	GRANULARITY	☐			INT4	10	0
10	TIME_RANGE_READONLY	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
11	TIME_RANGE_HIDDEN	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
12	TIME_RANGE_DESCR	☐			STRG	0	0
13	CONFIRM_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
14	GRANULARITY_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
15	AGGREGATE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
16	DRILLDOWN	☐	DBA_LISTBOX_VALUE	DBA_LISTBOX_VALUE	CHAR	40	0	DBA Cockpit: Listbox Value
17	MEMBER_SELECTION	☐	DB6_WD_MEMBER_SELECTION		STRU	0	0
18	SELECTED_MEMBER	☐			INT4	10	0
19	MULTI_SELECTION	☐	DB6_WD_MEMBER_LIST		TTYP	0	0
20	SELECTED_GROUP	☐			STRG	0	0
21	HADR	☐	DB6_HADR		STRU	0	0
22	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
23	TIME_PERIOD	☐			INT4	10	0
24	HADR_ROLE	☐			CHAR	13	0
25	REPLAY_TYPE	☐			CHAR	9	0
26	HADR_SYNCMODE	☐			CHAR	10	0
27	STANDBY_ID	☐			INT4	10	0
28	LOG_STREAM_ID	☐			INT4	10	0
29	HADR_STATE	☐			CHAR	23	0
30	PRIMARY_MEMBER_HOST	☐			STRG	0	0
31	PRIMARY_INSTANCE	☐			SSTR	128	0
32	PRIMARY_MEMBER	☐			INT4	10	0
33	STANDBY_MEMBER_HOST	☐			STRG	0	0
34	STANDBY_INSTANCE	☐			SSTR	128	0
35	STANDBY_MEMBER	☐			INT4	10	0
36	HADR_CONNECT_STATUS	☐			CHAR	12	0
37	HADR_CONNECT_STATUS_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
38	HEARTBEAT_INTERVAL	☐			DEC	22	0
39	HADR_TIMEOUT	☐			DEC	22	0
40	TIME_SINCE_LAST_RECV	☐			DEC	22	0
41	PEER_WAIT_LIMIT	☐			DEC	22	0
42	LOG_HADR_WAIT_CUR	☐			DEC	22	0
43	LOG_HADR_WAIT_TIME	☐			DEC	22	0
44	LOG_HADR_WAITS_TOTAL	☐			DEC	22	0
45	SOCK_SEND_BUF_REQUESTED	☐			DEC	22	0
46	SOCK_SEND_BUF_ACTUAL	☐			DEC	22	0
47	SOCK_RECV_BUF_REQUESTED	☐			DEC	22	0
48	SOCK_RECV_BUF_ACTUAL	☐			DEC	22	0
49	PRIMARY_LOG_FILE	☐			CHAR	12	0
50	PRIMARY_LOG_PAGE	☐			DEC	22	0
51	PRIMARY_LOG_POS	☐			DEC	22	0
52	PRIMARY_LOG_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
53	STANDBY_LOG_FILE	☐			CHAR	12	0
54	STANDBY_LOG_PAGE	☐			DEC	22	0
55	STANDBY_LOG_POS	☐			DEC	22	0
56	STANDBY_LOG_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
57	AVG_HADR_LOG_GAP	☐			DEC	22	0
58	STANDBY_REPLAY_LOG_FILE	☐			CHAR	12	0
59	STANDBY_REPLAY_LOG_PAGE	☐			DEC	22	0
60	STANDBY_REPLAY_LOG_POS	☐			DEC	22	0
61	STANDBY_REPLAY_LOG_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
62	STANDBY_RECV_REPLAY_GAP	☐			DEC	22	0
63	STANDBY_REPLAY_DELAY	☐			DEC	22	0
64	STANDBY_RECV_BUF_SIZE	☐			DEC	22	0
65	AVG_STANDBY_RECV_BUF_PERCENT	☐			DEC	5	2
66	MAX_STANDBY_RECV_BUF_PERCENT	☐			DEC	5	2
67	STANDBY_SPOOL_LIMIT	☐			DEC	22	0
68	PEER_WINDOW	☐			DEC	22	0
69	PEER_WINDOW_END	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
70	TAKEOVER_APP_REMAINING_PRIMARY	☐			DEC	22	0
71	TAKEOVER_APP_REMAINING_STANDBY	☐			DEC	22	0
72	READS_ON_STANDBY_ENABLED	☐			CHAR	10	0
73	STANDBY_REPLAY_ONLY_WINDOW_ACT	☐			CHAR	10	0
74	STANDBY_REPLAY_ONLY_WINDOW_STA	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
75	STANDBY_REPLAY_ONLY_WINDOW_TRA	☐			DEC	22	0
76	PRIMARY_LOG_VOL_MB	☐			DEC	22	0
77	STANDBY_LOG_VOL_MB	☐			DEC	22	0
78	STANDBY_REPLAY_LOG_VOL_MB	☐			DEC	22	0
79	STANDBY_REPLAY_GAP_MB	☐			DEC	22	0
80	STANDBY_REPLAY_GAP_SECONDS	☐			DEC	22	0
81	AVG_LOG_WAIT_TIME	☐			DEC	22	2
82	MAX_HADR_LOG_GAP	☐			DEC	22	0
83	AVG_REPLAY_LOG_VOL_MB_PER_MIN	☐			DEC	22	2
84	AVG_PRIMARY_LOG_VOL_MB_PER_MIN	☐			DEC	22	2

History

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