DB6CSTRACE - DB6: Results Table for DB6 CS Trace (Cumulative DBSL Trace)

DB6: Results Table for DB6 CS Trace (Cumulative DBSL Trace) information is stored in SAP table DB6CSTRACE.
It is part of development package STU6 in software component BC-DB-DB6. This development package consists of objects that can be grouped under "DB6: Performance-Monitor (UNIX/Windows)".

Fields for table DB6CSTRACE

Field Name	Description	Is Key	Data Type	Length
PID	Process ID	X	INT4	4
DBNAME	Database Name	X	CHAR	32
APPSERV	Application Server Name	X	CHAR	128
DMODTYPE	DBSL_STMTID: Module Type	X	INT4	4
DMODULE	DBSL_STMTID: Module	X	CHAR	80
TIMESTAMP	DBSL_STMTID: Timestamp	X	CHAR	30
STMTNUM	DBSL_STMTID: Statement Number	X	INT4	4
OPTLEVEL	Database Optimization Level	X	CHAR	2
TABLENAME	Name of the First Table in the SQL Statement		CHAR	32
PROG	Name of ABAP Program		CHAR	80
CONT	Position in ABAP Program		DEC	12
FIRST_TIME	Time of First Execution		CHAR	52
LAST_TIME	Time of Last Execution		CHAR	52
PREP_CNT	Number of PREPARE Calls		DEC	12
EXEC_CNT	Number of EXECUTE Calls		DEC	12
FET_CNT	Number of FETCH Calls		DEC	12
EFET_CNT	Number of Extended FETCH Calls		DEC	12
CLSE_CNT	Number of CLOSE Calls		DEC	12
PREP_TIME	Total Duration of PREPARE Calls		DEC	12
EXEC_TIME	Total Duration of EXECUTE Calls		DEC	12
FET_TIME	Total Duration of FETCH Calls		DEC	12
EFET_TIME	Total Duration of Extended FETCH Calls		DEC	12
CLSE_TIME	Total Duration of CLOSE Calls		DEC	12
PREP_5S	Number of PREPARE Calls with Duration of 5s or More		DEC	12
PREP_1S	Number of PREPARE Calls with Duration of 1s or More		DEC	12
PREP_500MS	Number of PREPARE Calls with Duration of 500ms or More		DEC	12
PREP_100MS	Number of PREPARE Calls with Duration of 100ms or More		DEC	12
PREP_50MS	Number of PREPARE Calls with Duration of 50ms or More		DEC	12
PREP_20MS	Number of PREPARE Calls with Duration of 20ms or More		DEC	12
PREP_10MS	Number of PREPARE Calls with Duration of 10ms or More		DEC	12
PREP_5MS	Number of PREPARE Calls with Duration of 5ms or More		DEC	12
PREP_2MS	Number of PREPARE Calls with Duration of 2ms or More		DEC	12
PREP_1MS	Number of PREPARE Calls with Duration of 1ms or More		DEC	12
PREP_LT1MS	Number of PREPARE Calls with Duration Less than 100ms		DEC	12
EXEC_5S	Number of EXECUTE Calls with Duration of 5s or More		DEC	12
EXEC_1S	Number of EXECUTE Calls with Duration of 1s or More		DEC	12
EXEC_500MS	Number of EXECUTE Calls with Duration of 500ms or More		DEC	12
EXEC_100MS	Number of EXECUTE Calls with Duration of 100ms or More		DEC	12
EXEC_50MS	Number of EXECUTE Calls with Duration of 50ms or More		DEC	12
EXEC_20MS	Number of EXECUTE Calls with Duration of 20ms or More		DEC	12
EXEC_10MS	Number of EXECUTE Calls with Duration of 10ms or More		DEC	12
EXEC_5MS	Number of EXECUTE Calls with Duration of 5ms or More		DEC	12
EXEC_2MS	Number of EXECUTE Calls with Duration of 2ms or More		DEC	12
EXEC_1MS	Number of EXECUTE Calls with Duration of 1ms or More		DEC	12
EXEC_LT1MS	Number of EXECUTE Calls with Duration less than 1ms		DEC	12
FET_5S	Number of FETCH Calls with Duration of 5s or More		DEC	12
FET_1S	Number of FETCH Calls with Duration of 1s or More		DEC	12
FET_500MS	Number of FETCH Calls with Duration of 500ms or More		DEC	12
FET_100MS	Number of FETCH Calls with Duration of 100ms or More		DEC	12
FET_50MS	Number of FETCH Calls with Duration of 50ms or More		DEC	12
FET_20MS	Number of FETCH Calls with Duration of 20ms or More		DEC	12
FET_10MS	Number of FETCH Calls with Duration of 10ms or More		DEC	12
FET_5MS	Number of FETCH Calls with Duration of 5ms or More		DEC	12
FET_2MS	Number of FETCH Calls with Duration of 2ms or More		DEC	12
FET_1MS	Number of FETCH Calls with Duration of 1ms or More		DEC	12
FET_LT1MS	Number of FETCH Calls with Duration Less than 1ms		DEC	12
EFET_5S	Number of FETCH Calls with Duration of 5s or More		DEC	12
EFET_1S	No. of Extended FETCH Calls with Duration of 1s or More		DEC	12
EFET_500MS	No. of Extended FETCH Calls with Duration of 500ms or More		DEC	12
EFET_100MS	No. of Extended FETCH Calls with Duration of 100ms or More		DEC	12
EFET_50MS	No. of Extended FETCH Calls with Duration of 50ms or More		DEC	12
EFET_20MS	No. of Extended FETCH Calls with Duration of 20ms or More		DEC	12
EFET_10MS	No. of Extended FETCH Calls with Duration of 10ms or More		DEC	12
EFET_5MS	No. of Extended FETCH Calls with Duration of 5ms or More		DEC	12
EFET_2MS	No. of Extended FETCH Calls with Duration of 2ms or More		DEC	12
EFET_1MS	No. of Extended FETCH Calls with Duration of 1ms or More		DEC	12
EFET_LT1MS	No. of Extended FETCH Calls with Duration Less than 1ms		DEC	12
CLSE_5S	Number of CLOSE Calls with Duration of 5s or More		DEC	12
CLSE_1S	Number of CLOSE Calls with Duration of 1s or More		DEC	12
CLSE_500MS	Number of CLOSE Calls with Duration of 500ms or More		DEC	12
CLSE_100MS	Number of CLOSE Calls with Duration of 100ms or More		DEC	12
CLSE_50MS	Number of CLOSE Calls with Duration of 50ms or More		DEC	12
CLSE_20MS	Number of CLOSE Calls with Duration of 20ms or More		DEC	12
CLSE_10MS	Number of CLOSE Calls with Duration of 10ms or More		DEC	12
CLSE_5MS	Number of CLOSE Calls with Duration of 5ms or More		DEC	12
CLSE_2MS	Number of CLOSE Calls with Duration of 2ms or More		DEC	12
CLSE_1MS	Number of CLOSE Calls with Duration of 1ms or More		DEC	12
CLSE_LT1MS	Number of CLOSE Calls with Duration Less than 1ms		DEC	12
STMT_SUBST	First 200 Characters of the Statement Text		CHAR	400
STMT_LEN	Length of SQL Statement		INT2	2
STMT_TEXT	SQL Statement Text		LCHR	60000