SAP ABAP Table DB6_VIEW_INSTANCE_DATA (DB6: Overview Data of Database Instance)

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_INSTANCE_DATA	Table Relationship Diagram
Short Description	DB6: Overview Data of Database Instance

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	INSTANCE_INFO	☐	DB6ADM_INSTANCE_INFO		STRU	0	0
2	INST_NAME	☐			STRG	0	0
3	IS_INST_PARTITIONABLE	☐			STRG	0	0
4	NUM_DBPARTITIONS	☐			INT4	10	0
5	INST_PTR_SIZE	☐			INT4	10	0
6	RELEASE_NUM	☐			STRG	0	0
7	SERVICE_LEVEL	☐			STRG	0	0
8	BLD_LEVEL	☐			STRG	0	0
9	PTF	☐			STRG	0	0
10	FIXPACK_NUM	☐			INT4	10	0
11	NUM_MEMBERS	☐			INT4	10	0
12	SYSTEM_INFO	☐	DB6ADM_SYSTEM_INFO_LIST		TTYP	0	0
13	HADR_INFO	☐	DB6ADM_HADR_INFO		STRU	0	0
14	DBPARTITIONNUM	☐			INT4	10	0
15	HADR_CONNECT_STATUS	☐			STRG	0	0
16	HADR_CONNECT_TIME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
17	HADR_HEARTBEAT	☐			INT4	10	0
18	HADR_LOCAL_HOST	☐			STRG	0	0
19	HADR_LOCAL_SERVICE	☐			STRG	0	0
20	HADR_LOG_GAP	☐			DEC	22	0
21	HADR_PRIMARY_LOG_FILE	☐			STRG	0	0
22	HADR_PRIMARY_LOG_LSN	☐			DEC	22	0
23	HADR_PRIMARY_LOG_PAGE	☐			DEC	22	0
24	HADR_REMOTE_HOST	☐			STRG	0	0
25	HADR_REMOTE_INSTANCE	☐			STRG	0	0
26	HADR_REMOTE_SERVICE	☐			STRG	0	0
27	HADR_ROLE	☐			STRG	0	0
28	HADR_STANDBY_LOG_FILE	☐			STRG	0	0
29	HADR_STANDBY_LOG_LSN	☐			DEC	22	0
30	HADR_STANDBY_LOG_PAGE	☐			DEC	22	0
31	HADR_STATE	☐			STRG	0	0
32	HADR_SYNCMODE	☐			STRG	0	0
33	HADR_TIMEOUT	☐			DEC	22	0
34	HADR_INFO_VISIBLE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
35	SINGLE_SYSTEM_INFO	☐	DB6ADM_SYSTEM_INFO		STRU	0	0
36	PARTITN	☐			INT4	10	0
37	OS_NAME	☐			STRG	0	0
38	OS_VERSION	☐			STRG	0	0
39	OS_RELEASE	☐			STRG	0	0
40	HOST_NAME	☐			STRG	0	0
41	TOTAL_CPUS	☐			INT4	10	0
42	CONFIGURED_CPUS	☐			INT4	10	0
43	TOTAL_MEMORY	☐			DEC	22	0

History

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