SAP ABAP Table DB6_XCHG_TRANSACTION_LOG (DB6: Transaction Log 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_TRANSACTION_LOG	Table Relationship Diagram
Short Description	DB6: Transaction Log 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	TRANS_LOG_DISP	☐	DB6_TRANSACTION_LOG_DISPLAY		STRU	0	0
17	MEMBER	☐			INT4	10	0
18	LOG_READS	☐			DEC	22	0
19	LOG_READ_TIME	☐			DEC	22	0
20	LOG_WRITES	☐			DEC	22	0
21	LOG_WRITE_TIME	☐			DEC	22	0
22	LOG_HADR_WAIT_TIME	☐			DEC	22	0
23	LOG_HADR_WAITS_TOTAL	☐			DEC	22	0
24	AVG_LOG_READ_TIME	☐			DEC	22	2
25	AVG_LOG_WRITE_TIME	☐			DEC	22	2
26	AVG_LOG_HADR_WAIT_TIME	☐			DEC	22	2
27	TOTAL_LOG_AVAILABLE	☐			DEC	22	0
28	TOTAL_LOG_USED	☐			DEC	22	0
29	AVG_TOTAL_LOG_USED_PCT	☐			DEC	22	2
30	AVG_TOTAL_LOG_USED	☐			DEC	22	0
31	SEC_LOG_USED_TOP	☐			DEC	22	0
32	TOT_LOG_USED_TOP_PCT	☐			DEC	22	2
33	TOT_LOG_USED_TOP	☐			DEC	22	0
34	SEC_LOGS_ALLOCATED	☐			DEC	22	0
35	NUM_LOG_WRITE_IO	☐			DEC	22	0
36	NUM_LOG_READ_IO	☐			DEC	22	0
37	NUM_LOG_PART_PAGE_IO	☐			DEC	22	0
38	NUM_LOG_BUFFER_FULL	☐			DEC	22	0
39	NUM_LOG_DATA_FOUND_IN_BUFFER	☐			DEC	22	0
40	LOG_TO_REDO_FOR_RECOVERY	☐			DEC	22	0
41	LOG_HELD_BY_DIRTY_PAGES	☐			DEC	22	0
42	NUM_INDOUBT_TRANS	☐			DEC	22	0
43	LOG_VOLUME_DLT_KB	☐			DEC	22	2
44	AVG_LOG_VOLUME_DLT_KB_PER_MIN	☐			DEC	22	2

History

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