DB2QISE SAP (EDM Pool Statistics) Structure details
Description: EDM Pool Statistics
Structure field list including key, data, relationships and ABAP select examples
DB2QISE 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 "EDM Pool Statistics" 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_DB2QISE TYPE DB2QISE.
The DB2QISE table consists of various fields, each holding specific information or linking keys about EDM Pool Statistics data available in SAP. These include QISEPAGE (Current number of pages in the EDM pool), QISECTG (Number of requests for cursor table sections), QISECTL (Number of CT sections not found in EDM pool), QISECT (Current number of pages in EDM pool used for cursor tables).. 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 DB2QISE 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 |
| QISEFAIL | Field type numc, length 10, integer | DB2NUMC10 | INT4 | 10 | DB2INT4 | ||||
| QISEPAGE | Current number of pages in the EDM pool | DB2ISEPAGE | DEC | 10 | DB2DEC10V | ||||
| QISECTG | Number of requests for cursor table sections | DB2ISECTG | DEC | 10 | DB2DEC10V | ||||
| QISECTL | Number of CT sections not found in EDM pool | DB2ISECTL | DEC | 10 | DB2DEC10V | ||||
| QISECT | Current number of pages in EDM pool used for cursor tables | DB2ISECT | DEC | 10 | DB2DEC10V | ||||
| QISEFREE | Current number of free pages in the free chain | DB2ISEFREE | DEC | 10 | DB2DEC10V | ||||
| QISEDBD | Current number of pages in EDM pool used for DB descriptor | DB2ISEDBD | DEC | 10 | DB2DEC10V | ||||
| QISESKCT | Current number of pages in EDM pool used for skeleton CT | DB2ISESKCT | DEC | 10 | DB2DEC10V | ||||
| QISEDBDG | Number of requests for database descriptor | DB2ISEDBDG | DEC | 10 | DB2DEC10V | ||||
| QISEDBDL | Number of DB descriptors not found in EDM pool | DB2ISEDBDL | DEC | 10 | DB2DEC10V | ||||
| QISEKTG | Number of requests for package table sections | DB2ISEKTG | DEC | 10 | DB2DEC10V | ||||
| QISEKTL | Number of times a PT section was not found in EDM pool | DB2ISEKTL | DEC | 10 | DB2DEC10V | ||||
| QISEKT | Current number of pages in EDM pool used for package tables | DB2ISEKT | DEC | 10 | DB2DEC10V | ||||
| QISESKPT | Current number of pages in EDM pool used for skeleton PT | DB2ISESKPT | DEC | 10 | DB2DEC10V | ||||
| QISEDSI | Number of inserts into EDM pool for dynamic statement cache | DB2ISEDSI | DEC | 10 | DB2DEC10V | ||||
| QISEDSG | Number of requests for DSC sections | DB2ISEDSG | DEC | 10 | DB2DEC10V | ||||
| QISEDSC | Number of pages used for DSC | DB2ISEDSC | DEC | 10 | DB2DEC10V | ||||
| QISEDFAL | Number of failures because the data space is full | DB2ISEDFAL | DEC | 10 | DB2DEC10V | ||||
| QISEDPGE | Number of pages in the data space used by the EDM pool | DB2ISEDPGE | DEC | 10 | DB2DEC10V | ||||
| QISEDFRE | Number of free pages in the data space free chain | DB2ISEDFRE | DEC | 10 | DB2DEC10V | ||||
| QISECPGE | Number of pages in EDM statement pool Number of pages in EDM statement pool | DB2ISECPGE | INT4 | 10 | DB2INT4 | ||||
| QISECFRE | Number of free pages in EDM statement pool Number of free pages in EDM statement pool | DB2ISECFRE | INT4 | 10 | DB2INT4 | ||||
| QISESTMT | Number of statements in EDM pool for dynamic statement cache Number of statements in EDM pool for dynamic statement cache | DB2ISESTMT | DEC | 10 | DB2DEC10V |
| Key field | Non-key field |
How do I retrieve data from SAP structure DB2QISE using ABAP code?
As DB2QISE 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 DB2QISE as there is no data to select.How to access SAP table DB2QISE
Within an ECC or HANA version of SAP you can also view further information about DB2QISE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects