SAP ABAP Table DB6_VIEW_TRANS_LOG_LIST_D (DB6: Transaction Log Detail View)

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_TRANS_LOG_LIST_D	Table Relationship Diagram
Short Description	DB6: Transaction Log Detail View

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	IT_TRANSACTION_LOG_HISTORY	☐	DB6_TRANSACTION_LOG_TAB		TTYP	0	0
2	TRANSACTION_LOG_SUMMARY	☐	DB6_TRANSACTION_LOG		STRU	0	0
3	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
4	MEMBER	☐			INT4	10	0
5	TOTAL_LOG_AVAILABLE	☐			DEC	22	0
6	TOTAL_LOG_USED	☐			DEC	22	0
7	AVG_TOTAL_LOG_USED	☐			DEC	22	0
8	SEC_LOG_USED_TOP	☐			DEC	22	0
9	TOT_LOG_USED_TOP	☐			DEC	22	0
10	SEC_LOGS_ALLOCATED	☐			DEC	22	0
11	LOG_READS	☐			DEC	22	0
12	LOG_READ_TIME	☐			DEC	22	0
13	LOG_WRITES	☐			DEC	22	0
14	LOG_WRITE_TIME	☐			DEC	22	0
15	NUM_LOG_WRITE_IO	☐			DEC	22	0
16	NUM_LOG_READ_IO	☐			DEC	22	0
17	NUM_LOG_PART_PAGE_IO	☐			DEC	22	0
18	NUM_LOG_BUFFER_FULL	☐			DEC	22	0
19	NUM_LOG_DATA_FOUND_IN_BUFFER	☐			DEC	22	0
20	APPLID_HOLDING_OLDEST_XACT	☐			DEC	22	0
21	LOG_TO_REDO_FOR_RECOVERY	☐			DEC	22	0
22	LOG_HELD_BY_DIRTY_PAGES	☐			DEC	22	0
23	FIRST_ACTIVE_LOG	☐			DEC	22	0
24	LAST_ACTIVE_LOG	☐			DEC	22	0
25	CURRENT_ACTIVE_LOG	☐			DEC	22	0
26	CURRENT_ARCHIVE_LOG	☐			DEC	22	0
27	CUR_COMMIT_DISK_LOG_READS	☐			DEC	22	0
28	CUR_COMMIT_TOTAL_LOG_READS	☐			DEC	22	0
29	CUR_COMMIT_LOG_BUFF_LOG_READS	☐			DEC	22	0
30	ARCHIVE_METHOD1_STATUS	☐			CHAR	7	0
31	METHOD1_NEXT_LOG_TO_ARCHIVE	☐			DEC	22	0
32	METHOD1_FIRST_FAILURE	☐			DEC	22	0
33	ARCHIVE_METHOD2_STATUS	☐			CHAR	7	0
34	METHOD2_NEXT_LOG_TO_ARCHIVE	☐			DEC	22	0
35	METHOD2_FIRST_FAILURE	☐			DEC	22	0
36	LOG_CHAIN_ID	☐			DEC	22	0
37	CURRENT_LSO	☐			DEC	22	0
38	CURRENT_LSN	☐			DEC	22	0
39	OLDEST_TX_LSN	☐			DEC	22	0
40	NUM_LOGS_AVAIL_FOR_RENAME	☐			INT4	10	0
41	NUM_INDOUBT_TRANS	☐			DEC	22	0
42	LOG_HADR_WAIT_TIME	☐			DEC	22	0
43	LOG_HADR_WAITS_TOTAL	☐			DEC	22	0
44	AVG_LOG_READ_TIME	☐			DEC	22	2
45	AVG_LOG_WRITE_TIME	☐			DEC	22	2
46	AVG_LOG_HADR_WAIT_TIME	☐			DEC	22	2
47	LOG_VOLUME_DLT_KB	☐			DEC	22	2
48	CURRENT_ACTIVE_LOG_DLT	☐			DEC	22	0
49	CURRENT_ARCHIVE_LOG_DLT	☐			DEC	22	0
50	AVG_LOG_VOLUME_DLT_KB_PER_MIN	☐			DEC	22	2
51	WA_TRANSACTION_LOG_HISTORY	☐	DB6_TRANSACTION_LOG		STRU	0	0
52	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
53	MEMBER	☐			INT4	10	0
54	TOTAL_LOG_AVAILABLE	☐			DEC	22	0
55	TOTAL_LOG_USED	☐			DEC	22	0
56	AVG_TOTAL_LOG_USED	☐			DEC	22	0
57	SEC_LOG_USED_TOP	☐			DEC	22	0
58	TOT_LOG_USED_TOP	☐			DEC	22	0
59	SEC_LOGS_ALLOCATED	☐			DEC	22	0
60	LOG_READS	☐			DEC	22	0
61	LOG_READ_TIME	☐			DEC	22	0
62	LOG_WRITES	☐			DEC	22	0
63	LOG_WRITE_TIME	☐			DEC	22	0
64	NUM_LOG_WRITE_IO	☐			DEC	22	0
65	NUM_LOG_READ_IO	☐			DEC	22	0
66	NUM_LOG_PART_PAGE_IO	☐			DEC	22	0
67	NUM_LOG_BUFFER_FULL	☐			DEC	22	0
68	NUM_LOG_DATA_FOUND_IN_BUFFER	☐			DEC	22	0
69	APPLID_HOLDING_OLDEST_XACT	☐			DEC	22	0
70	LOG_TO_REDO_FOR_RECOVERY	☐			DEC	22	0
71	LOG_HELD_BY_DIRTY_PAGES	☐			DEC	22	0
72	FIRST_ACTIVE_LOG	☐			DEC	22	0
73	LAST_ACTIVE_LOG	☐			DEC	22	0
74	CURRENT_ACTIVE_LOG	☐			DEC	22	0
75	CURRENT_ARCHIVE_LOG	☐			DEC	22	0
76	CUR_COMMIT_DISK_LOG_READS	☐			DEC	22	0
77	CUR_COMMIT_TOTAL_LOG_READS	☐			DEC	22	0
78	CUR_COMMIT_LOG_BUFF_LOG_READS	☐			DEC	22	0
79	ARCHIVE_METHOD1_STATUS	☐			CHAR	7	0
80	METHOD1_NEXT_LOG_TO_ARCHIVE	☐			DEC	22	0
81	METHOD1_FIRST_FAILURE	☐			DEC	22	0
82	ARCHIVE_METHOD2_STATUS	☐			CHAR	7	0
83	METHOD2_NEXT_LOG_TO_ARCHIVE	☐			DEC	22	0
84	METHOD2_FIRST_FAILURE	☐			DEC	22	0
85	LOG_CHAIN_ID	☐			DEC	22	0
86	CURRENT_LSO	☐			DEC	22	0
87	CURRENT_LSN	☐			DEC	22	0
88	OLDEST_TX_LSN	☐			DEC	22	0
89	NUM_LOGS_AVAIL_FOR_RENAME	☐			INT4	10	0
90	NUM_INDOUBT_TRANS	☐			DEC	22	0
91	LOG_HADR_WAIT_TIME	☐			DEC	22	0
92	LOG_HADR_WAITS_TOTAL	☐			DEC	22	0
93	AVG_LOG_READ_TIME	☐			DEC	22	2
94	AVG_LOG_WRITE_TIME	☐			DEC	22	2
95	AVG_LOG_HADR_WAIT_TIME	☐			DEC	22	2
96	LOG_VOLUME_DLT_KB	☐			DEC	22	2
97	CURRENT_ACTIVE_LOG_DLT	☐			DEC	22	0
98	CURRENT_ARCHIVE_LOG_DLT	☐			DEC	22	0
99	AVG_LOG_VOLUME_DLT_KB_PER_MIN	☐			DEC	22	2

History

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