SAP ABAP Table DB2TIMESD (Thread Activity: Times Distribution) - SAP Datasheet

The Best Online SAP Object Repository

Object Hierarchy

Software Component

SAP_BASIS

Application Component ID

BC-DB-DB2

Package

STU3

Object type

Structure

Object name

DB2TIMESD

Using

Data Element (31)

Used by

Not Used by Anyone

Advertise Links

SAP ABAP Table DB2TIMESD (Thread Activity: Times Distribution)

Hierarchy

☛

SAP_BASIS (Software Component) SAP Basis Component
⤷

BC-DB-DB2 (Application Component) DB2 for z/OS
⤷

STU3 (Package) Development Class for Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	DB2TIMESD	Table Relationship Diagram
Short Description	Thread Activity: Times Distribution

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Short Description
1	ACTELAP	DB2TDACTEL	DB2CHAR16	CHAR	16	Total elapsed activity time
2	INDB2	DB2TINDB2	DB2CHAR16	CHAR	16	Accumulated elapsed time in DB2
3	CPUINDB2	DB2TCPUIN	DB2CHAR16	CHAR	16	CPU time spent in DB2
4	SUSPINDB2	DB2TSUSPIN	DB2CHAR16	CHAR	16	Time spent suspended in DB2
5	OTHRINDB2	DB2TOTHINE	DB2CHAR16	CHAR	16	Time spent for other waits in DB2
6	OUTDB2	DB2OUTDB2	DB2CHAR16	CHAR	16	Time spent out of DB2
7	CPUTOT	DB2CPUTOT	DB2CHAR16	CHAR	16	Total CPU processing time
8	AVGINDB2	DB2TINDB2A	DB2CHAR16	CHAR	16	Average interval between DB2 entry and exit events
9	AVGCPUIN	DB2TCPUINA	DB2CHAR16	CHAR	16	Average CPU time spent in DB2
10	SPINELAP	DB2TDSPINE	DB2CHAR16	CHAR	16	Total elapsed time spent executing SQL in stored procedures
11	SPELAP	DB2SPELAP	DB2CHAR16	CHAR	16	Total elapsed time spent in stored procedures
12	SPINCPU	DB2TSSPINC	DB2CHAR16	CHAR	16	CPU processing time for SQL statements in stored procedures
13	SPCPU	DB2TSPCPU	DB2CHAR16	CHAR	16	CPU time for SQL statements in the stored procedures AS
14	AVGSPIN	DB2TDSPINA	DB2CHAR16	CHAR	16	Average stored procedure entry/exit duration
15	AVGSPINCPU	DB2TDSPICA	DB2CHAR16	CHAR	16	Average CPU processing between stored procedure entry/exit
16	UDFINELAP	DB2TUDFINE	DB2CHAR16	CHAR	16	Total elapsed time spent for user def. func. to execute SQL
17	UDFINCPU	DB2TUDFINC	DB2CHAR16	CHAR	16	CPU time for processing SQL statements issued by UDFs
18	UDFELAP	DB2TUDFELA	DB2CHAR16	CHAR	16	Total elapsed time spent in user-defined functions
19	UDFCPU	DB2TUDFCPU	DB2CHAR16	CHAR	16	CPU time for user defined functions
20	AVGUDFIN	DB2TUDFINA	DB2CHAR16	CHAR	16	User defined function entry/exit duration
21	AVGUDFCPU	DB2TUDFICA	DB2CHAR16	CHAR	16	Average CPU time for SQL statements issued by UDFs
22	TRGELAP	DB2TTRGE	DB2CHAR16	CHAR	16	Time used while executing under the control of triggers
23	TRGCPU	DB2TTRGCPU	DB2CHAR16	CHAR	16	TCB time used while executing under the control of triggers
24	TRGCPUENC	DB2TTRGCEN	DB2CHAR16	CHAR	16	TCB time used for executing triggers under an enclave
25	TRGENC	DB2TTRGENC	DB2CHAR16	CHAR	16	Elapsed time used for executing triggers under an enclave
26	TRGCPUINBE	DB2TTRGICB	DB2CHAR16	CHAR	16	CPU time for processing SQL stmts. before enclave is created
27	TRGCPUBE	DB2TTRGCBE	DB2CHAR16	CHAR	16	Accumulated TCB time used before the enclave is created
28	IFIELAP	DB2TIFIE	DB2CHAR16	CHAR	16	Accumulated elapsed time spent processing IFI calls
29	IFICPU	DB2TIFICPU	DB2CHAR16	CHAR	16	Accumulated CPU time spent processing IFI calls
30	AVGIFIELAP	DB2TIFIA	DB2CHAR16	CHAR	16	Average IFI entry/exit duration
31	AVGIFICPU	DB2IFICPUA	DB2CHAR16	CHAR	16	Average IFI entry/exit CPU time