DB2QW225_V10 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_V10 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_V10 TYPE DB2QW225_V10.
The DB2QW225_V10 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 DIST_QW0225LO (MVS 16 MB low private storage), DIST_QW0225HI (MVS 16 MB high private storage), DIST_QW0225EL (MVS 2 GB extended low private storage), DIST_QW0225EH (MVS 2 GB extended high private storage).. 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_V10 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 |
DIST_QW0225RG | MVS maximum extended region size | 0 | |||||||
DIST_QW0225LO | MVS 16 MB low private storage | 0 | |||||||
DIST_QW0225HI | MVS 16 MB high private storage | 0 | |||||||
DIST_QW0225EL | MVS 2 GB extended low private storage | 0 | |||||||
DIST_QW0225EH | MVS 2 GB extended high private storage | 0 | |||||||
DIST_QW0225TP | Current high address of 24-bit private region | 0 | |||||||
DIST_QW0225EP | Current high address of 31-bit private region | 0 | |||||||
DIST_QW0225CR | TOTAL STORAGE RESERVED FOR MUST-COMPLETE OPERATIONS | DB2W225CR | INT4 | 10 | DB2INT4 | ||||
DIST_QW0225MV | TOTAL AMOUNT OF STORAGE FOR MVS USE | DB2W225MV | INT4 | 10 | DB2INT4 | ||||
DIST_QW0225SO | STORAGE CUSHION WARNING TO CONTRACT | DB2W225SO | INT4 | 10 | DB2INT4 | ||||
DIST_QW0225GS | TOTAL GETMAINED STACK STORAGE | DB2W225GS | INT4 | 10 | DB2INT4 | ||||
DIST_QW0225SU | Total stack storage in use | 0 | |||||||
DIST_QW0225VR | TOTAL VARIABLE STORAGE | DB2W225VR | INT4 | 10 | DB2INT4 | ||||
DIST_QW0225FX | TOTAL FIXED STORAGE | DB2W225FX | INT4 | 10 | DB2INT4 | ||||
DIST_QW0225GM | TOTAL GETMAINED STORAGE | DB2W225GM | INT4 | 10 | DB2INT4 | ||||
DIST_QW0225AV | AMOUNT OF AVAILABLE STORAGE | DB2W225AV | INT4 | 10 | DB2INT4 | ||||
DIST_QW0225VA | private variable pool storage | DB2W225VA | DEC | 19 | DB2DEC19V | ||||
DIST_QW0225FA | private fixed pool storage | DB2W225FA | DEC | 19 | DB2DEC19V | ||||
DIST_QW0225GA | private getmained storage | DB2W225GA | DEC | 19 | DB2DEC19V | ||||
DIST_QW0225SM | Total 64-bit private storage f. stor. manager control struct | DB2W225SM | DEC | 19 | DB2DEC19V | ||||
DIST_QW0225RL | Number of real frames (4K) in use | DB2W225RL | DEC | 19 | DB2DEC19V | ||||
DIST_QW0225AX | Number of auxiliary slots (4k) in use | DB2W225AX | DEC | 19 | DB2DEC19V | ||||
DIST_QW0225HV_PAGES_IN_REAL | Number of real 4K frames in use for 64-bit private | DB2W225HV_PAGES_IN_REAL | DEC | 19 | DB2DEC19V | ||||
DIST_QW0225HV_AUX_SLOTS | Number of 4K auxiliary slots in use for 64-bit private | DB2W225HV_AUX_SLOTS | DEC | 19 | DB2DEC19V | ||||
DIST_QW0225HVG_PAGES_IN_REAL | High water mark for # of real 4K frames in use for 64-bit | DB2W225HVG_PAGES_IN_REAL | DEC | 19 | DB2DEC19V | ||||
DIST_QW0225HVG_AUX_SLOTS | High water mark for 4K aux. slots in use for 64-bit private | DB2W225HVG_AUX_SLOTS | DEC | 19 | DB2DEC19V | ||||
DBM1_QW0225RG | MVS maximum extended region size | 0 | |||||||
DBM1_QW0225LO | MVS 16 MB low private storage | 0 | |||||||
DBM1_QW0225HI | MVS 16 MB high private storage | 0 | |||||||
DBM1_QW0225EL | MVS 2 GB extended low private storage | 0 | |||||||
DBM1_QW0225EH | MVS 2 GB extended high private storage | 0 | |||||||
DBM1_QW0225TP | Current high address of 24-bit private region | 0 | |||||||
DBM1_QW0225EP | Current high address of 31-bit private region | 0 | |||||||
DBM1_QW0225CR | TOTAL STORAGE RESERVED FOR MUST-COMPLETE OPERATIONS | DB2W225CR | INT4 | 10 | DB2INT4 | ||||
DBM1_QW0225MV | TOTAL AMOUNT OF STORAGE FOR MVS USE | DB2W225MV | INT4 | 10 | DB2INT4 | ||||
DBM1_QW0225SO | STORAGE CUSHION WARNING TO CONTRACT | DB2W225SO | INT4 | 10 | DB2INT4 | ||||
DBM1_QW0225GS | TOTAL GETMAINED STACK STORAGE | DB2W225GS | INT4 | 10 | DB2INT4 | ||||
DBM1_QW0225SU | Total stack storage in use | 0 | |||||||
DBM1_QW0225VR | TOTAL VARIABLE STORAGE | DB2W225VR | INT4 | 10 | DB2INT4 | ||||
DBM1_QW0225FX | TOTAL FIXED STORAGE | DB2W225FX | INT4 | 10 | DB2INT4 | ||||
DBM1_QW0225GM | TOTAL GETMAINED STORAGE | DB2W225GM | INT4 | 10 | DB2INT4 | ||||
DBM1_QW0225AV | AMOUNT OF AVAILABLE STORAGE | DB2W225AV | INT4 | 10 | DB2INT4 | ||||
DBM1_QW0225VA | private variable pool storage | DB2W225VA | DEC | 19 | DB2DEC19V | ||||
DBM1_QW0225FA | private fixed pool storage | DB2W225FA | DEC | 19 | DB2DEC19V | ||||
DBM1_QW0225GA | private getmained storage | DB2W225GA | DEC | 19 | DB2DEC19V | ||||
DBM1_QW0225SM | Total 64-bit private storage f. stor. manager control struct | DB2W225SM | DEC | 19 | DB2DEC19V | ||||
DBM1_QW0225RL | Number of real frames (4K) in use | DB2W225RL | DEC | 19 | DB2DEC19V | ||||
DBM1_QW0225AX | Number of auxiliary slots (4k) in use | DB2W225AX | DEC | 19 | DB2DEC19V | ||||
DBM1_QW0225HV_PAGES_IN_REAL | Number of real 4K frames in use for 64-bit private | DB2W225HV_PAGES_IN_REAL | DEC | 19 | DB2DEC19V | ||||
DBM1_QW0225HV_AUX_SLOTS | Number of 4K auxiliary slots in use for 64-bit private | DB2W225HV_AUX_SLOTS | DEC | 19 | DB2DEC19V | ||||
DBM1_QW0225HVG_PAGES_IN_REAL | High water mark for # of real 4K frames in use for 64-bit | DB2W225HVG_PAGES_IN_REAL | DEC | 19 | DB2DEC19V | ||||
DBM1_QW0225HVG_AUX_SLOTS | High water mark for 4K aux. slots in use for 64-bit private | DB2W225HVG_AUX_SLOTS | DEC | 19 | DB2DEC19V | ||||
QW0225AT | NUMBER OF ACTIVE ALLIED THREADS | DB2W225AT | INT4 | 10 | DB2INT4 | ||||
QW0225DB | # of active and disconnected DBATs | 0 | |||||||
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 | ||||
QW0225EC | MVS extended CSA size | 0 | |||||||
QW0225FC | Total 31-bit common fixed pool storage | 0 | |||||||
QW0225VC | Total 31-bit common variable pool storage | 0 | |||||||
QW0225GC | Total 31-bit common getmained storage | 0 | |||||||
QW0225FCG | Total 64-bit common fixed pool storage | DB2W225FCG | DEC | 19 | DB2DEC19V | ||||
QW0225VCG | Total 64-bit common variable pool storage | DB2W225VCG | DEC | 19 | DB2DEC19V | ||||
QW0225GCG | Total 64-bit common getmained storage | DB2W225GCG | DEC | 19 | DB2DEC19V | ||||
QW0225SMC | Total 64-bit common storage f.storage manager control struct | DB2W225SMC | 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 64-bit shared variable pool storage | DB2WQW0225SV | DEC | 19 | DB2DEC19V | ||||
QW0225SMS | Total 64-bit private storage f. stor. manager control struct | DB2W225SM | DEC | 19 | DB2DEC19V | ||||
QW0225GSG_SYS | Total 64-bit shared system agent stack | DB2W225GSG_SYS | DEC | 19 | DB2DEC19V | ||||
QW0225SUG_SYS | Total 64-bit shared system agent stack in use | DB2W225SUG_SYS | DEC | 19 | DB2DEC19V | ||||
QW0225GSG | Total 64-bit shared non-system agent stack | DB2W225GSG | DEC | 19 | DB2DEC19V | ||||
QW0225SUG | Total 64-bit shared non-system agent stack in use | DB2W225SUG | DEC | 19 | DB2DEC19V | ||||
QW0225SHRNMOMB | Number of shared memory objects allocated for this MVS LPAR | 0 | |||||||
QW0225SHRPAGES | # of 64-bit shared memory pages alloc. for this MVS LPAR | DB2W225SHRPAGES | DEC | 19 | DB2DEC19V | ||||
QW0225SHRGBYTES | High water mark for # of 64-bit shared bytes for this MVS L. | DB2W225SHRGBYTES | DEC | 19 | DB2DEC19V | ||||
QW0225SHRINREAL | # of 64-bit shared pages backed in real storage (4K pages) | DB2W225SHRINREAL | DEC | 19 | DB2DEC19V | ||||
QW0225SHRAUXSLOTS | Number of auxiliary slots used for 64-bit shared storage | DB2W225SHRAUXSLOTS | DEC | 19 | DB2DEC19V | ||||
QW0225SHRPAGEINS | Number of 64-bit shared pages paged in from aux. storage | DB2W225SHRPAGEINS | DEC | 19 | DB2DEC19V | ||||
QW0225SHRPAGEOUTS | Number of 64-bit shared pages paged out to auxiliary storage | DB2W225SHRPAGEOUTS | DEC | 19 | DB2DEC19V | ||||
QW0225SC | TOTAL STORAGE FOR THREAD COPIES OF CACHED SQL STATEMENTS | DB2W225SC | INT4 | 10 | DB2INT4 | ||||
QW0225LC | Number of statements in CACHED SQL STATEMENTS pools | 0 | |||||||
QW0225LS | Allocated storage for local statement cache | 0 | |||||||
QW0225SX | Total 31-bit xPROC storage for static SQL statements | 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 | |||||||
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 | ||||
QW0225AL | TOTAL AGENT LOCAL POOL STORAGE | DB2W225AL | INT4 | 10 | DB2INT4 | ||||
QW0225AS | TOTAL AGENT SYSTEM STORAGE | DB2W225AS | INT4 | 10 | DB2INT4 | ||||
QW0225CD | TOTAL STORAGE FOR COMPRESSION DICTIONARY | DB2W225CD | DEC | 19 | DB2DEC19V | ||||
QW0225ALG | Total agent local storage (64-bit shared variable pools) | DB2W225ALG | DEC | 19 | DB2DEC19V | ||||
QW0225ASG | Total system agent storage (64-bit shared variable pools) | DB2W225ASG | DEC | 19 | DB2DEC19V | ||||
QW0225BB | Total buffer manager storage blocks (31-bit DBM1) | DB2W225BB | DEC | 19 | DB2DEC19V | ||||
QW0225RP | TOTAL STORAGE FOR RID POOL | DB2W225RP | DEC | 19 | DB2DEC19V | ||||
DIST_QW0225SS | Total 31-bit stack in use for system agents (DIST) | 0 | |||||||
DBM1_QW0225SS | Total 31-bit stack in use for system agents (DBM1) | 0 | |||||||
DBM1_QW0225PRI_STG_REAL | # of real 4 K frames in use for 64-bit priv. storage | DB2W225PRISTG_REAL | DEC | 19 | DB2DEC19V | ||||
DBM1_QW0225PRI_STG_AUX | # of real 4 K aux slots in use for 64-bit priv. storage | DB2W225PRISTG_AUX | DEC | 19 | DB2DEC19V | ||||
DIST_QW0225PRI_STG_REAL | # of real 4 K frames in use for 64-bit priv. storage | DB2W225PRISTG_REAL | DEC | 19 | DB2DEC19V | ||||
DIST_QW0225PRI_STG_AUX | # of real 4 K aux slots in use for 64-bit priv. storage | DB2W225PRISTG_AUX | DEC | 19 | DB2DEC19V | ||||
QW0225PT | # of active parallel child threads | 0 | |||||||
QW0225SHR_STG_REAL | # of real 4K frames in use for 64- bit shared storage | DB2W225SHRSTG_REAL | DEC | 19 | DB2DEC19V | ||||
QW0225SHR_STG_AUX | # of real 4 K aux slots in use for 64- bit shared storage | DB2W225SHRSTG_AUX | DEC | 19 | DB2DEC19V | ||||
QW0225SHR_STK_STG_REAL | # of real 4K frames in use for 64- bit shared stack storage | DB2W225SHRSTKSTG_REAL | DEC | 19 | DB2DEC19V | ||||
QW0225SHR_STK_STG_AUX | # of real 4K aux slots in use f 64- bit shared stack storage | DB2W225SHRSTKSTG_AUX | DEC | 19 | DB2DEC19V | ||||
QW0225COM_STG_REAL | # of real 4K frames in use for 64- bit common storage | DB2W225COMSTG_REAL | DEC | 19 | DB2DEC19V | ||||
QW0225COM_STG_AUX | # of real 4K aux slots in use for 64- bit common storage | DB2W225COMSTG_AUX | DEC | 19 | DB2DEC19V | ||||
REALSTORBP | Real storage in use for 64-bit - used by DB2 buffer pools | DB2REALSTORBP | DEC | 19 | DB2DEC19V | ||||
AUXSTORBP | Aux. storage in use for 64-bit - used by DB2 buffer pools | DB2AUXSTORBP | DEC | 19 | DB2DEC19V |
Key field | Non-key field |
How do I retrieve data from SAP structure DB2QW225_V10 using ABAP code?
As DB2QW225_V10 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_V10 as there is no data to select.How to access SAP table DB2QW225_V10
Within an ECC or HANA version of SAP you can also view further information about DB2QW225_V10 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