SAP ABAP Table DB6UTLHIST (DB6: Structure for utility history file)

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	DB6UTLHIST	Table Relationship Diagram
Short Description	DB6: Structure for utility history file

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	COLLECT_MODE	☐			CHAR	1	0
3	MEMBER	☐			INT4	10	0
4	START_TIME	☐	DB6DATETIM_NOMS		CHAR	19	0	DBA: ISO conform timestamp with second precission
5	END_TIME	☐	DB6DATETIM_NOMS		CHAR	19	0	DBA: ISO conform timestamp with second precission
6	DURATION	☐			INT4	10	0
7	OPERATION	☐			CHAR	1	0
8	OPERATION_LABEL	☐			STRG	0	0
9	OPERATIONTYPE	☐			CHAR	1	0
10	OPERATIONTYPE_LABEL	☐			STRG	0	0
11	OBJECTTYPE	☐			CHAR	1	0
12	OBJECTTYPE_LABEL	☐			STRG	0	0
13	OBJECTSCHEMA	☐			STRG	0	0
14	OBJECTNAME	☐			STRG	0	0
15	COMMENT	☐			STRG	0	0
16	CMD_TEXT	☐			STRG	0	0
17	FIRSTLOG	☐			STRG	0	0
18	LASTLOG	☐			STRG	0	0
19	BACKUP_ID	☐			STRG	0	0
20	TABSCHEMA	☐			STRG	0	0
21	TABNAME	☐			STRG	0	0
22	NUM_TBSPS	☐			INT4	10	0
23	TBSPNAMES	☐			STRG	0	0
24	EID	☐			INT4	10	0
25	SEQNUM	☐			INT4	10	0
26	LOCATION	☐			STRG	0	0
27	DEVICETYPE	☐			CHAR	1	0
28	DEVICETYPE_LABEL	☐			STRG	0	0
29	ENTRY_STATUS	☐			CHAR	1	0
30	ENTRY_STATUS_LABEL	☐			STRG	0	0
31	SQLCODE	☐			INT4	10	0
32	SQLSTATE	☐			STRG	0	0
33	FULLREC	☐			STRG	0	0
34	SAP_CASE_ID	☐			STRG	0	0

History

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