DB2QW225 SAP (IFCID 0225 shows usage of virtual storage of DBM1) Structure details

Dictionary Type: Structure
Description: IFCID 0225 shows usage of virtual storage of DBM1




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




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

DB2QW225 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 "IFCID 0225 shows usage of virtual storage of DBM1" 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_DB2QW225 TYPE DB2QW225.

The DB2QW225 table consists of various fields, each holding specific information or linking keys about IFCID 0225 shows usage of virtual storage of DBM1 data available in SAP. These include QW0225AS (TOTAL AGENT SYSTEM STORAGE), QW0225AV (AMOUNT OF AVAILABLE STORAGE), QW0225CD (TOTAL STORAGE FOR COMPRESSION DICTIONARY), QW0225CR (TOTAL STORAGE RESERVED FOR MUST-COMPLETE OPERATIONS).. 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 DB2QW225 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
QW0225ALTOTAL AGENT LOCAL POOL STORAGE DB2W225ALINT410DB2INT4
QW0225ASTOTAL AGENT SYSTEM STORAGE DB2W225ASINT410DB2INT4
QW0225AVAMOUNT OF AVAILABLE STORAGE DB2W225AVINT410DB2INT4
QW0225CDTOTAL STORAGE FOR COMPRESSION DICTIONARY DB2W225CDDEC19DB2DEC19V
QW0225CRTOTAL STORAGE RESERVED FOR MUST-COMPLETE OPERATIONS DB2W225CRINT410DB2INT4
QW0225FXTOTAL FIXED STORAGE DB2W225FXINT410DB2INT4
QW0225GMTOTAL GETMAINED STORAGE DB2W225GMINT410DB2INT4
QW0225GSTOTAL GETMAINED STACK STORAGE DB2W225GSINT410DB2INT4
QW0225MVTOTAL AMOUNT OF STORAGE FOR MVS USE DB2W225MVINT410DB2INT4
QW0225PMTOTAL STORAGE FOR PIPE MANAGER SUBPOOL DB2W225PMINT410DB2INT4
QW0225ROTOTAL STORAGE FOR RDS OP POOL DB2W225ROINT410DB2INT4
QW0225RPTOTAL STORAGE FOR RID POOL DB2W225RPDEC19DB2DEC19V
QW0225SBTOTAL STORAGE FOR STATEMENT CACHE BLOCK DB2W225SBINT410DB2INT4
QW0225SCTOTAL STORAGE FOR THREAD COPIES OF CACHED SQL STATEMENTS DB2W225SCINT410DB2INT4
QW0225SOSTORAGE CUSHION WARNING TO CONTRACT DB2W225SOINT410DB2INT4
QW0225TTTOT. STOR. BUFFER MANAGER OR DATA MANAGER INT. TRACE TABLE DB2W225TTINT410DB2INT4
QW0225VRTOTAL VARIABLE STORAGE DB2W225VRINT410DB2INT4
QW0225ATNUMBER OF ACTIVE ALLIED THREADS DB2W225ATINT410DB2INT4
QW0225CENUMBER OF CASTOUT ENGINES DB2W225CEINT410DB2INT4
QW0225DWNUMBER OF DEFERRED WRITE ENGINES DB2W225DWINT410DB2INT4
QW0225GWNUMBER OF GBP WRITE ENGINES DB2W225GWINT410DB2INT4
QW0225PFNUMBER OF PREFETCH ENGINES DB2W225PFINT410DB2INT4
QW0225PLNUMBER OF P-LOCK/NOTIFY EXIT ENGINES DB2W225PLINT410DB2INT4
QW0225SJ Total storage for star join pool0
QW0225LO MVS 16 MB low private storage0
QW0225HI MVS 16 MB high private storage0
QW0225EL MVS 2 GB extended low private storage0
QW0225EH MVS 2 GB extended high private storage0
QW0225RG MVS maximum extended region size0
QW0225EC MVS extended CSA size0
QW0225FAprivate fixed pool storage DB2W225FADEC19DB2DEC19V
QW0225GAprivate getmained storage DB2W225GADEC19DB2DEC19V
QW0225VAprivate variable pool storage DB2W225VADEC19DB2DEC19V
QW0225LC Number of statements in CACHED SQL STATEMENTS pools0
QW0225LS Allocated storage for local statement cache0
QW0225HS High water mark allocated storage for local statement cache0
QW0225HC High water mark # of stmts.in local DSC at high storage time0
HWDSCDATEField of type DATS DATSDATS8DATS
HWDSCTIMEField of type TIMS TIMSTIMS6TIME
HWDSCMSECEvent time stamp (milliseconds) DB2EVTTMSCHAR6DB2CHAR06
QW0225RLNumber of real frames (4K) in use DB2W225RLDEC19DB2DEC19V
QW0225AXNumber of auxiliary slots (4k) in use DB2W225AXDEC19DB2DEC19V
QW0225SFTotal fixed shared 64-bit storage DB2W225SFDEC19DB2DEC19V
QW0225SGTotal GETMAINed shared 64-bit storage DB2W225SGDEC19DB2DEC19V
QW0225SVTotal variable shared 64-bit storage DB2W225SVDEC19DB2DEC19V
QW0225SUTotal 31-bit stack storage in use DB2W225SUDEC19DB2DEC19V
QW0225L2Allocated statement cache storage in 64-bit agent local pool DB2W225L2DEC19DB2DEC19V
QW0225H2High water mark for alloc. stmt cache storage in 64-bit pool DB2W225H2DEC19DB2DEC19V
QW0225S2Total 64-bit STMT CACHE BLOCKS 2G storage DB2W225S2DEC19DB2DEC19V

Key field Non-key field



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

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

How to access SAP table DB2QW225

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