DB2QW225 SAP (IFCID 0225 shows usage of virtual storage of DBM1) Structure details
Description: IFCID 0225 shows usage of virtual storage of DBM1
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 |
QW0225AL | TOTAL AGENT LOCAL POOL STORAGE | DB2W225AL | INT4 | 10 | DB2INT4 | ||||
QW0225AS | TOTAL AGENT SYSTEM STORAGE | DB2W225AS | INT4 | 10 | DB2INT4 | ||||
QW0225AV | AMOUNT OF AVAILABLE STORAGE | DB2W225AV | INT4 | 10 | DB2INT4 | ||||
QW0225CD | TOTAL STORAGE FOR COMPRESSION DICTIONARY | DB2W225CD | DEC | 19 | DB2DEC19V | ||||
QW0225CR | TOTAL STORAGE RESERVED FOR MUST-COMPLETE OPERATIONS | DB2W225CR | INT4 | 10 | DB2INT4 | ||||
QW0225FX | TOTAL FIXED STORAGE | DB2W225FX | INT4 | 10 | DB2INT4 | ||||
QW0225GM | TOTAL GETMAINED STORAGE | DB2W225GM | INT4 | 10 | DB2INT4 | ||||
QW0225GS | TOTAL GETMAINED STACK STORAGE | DB2W225GS | INT4 | 10 | DB2INT4 | ||||
QW0225MV | TOTAL AMOUNT OF STORAGE FOR MVS USE | DB2W225MV | INT4 | 10 | DB2INT4 | ||||
QW0225PM | TOTAL STORAGE FOR PIPE MANAGER SUBPOOL | DB2W225PM | INT4 | 10 | DB2INT4 | ||||
QW0225RO | TOTAL STORAGE FOR RDS OP POOL | DB2W225RO | INT4 | 10 | DB2INT4 | ||||
QW0225RP | TOTAL STORAGE FOR RID POOL | DB2W225RP | DEC | 19 | DB2DEC19V | ||||
QW0225SB | TOTAL STORAGE FOR STATEMENT CACHE BLOCK | DB2W225SB | INT4 | 10 | DB2INT4 | ||||
QW0225SC | TOTAL STORAGE FOR THREAD COPIES OF CACHED SQL STATEMENTS | DB2W225SC | INT4 | 10 | DB2INT4 | ||||
QW0225SO | STORAGE CUSHION WARNING TO CONTRACT | DB2W225SO | INT4 | 10 | DB2INT4 | ||||
QW0225TT | TOT. STOR. BUFFER MANAGER OR DATA MANAGER INT. TRACE TABLE | DB2W225TT | INT4 | 10 | DB2INT4 | ||||
QW0225VR | TOTAL VARIABLE STORAGE | DB2W225VR | INT4 | 10 | DB2INT4 | ||||
QW0225AT | NUMBER OF ACTIVE ALLIED THREADS | DB2W225AT | INT4 | 10 | DB2INT4 | ||||
QW0225CE | NUMBER OF CASTOUT ENGINES | DB2W225CE | INT4 | 10 | DB2INT4 | ||||
QW0225DW | NUMBER OF DEFERRED WRITE ENGINES | DB2W225DW | INT4 | 10 | DB2INT4 | ||||
QW0225GW | NUMBER OF GBP WRITE ENGINES | DB2W225GW | INT4 | 10 | DB2INT4 | ||||
QW0225PF | NUMBER OF PREFETCH ENGINES | DB2W225PF | INT4 | 10 | DB2INT4 | ||||
QW0225PL | NUMBER OF P-LOCK/NOTIFY EXIT ENGINES | DB2W225PL | INT4 | 10 | DB2INT4 | ||||
QW0225SJ | Total storage for star join pool | 0 | |||||||
QW0225LO | MVS 16 MB low private storage | 0 | |||||||
QW0225HI | MVS 16 MB high private storage | 0 | |||||||
QW0225EL | MVS 2 GB extended low private storage | 0 | |||||||
QW0225EH | MVS 2 GB extended high private storage | 0 | |||||||
QW0225RG | MVS maximum extended region size | 0 | |||||||
QW0225EC | MVS extended CSA size | 0 | |||||||
QW0225FA | private fixed pool storage | DB2W225FA | DEC | 19 | DB2DEC19V | ||||
QW0225GA | private getmained storage | DB2W225GA | DEC | 19 | DB2DEC19V | ||||
QW0225VA | private variable pool storage | DB2W225VA | DEC | 19 | DB2DEC19V | ||||
QW0225LC | Number of statements in CACHED SQL STATEMENTS pools | 0 | |||||||
QW0225LS | Allocated storage for local statement cache | 0 | |||||||
QW0225HS | High water mark allocated storage for local statement cache | 0 | |||||||
QW0225HC | High water mark # of stmts.in local DSC at high storage time | 0 | |||||||
HWDSCDATE | Field of type DATS | DATS | DATS | 8 | DATS | ||||
HWDSCTIME | Field of type TIMS | TIMS | TIMS | 6 | TIME | ||||
HWDSCMSEC | Event time stamp (milliseconds) | DB2EVTTMS | CHAR | 6 | DB2CHAR06 | ||||
QW0225RL | Number of real frames (4K) in use | DB2W225RL | DEC | 19 | DB2DEC19V | ||||
QW0225AX | Number of auxiliary slots (4k) in use | DB2W225AX | DEC | 19 | DB2DEC19V | ||||
QW0225SF | Total fixed shared 64-bit storage | DB2W225SF | DEC | 19 | DB2DEC19V | ||||
QW0225SG | Total GETMAINed shared 64-bit storage | DB2W225SG | DEC | 19 | DB2DEC19V | ||||
QW0225SV | Total variable shared 64-bit storage | DB2W225SV | DEC | 19 | DB2DEC19V | ||||
QW0225SU | Total 31-bit stack storage in use | DB2W225SU | DEC | 19 | DB2DEC19V | ||||
QW0225L2 | Allocated statement cache storage in 64-bit agent local pool | DB2W225L2 | DEC | 19 | DB2DEC19V | ||||
QW0225H2 | High water mark for alloc. stmt cache storage in 64-bit pool | DB2W225H2 | DEC | 19 | DB2DEC19V | ||||
QW0225S2 | Total 64-bit STMT CACHE BLOCKS 2G storage | DB2W225S2 | DEC | 19 | DB2DEC19V |
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 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