DB2QTHDDSC SAP (content dynamic statement cache) Structure details

Dictionary Type: Structure
Description: content dynamic statement cache




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




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

DB2QTHDDSC 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 "content dynamic statement cache" 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_DB2QTHDDSC TYPE DB2QTHDDSC.

The DB2QTHDDSC table consists of various fields, each holding specific information or linking keys about content dynamic statement cache data available in SAP. These include USERID (), QSTCTOKN (Statement ID), QSTCSTNM (DB2 statement name), QSTCUSE (Current Copies).. 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 DB2QTHDDSC 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
MEMBNMDB2 member name in data sharing environment DB2MEMNCHAR8DB2CHAR08
USERID DB2USERIDINT25DB2SINT
QSTCTOKNStatement ID DB2QSTTOKNINT410DB2INT4
QSTCSTNMDB2 statement name DB2QSTSTNMRAW16DB2RAW16
QSTCUSECurrent Copies DB2QSTUSEDEC19DB2DEC19V
QSTCCOPYNumber of copies of the statement DB2QSTCOPYINT410DB2INT4
QSTCSTATStatus of the statement DB2QSTSTATCHAR30DB2CHAR30
QSTCISTMTime when statement was inserted into cache DB2QSTISTMRAW10DB2RAW10
QSTCEXECNumber of executions of the statement DB2QSTEXECDEC19DB2DEC19V
QSTCRBUFSynchronous Reads DB2QSTRBUFDEC19DB2DEC19V
QSTCGPAGGetpages DB2QSTGPAGDEC19DB2DEC19V
DSTCGPAG Getpages (decimal)0
QSTCEROWRows examined (Only data rows are taken into account) DB2QSTEROWDEC19DB2DEC19V
DSTCEROW Rows Examined (new type)0
QSTCPROWRows Processed DB2QSTPROWDEC19DB2DEC19V
DSTCPROW Rows Processed (new type)0
QSTCSORTNumber of sorts performed for statement DB2QSTSORTDEC19DB2DEC19V
QSTCINDXNumber of index scans performed for statement DB2QSTINDXDEC19DB2DEC19V
QSTCTSCNNumber of tablespace scans performed for statement DB2QSTTSCNDEC19DB2DEC19V
QSTCPLGPNumber of parallel groups created for statement DB2QSTPLGPDEC19DB2DEC19V
QSTCWRITSynchronous Writes DB2QSTWRITDEC19DB2DEC19V
QSTCAETTime elapsed DB2QSTAETDEC16DB2DEC16
QSTCSTLNThe length of the SQL Statement DB2QSTSTLNINT25INT2
QSTCSTMTStatement text DB2QSTSTMTCHAR255
QW0316L1Length of program name DB2QW316L1INT25INT2
QW0316T1Program name DB2QW316T1CHAR128CHAR128
QW0316LXStatement Line Number DB2QW316LXINT410DB2INT4
QW0316L2Length of transaction name DB2QW316L2INT25INT2
QW0316T2Transaction name DB2QW316T2CHAR32DB2CHAR32
QW0316L3Length of user ID DB2QW316L3INT25INT2
QW0316T3User ID DB2QW316T3CHAR128CHAR128
QW0316X4User group DB2QW316X4CHAR128CHAR128
QW0316X5The value of QUALIFIER bind option DB2QW316X5CHAR128CHAR128
QW0316X6ISOLATION DB2QW316X6CHAR3DB2CHAR03
QW0316X7TCURRENTDATA DB2QW316X7CHAR3DB2CHAR03
QW0316X8TDYNAMICRULES DB2QW316X8CHAR4DB2CHAR04
QW0316X9TCURRENT DEGREE DB2QW316X9CHAR3DB2CHAR03
QW0316XATCURRENT RULES DB2QW316XACHAR3DB2CHAR03
QW0316XBTCURRENT PRECISION DB2QW316XBCHAR5DB2CHAR05
QW0316XCTWITH HOLD DB2QW316XCCHAR3DB2CHAR03
QW0316TSTimestamp: Begin of Statistics Collection DB2QW316TSDEC16DB2DEC16
QW0316CTAccumulated CPU Time DB2QW316CTDEC16DB2DEC16
QW0316W1Accumulated Wait Time for Synchronous I/O DB2QW316W1DEC16DB2DEC16
QW0316W2Accumulated Wait Time for Lock and Latch Req. DB2QW316W2DEC16DB2DEC16
QW0316W3Accumulated Wait Time for Sync. Execution Unit Switch DB2QW316W3DEC16DB2DEC16
QW0316W4Accumulated Wait Time for Global Locks DB2QW316W4DEC16DB2DEC16
QW0316W5Accumulated Wait Time for Read Activity by Another Thread DB2QW316W5DEC16DB2DEC16
QW0316W6Accumulated Wait Time for Write Activity by Another Thread DB2QW316W6DEC16DB2DEC16
QW0316RTRID List Not Used due to DB2 Limits Exceeded DB2QW316RTDEC19DB2DEC19V
QW0316RSRID List Not Used due to Insufficient Storage DB2QW316RSDEC19DB2DEC19V
QW0316UISAP provided identification of SQL statements DB2QW316UICHAR128CHAR128
QW0316TDName of the table referenced in the statement DB2QW316TDCHAR128CHAR128
BIND_RA_TOT Number of rebinds that have been issued due to REOPT(AUTO)0
BIND_RO_TYPE REOPT bind option valid for statement0
QW0317NMSQL STATEMENT NAM DB2W0317NMCHAR16CHAR16
QW0317IDSQL STATEMENT IDENTIFIER DB2W0317IDINT410
QW0317LNTHE LENGTH OF THE SQL STMT DB2W0317LNINT410
QW0317TXSQL statement text DB2W0317TXLCHR30720DB2C30K
QW03172LNTHE LENGTH OF THE SQL STMT DB2W0317LNINT410
QW03172TXStatement text DB2QSTSTMTCHAR255

Key field Non-key field



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

As DB2QTHDDSC 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 DB2QTHDDSC as there is no data to select.

How to access SAP table DB2QTHDDSC

Within an ECC or HANA version of SAP you can also view further information about DB2QTHDDSC 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!