SAP ABAP Table DB6_TRANSACTION_LOG (DB6: mon_get_transaction_log)

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_TRANSACTION_LOG	Table Relationship Diagram
Short Description	DB6: mon_get_transaction_log

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	MEMBER	☐			INT4	10	0
3	TOTAL_LOG_AVAILABLE	☐			DEC	22	0
4	TOTAL_LOG_USED	☐			DEC	22	0
5	AVG_TOTAL_LOG_USED	☐			DEC	22	0
6	SEC_LOG_USED_TOP	☐			DEC	22	0
7	TOT_LOG_USED_TOP	☐			DEC	22	0
8	SEC_LOGS_ALLOCATED	☐			DEC	22	0
9	LOG_READS	☐			DEC	22	0
10	LOG_READ_TIME	☐			DEC	22	0
11	LOG_WRITES	☐			DEC	22	0
12	LOG_WRITE_TIME	☐			DEC	22	0
13	NUM_LOG_WRITE_IO	☐			DEC	22	0
14	NUM_LOG_READ_IO	☐			DEC	22	0
15	NUM_LOG_PART_PAGE_IO	☐			DEC	22	0
16	NUM_LOG_BUFFER_FULL	☐			DEC	22	0
17	NUM_LOG_DATA_FOUND_IN_BUFFER	☐			DEC	22	0
18	APPLID_HOLDING_OLDEST_XACT	☐			DEC	22	0
19	LOG_TO_REDO_FOR_RECOVERY	☐			DEC	22	0
20	LOG_HELD_BY_DIRTY_PAGES	☐			DEC	22	0
21	FIRST_ACTIVE_LOG	☐			DEC	22	0
22	LAST_ACTIVE_LOG	☐			DEC	22	0
23	CURRENT_ACTIVE_LOG	☐			DEC	22	0
24	CURRENT_ARCHIVE_LOG	☐			DEC	22	0
25	CUR_COMMIT_DISK_LOG_READS	☐			DEC	22	0
26	CUR_COMMIT_TOTAL_LOG_READS	☐			DEC	22	0
27	CUR_COMMIT_LOG_BUFF_LOG_READS	☐			DEC	22	0
28	ARCHIVE_METHOD1_STATUS	☐			CHAR	7	0
29	METHOD1_NEXT_LOG_TO_ARCHIVE	☐			DEC	22	0
30	METHOD1_FIRST_FAILURE	☐			DEC	22	0
31	ARCHIVE_METHOD2_STATUS	☐			CHAR	7	0
32	METHOD2_NEXT_LOG_TO_ARCHIVE	☐			DEC	22	0
33	METHOD2_FIRST_FAILURE	☐			DEC	22	0
34	LOG_CHAIN_ID	☐			DEC	22	0
35	CURRENT_LSO	☐			DEC	22	0
36	CURRENT_LSN	☐			DEC	22	0
37	OLDEST_TX_LSN	☐			DEC	22	0
38	NUM_LOGS_AVAIL_FOR_RENAME	☐			INT4	10	0
39	NUM_INDOUBT_TRANS	☐			DEC	22	0
40	LOG_HADR_WAIT_TIME	☐			DEC	22	0
41	LOG_HADR_WAITS_TOTAL	☐			DEC	22	0
42	AVG_LOG_READ_TIME	☐			DEC	22	2
43	AVG_LOG_WRITE_TIME	☐			DEC	22	2
44	AVG_LOG_HADR_WAIT_TIME	☐			DEC	22	2
45	LOG_VOLUME_DLT_KB	☐			DEC	22	2
46	CURRENT_ACTIVE_LOG_DLT	☐			DEC	22	0
47	CURRENT_ARCHIVE_LOG_DLT	☐			DEC	22	0
48	AVG_LOG_VOLUME_DLT_KB_PER_MIN	☐			DEC	22	2

History

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