SAP ABAP Table DB6_HADR (DB6: 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_HADR	Table Relationship Diagram
Short Description	DB6: 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	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
2	TIME_PERIOD	☐			INT4	10	0
3	HADR_ROLE	☐			CHAR	13	0
4	REPLAY_TYPE	☐			CHAR	9	0
5	HADR_SYNCMODE	☐			CHAR	10	0
6	STANDBY_ID	☐			INT4	10	0
7	LOG_STREAM_ID	☐			INT4	10	0
8	HADR_STATE	☐			CHAR	23	0
9	PRIMARY_MEMBER_HOST	☐			STRG	0	0
10	PRIMARY_INSTANCE	☐			SSTR	128	0
11	PRIMARY_MEMBER	☐			INT4	10	0
12	STANDBY_MEMBER_HOST	☐			STRG	0	0
13	STANDBY_INSTANCE	☐			SSTR	128	0
14	STANDBY_MEMBER	☐			INT4	10	0
15	HADR_CONNECT_STATUS	☐			CHAR	12	0
16	HADR_CONNECT_STATUS_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
17	HEARTBEAT_INTERVAL	☐			DEC	22	0
18	HADR_TIMEOUT	☐			DEC	22	0
19	TIME_SINCE_LAST_RECV	☐			DEC	22	0
20	PEER_WAIT_LIMIT	☐			DEC	22	0
21	LOG_HADR_WAIT_CUR	☐			DEC	22	0
22	LOG_HADR_WAIT_TIME	☐			DEC	22	0
23	LOG_HADR_WAITS_TOTAL	☐			DEC	22	0
24	SOCK_SEND_BUF_REQUESTED	☐			DEC	22	0
25	SOCK_SEND_BUF_ACTUAL	☐			DEC	22	0
26	SOCK_RECV_BUF_REQUESTED	☐			DEC	22	0
27	SOCK_RECV_BUF_ACTUAL	☐			DEC	22	0
28	PRIMARY_LOG_FILE	☐			CHAR	12	0
29	PRIMARY_LOG_PAGE	☐			DEC	22	0
30	PRIMARY_LOG_POS	☐			DEC	22	0
31	PRIMARY_LOG_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
32	STANDBY_LOG_FILE	☐			CHAR	12	0
33	STANDBY_LOG_PAGE	☐			DEC	22	0
34	STANDBY_LOG_POS	☐			DEC	22	0
35	STANDBY_LOG_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
36	AVG_HADR_LOG_GAP	☐			DEC	22	0
37	STANDBY_REPLAY_LOG_FILE	☐			CHAR	12	0
38	STANDBY_REPLAY_LOG_PAGE	☐			DEC	22	0
39	STANDBY_REPLAY_LOG_POS	☐			DEC	22	0
40	STANDBY_REPLAY_LOG_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
41	STANDBY_RECV_REPLAY_GAP	☐			DEC	22	0
42	STANDBY_REPLAY_DELAY	☐			DEC	22	0
43	STANDBY_RECV_BUF_SIZE	☐			DEC	22	0
44	AVG_STANDBY_RECV_BUF_PERCENT	☐			DEC	5	2
45	MAX_STANDBY_RECV_BUF_PERCENT	☐			DEC	5	2
46	STANDBY_SPOOL_LIMIT	☐			DEC	22	0
47	PEER_WINDOW	☐			DEC	22	0
48	PEER_WINDOW_END	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
49	TAKEOVER_APP_REMAINING_PRIMARY	☐			DEC	22	0
50	TAKEOVER_APP_REMAINING_STANDBY	☐			DEC	22	0
51	READS_ON_STANDBY_ENABLED	☐			CHAR	10	0
52	STANDBY_REPLAY_ONLY_WINDOW_ACT	☐			CHAR	10	0
53	STANDBY_REPLAY_ONLY_WINDOW_STA	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
54	STANDBY_REPLAY_ONLY_WINDOW_TRA	☐			DEC	22	0
55	PRIMARY_LOG_VOL_MB	☐			DEC	22	0
56	STANDBY_LOG_VOL_MB	☐			DEC	22	0
57	STANDBY_REPLAY_LOG_VOL_MB	☐			DEC	22	0
58	STANDBY_REPLAY_GAP_MB	☐			DEC	22	0
59	STANDBY_REPLAY_GAP_SECONDS	☐			DEC	22	0
60	AVG_LOG_WAIT_TIME	☐			DEC	22	2
61	MAX_HADR_LOG_GAP	☐			DEC	22	0
62	AVG_REPLAY_LOG_VOL_MB_PER_MIN	☐			DEC	22	2
63	AVG_PRIMARY_LOG_VOL_MB_PER_MIN	☐			DEC	22	2

History

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