SAP ABAP Table /SDF/DB6_700_DBH_STG_DB (Structure based on SAPTOOLS.DBH_STG_DB)

Hierarchy

☛ ST-PI (Software Component) SAP Solution Tools Plug-In
   ⤷ SV-SMG-SDD (Application Component) Service Data Download
     ⤷ /SDF/DB6_INFR_7X (Package) Data Collectors for DB6 - OO

Basic Data

Table Category	INTTAB	Structure
Structure	/SDF/DB6_700_DBH_STG_DB	Table Relationship Diagram
Short Description	Structure based on SAPTOOLS.DBH_STG_DB

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	DBPARTITIONNUM	☐			INT1	3	0
2	MEMBER	☐			INT1	3	0
3	MEMBER_NAME	☐			CHAR	60	0
4	SNAPSHOT_TIMESTAMP	☐			CHAR	26	0
5	ACTIVE_HASH_JOINS	☐			DEC	22	0
6	ACTIVE_SORTS	☐			DEC	22	0
7	AGENTS_TOP	☐			DEC	22	0
8	APPLS_CUR_CONS	☐			DEC	22	0
9	APPLS_IN_DB2	☐			DEC	22	0
10	ASYNC_RUNSTATS	☐			DEC	22	0
11	CAT_CACHE_INSERTS	☐			DEC	22	0
12	CAT_CACHE_LOOKUPS	☐			DEC	22	0
13	CAT_CACHE_OVERFLOWS	☐			DEC	22	0
14	CAT_CACHE_SIZE_TOP	☐			DEC	22	0
15	CAT_CACHE_SZ	☐			DEC	22	0
16	CAT_CACHE_SZ_AUTOMATIC	☐			CHAR	3	0
17	CNT_ARCHIVED_LOGS	☐			DEC	22	0
18	CNT_BACKUP	☐			DEC	22	0
19	CNT_REBALANCE	☐			DEC	22	0
20	CNT_REORG	☐			DEC	22	0
21	COLLECT_MODE	☐			CHAR	1	0
22	COMMIT_SQL_STMTS	☐			DEC	22	0
23	COORD_AGENTS_TOP	☐			DEC	22	0
24	DDL_SQL_STMTS	☐			DEC	22	0
25	DEADLOCKS	☐			DEC	22	0
26	DYNAMIC_SQL_STMTS	☐			DEC	22	0
27	ELAPSED_EXEC_TIME_MS	☐			DEC	22	2
28	ELAPSED_EXEC_TIME_S	☐			DEC	22	2
29	FAILED_SQL_STMTS	☐			DEC	22	0
30	FS_FREE_SIZE_MB	☐			DEC	22	0
31	HADR_HEARTBEAT	☐			INT2	5	0
32	HADR_LOG_GAP	☐			DEC	22	0
33	HADR_STATE	☐			CHAR	22	0
34	HADR_SYNCMODE	☐			CHAR	10	0
35	HASH_JOIN_OVERFLOWS	☐			DEC	22	0
36	HASH_JOIN_SMALL_OVERFLOWS	☐			DEC	22	0
37	LOCKLIST_SZ	☐			DEC	22	0
38	LOCKLIST_SZ_AUTOMATIC	☐			CHAR	3	0
39	LOCKS_HELD	☐			DEC	22	0
40	LOCKS_WAITING	☐			DEC	22	0
41	LOCK_ESCALS	☐			DEC	22	0
42	LOCK_LIST_IN_USE	☐			DEC	22	0
43	LOCK_TIMEOUTS	☐			DEC	22	0
44	LOCK_WAITS	☐			DEC	22	0
45	LOCK_WAIT_TIME	☐			DEC	22	2
46	LOG_HELD_BY_DIRTY_PAGES	☐			DEC	22	0
47	LOG_READS	☐			DEC	22	0
48	LOG_READ_TIME_NS	☐			DEC	22	2
49	LOG_READ_TIME_S	☐			DEC	22	2
50	LOG_TO_REDO_FOR_RECOVERY	☐			DEC	22	0
51	LOG_WRITES	☐			DEC	22	0
52	LOG_WRITE_TIME_NS	☐			DEC	22	2
53	LOG_WRITE_TIME_S	☐			DEC	22	2
54	NUM_ASSOC_AGENTS	☐			DEC	22	0
55	NUM_IOCLEANERS	☐			INT1	3	0
56	NUM_IOCLEANERS_AUTOMATIC	☐			CHAR	3	0
57	NUM_IOSERVERS	☐			INT1	3	0
58	NUM_IOSERVERS_AUTOMATIC	☐			CHAR	3	0
59	NUM_LOG_BUFFER_FULL	☐			DEC	22	0
60	NUM_LOG_DATA_FOUND_IN_BUFFER	☐			DEC	22	0
61	NUM_LOG_PART_PAGE_IO	☐			DEC	22	0
62	NUM_LOG_READ_IO	☐			DEC	22	0
63	NUM_LOG_WRITE_IO	☐			DEC	22	0
64	NUM_THRESHOLD_VIOLATIONS	☐			DEC	22	0
65	PKG_CACHE_INSERTS	☐			DEC	22	0
66	PKG_CACHE_LOOKUPS	☐			DEC	22	0
67	PKG_CACHE_NUM_OVERFLOWS	☐			DEC	22	0
68	PKG_CACHE_SIZE_TOP	☐			DEC	22	0
69	PKG_CACHE_SZ	☐			DEC	22	0
70	PKG_CACHE_SZ_AUTOMATIC	☐			CHAR	3	0
71	POOL_DRTY_PG_STEAL_CLNS	☐			DEC	22	0
72	POOL_DRTY_PG_THRSH_CLNS	☐			DEC	22	0
73	POOL_LSN_GAP_CLNS	☐			DEC	22	0
74	POST_SHRTHRESHOLD_HASH_JOINS	☐			DEC	22	0
75	POST_SHRTHRESHOLD_SORTS	☐			DEC	22	0
76	PREFETCH_WAIT_TIME	☐			DEC	22	2
77	REAL_HOST_NAME	☐			CHAR	60	0
78	ROLLBACK_SQL_STMTS	☐			DEC	22	0
79	ROWS_DELETED	☐			DEC	22	0
80	ROWS_INSERTED	☐			DEC	22	0
81	ROWS_READ	☐			DEC	22	0
82	ROWS_SELECTED	☐			DEC	22	0
83	ROWS_UPDATED	☐			DEC	22	0
84	SEC_LOGS_ALLOCATED	☐			DEC	22	0
85	SEC_LOG_USED_TOP	☐			DEC	22	0
86	SELECT_SQL_STMTS	☐			DEC	22	0
87	SERVER_PLATFORM	☐			CHAR	23	0
88	SORT_HEAP_ALLOCATED_SIZE	☐			DEC	22	0
89	SORT_OVERFLOWS	☐			DEC	22	0
90	SORT_SHRHEAP_ALLOCATED	☐			DEC	22	0
91	SORT_SHRHEAP_TOP	☐			DEC	22	0
92	STATIC_SQL_STMTS	☐			DEC	22	0
93	STATS_CACHE_SIZE	☐			DEC	22	0
94	STATS_FABRICATE_TIME	☐			DEC	22	2
95	STATS_FABRICATIONS	☐			DEC	22	0
96	SYNC_RUNSTATS	☐			DEC	22	0
97	SYNC_RUNSTATS_TIME	☐			DEC	22	2
98	TIME_PERIOD	☐			INT2	5	0
99	TOTAL_CONS	☐			DEC	22	0
100	TOTAL_HASH_JOINS	☐			DEC	22	0
101	TOTAL_HASH_LOOPS	☐			DEC	22	0
102	TOTAL_LOG_AVAILABLE	☐			DEC	22	0
103	TOTAL_LOG_USED	☐			DEC	22	0
104	TOTAL_SEC_CONS	☐			DEC	22	0
105	TOTAL_SORTS	☐			DEC	22	0
106	TOTAL_SORT_TIME	☐			DEC	22	2
107	TOT_LOG_USED_TOP	☐			DEC	22	0
108	UID_SQL_STMTS	☐			DEC	22	0
109	X_LOCK_ESCALS	☐			DEC	22	0

History

Last changed by/on	SAP	20140922
SAP Release Created in	2008_1_700