DB2TIMESC SAP (DB2 Times) Structure details

Dictionary Type: Structure
Description: DB2 Times




ABAP Code to SELECT data from DB2TIMESC
Related tables to DB2TIMESC
Access table DB2TIMESC




Structure field list including key, data, relationships and ABAP select examples

DB2TIMESC is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DB2 Times" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DB2TIMESC TYPE DB2TIMESC.

The DB2TIMESC table consists of various fields, each holding specific information or linking keys about DB2 Times data available in SAP. These include THDTCPUTOT (Total System z CPU time including DB2), THDTINB2 (Accumulated Elapsed Time in DB2), THDTCPUIN (CPU time spent in DB2), THDTSUSPIN (Time spent suspended in DB2).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP DB2TIMESC structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
THDTOUDB2Time spent out of DB2 DB2OUTDB2CDEC16DB2DEC16
THDTCPUTOTTotal System z CPU time including DB2 DB2TCPUTOCDEC16DB2DEC16
THDTINB2Accumulated Elapsed Time in DB2 DB2TINDB2CDEC16DB2DEC16
THDTCPUINCPU time spent in DB2 DB2TCPUINCDEC16DB2DEC16
THDTSUSPINTime spent suspended in DB2 DB2TSUSPICDEC16DB2DEC16
THDTNAINDBNot attributed time in DB2 DB2TNAINDCDEC16DB2DEC16
THDTIOI/O suspension time DB2TIOCDEC16DB2DEC16
THDTLKLALock / Latch Supension Time DB2TLKLACDEC16DB2DEC16
THDTOTHROther read suspensions time DB2TOTHRCDEC16DB2DEC16
THDTOTHWOther write suspensions time DB2TOTHWCDEC16DB2DEC16
THDTSRVTNumber of waits for commit phase II or abort DB2TSRVTCDEC16DB2DEC16
THDTARCHQArchive log quiesce suspension time DB2TARCHCCDEC16DB2DEC16
THDTDRLKDrain lock suspension time DB2TDRLKCDEC16DB2DEC16
THDTCLRELClaim release suspension time DB2TCLRECCDEC16DB2DEC16
THDTARCHRArchive read suspension time DB2TARCCCDEC16DB2DEC16
THDTPGLAPage latch suspension time DB2TPGLACDEC16DB2DEC16
THDTNOTMNotify messages suspension time DB2TNOTMCDEC16DB2DEC16
THDTGLOBTMGlobal locking suspension time DB2TGLOBCCDEC16DB2DEC16
THDTIOENumber of I/O suspensions DB2TIOECINT410DB2INT4
THDTLKLAENumber of Lock / Latch Suspensions DB2TLKLAECINT410DB2INT4
THDTOTHRENumber of other read suspensions DB2TOTHRECINT410DB2INT4
THDTOTHWENumber of other write suspensions DB2TOTHWECINT410DB2INT4
THDTSRVTENumber of waits for commit phase II or abort DB2TSRVTECINT410DB2INT4
THDTARCHQENumber of archive log quiesce suspensions DB2TARCHQCINT410DB2INT4
THDTDRLKENumber of Drain Lock Suspensions DB2TDRLKECINT410DB2INT4
THDTCLRELENumber of Claim Release Suspensions DB2TCLRELCINT410DB2INT4
THDTARCHRENumber of Archive Read Suspensions DB2TARCHRCINT410DB2INT4
THDTPGLAENumber of Page Latch Suspensions DB2TPGLAECINT410DB2INT4
THDTNOTMENumber of Notify Messages Suspensions DB2TNOTMECINT410DB2INT4
THDTGLOBTENumber of Global Locking Suspensions DB2TGLOBTCINT410DB2INT4
THDTACTTActivity time (Class 1 elapsed time) [hh:mm:ss.ms] DB2THDTACCDEC16DB2DEC16
THDTOCSTWait time for open/close service task (incl. HSM recall) DB2TOCSTCDEC16DB2DEC16
THDTSLSTWait time for SYSLGRNG recording service task DB2TSLSTCDEC16DB2DEC16
THDTDSSTWait time for data set extend/delete/define service task DB2TDSSTCDEC16DB2DEC16
THDTOTHRSTWait time for other service tasks DB2TOTHRCCDEC16DB2DEC16
THDTLOGW DB2LOGWCDEC16DB2DEC16
THDTOCSTENumber of waits for open/close service task DB2TOCSTECINT410DB2INT4
THDTSLSTENumber of waits for SYSLGRNG recording service task DB2TSLSTECINT410DB2INT4
THDTDSSTENumber of waits for data set ext./del./def. service task DB2TDSSTECINT410DB2INT4
THDTOTHRSENumber of waits for other service tasks DB2TOTHRSCINT410DB2INT4
THDTLOGWE DB2LOGWECINT410DB2INT4
THDTCOMMNumber of successful phase 2 or single-phase commit requests DB2TCOMMCINT410DB2INT4
THDTABRTNumber of rollback requests DB2TABRTCINT410DB2INT4
QWACCAST Wait time in DB2 for an available TCB to schedule the SP0
QWACUDST Wait time in DB2 for an available TCB to schedule the UDF0
AWACCAST Avg. duration of suspensions for SPs0
QWACCANM Number of suspensions for available TCB to schedule SP0
THDTSTP Accumulated TCB time used for stored procedure requests0
THDTSTPSQL Accumulated TCB time for SQL issued by stored procs0
THDTSTPSQLE the number of SQLs stmts performed by stored procedures0
THDTUDCP Accumulated TCB time used for user-defined functions (UDFs)0
THDTUDTT Accumulated TCB time for SQL issued by UDFS0
THDTUDNE the number of SQLs stmts performed by UDFs0
THDTUDEA total elapsed time for UDF0
THDTUDEB total elapsed time for UDF executing SQL0
THDTTRTT accumulated TCB time by exec. triggers not under enclave0
THDTTRET accumulated elapsed time exec. triggers not under enclave0
THDTPECT accumulated TCB time prior to enclave creation time0
THDTTRTE accumulated TCB time executing triggers under an enclave0
THDTTREE accumulated elapsed time expended executing under an encalve0
THDTAWTK wait time due to global contention for child L-locks0
THDTAWTM wait time due to global contention for other L-locks0
THDTAWTN wait time due to global contention pageset/partition P-locks0
THDTAWTO wait time due to global contention for page P-locks0
THDTAWTQ wait time due to global contention for other P-locks0
THDTARTK Number of wait trace events for child L-locks0
THDTARTM Number of wait trace events for other L-locks0
THDTARTN Number of wait trace events pageset/partition P-locks0
THDTARTO Number of wait trace events for page P-locks0
THDTARTQ Number of wait trace events for other P-locks0
THDTAWLG Wait time due to log write I/O0
THDTARLG Number of wait trace events for log write I/O0
QWACCLS1_ZIIP Accumulated CPU time executed on zIIP in all environments0
QWACCLS2_ZIIP Accumulated CPU time executed on zIIP in DB20
QWACTRTT_ZIIP Accumulated CPU time consumed executing triggers on zIIP0
QWACZIIP_ELIGIBLE Acumc. CPU time executed on standard CPU eligible for zIIP0
QWACSPNF_ZIIP Accumulated CPU time executing stored procedures on zIIP0
QWACUDFNF_ZIIP Reserved0
ZIIP12ACT Total class 1 zIIP CPU time / Activity time0
ZIIP2ACT Total zIIP CPU time / Activity time0
ZIIPEL2ACT Total eligible zIIP CPU time / Activity time0
ZIIP2DB2T Total zIIP CPU time / time spent in DB20
ZIIPEL2DB2T Total eligible zIIP CPU time / time spent in DB20

Key field Non-key field



How do I retrieve data from SAP structure DB2TIMESC using ABAP code?

As DB2TIMESC is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DB2TIMESC as there is no data to select.

How to access SAP table DB2TIMESC

Within an ECC or HANA version of SAP you can also view further information about DB2TIMESC and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!