SAP Table DB2QW0225_V10
DB2 IFCID 225 - DBM1 virtual storage monitoring
DB2QW0225_V10 (DB2 IFCID 225 - DBM1 virtual storage monitoring) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link DB2QW0225_V10 to other SAP tables.
DB2QW0225_V10 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| STRGSSID | DB2 subsystem ID | DB2SWPSSID | CHAR | 4 | 0 | |||
| STRGMEMB | DB2 member name in data sharing environment | DB2MEMN | CHAR | 8 | 0 | |||
| STRGDATE | Field of type DATS | DATS | DATS | 8 | 0 | |||
| STRGTIME | Field of type TIMS | TIMS | TIMS | 6 | 0 | |||
| STGRMSEC | Event time stamp (milliseconds) | DB2EVTTMS | CHAR | 6 | 0 | |||
| STRGDSGN | DB2/390: Data sharing group | DB2DSGN | CHAR | 8 | 0 | |||
| DIST_QW0225RG | INT4 | 10 | 0 | |||||
| DIST_QW0225LO | INT4 | 10 | 0 | |||||
| DIST_QW0225HI | INT4 | 10 | 0 | |||||
| DIST_QW0225EL | INT4 | 10 | 0 | |||||
| DIST_QW0225EH | INT4 | 10 | 0 | |||||
| DIST_QW0225TP | CHAR | 10 | 0 | |||||
| DIST_QW0225EP | CHAR | 10 | 0 | |||||
| DIST_QW0225CR | TOTAL STORAGE RESERVED FOR MUST-COMPLETE OPERATIONS | DB2W225CR | INT4 | 10 | 0 | |||
| DIST_QW0225MV | TOTAL AMOUNT OF STORAGE FOR MVS USE | DB2W225MV | INT4 | 10 | 0 | |||
| DIST_QW0225SO | STORAGE CUSHION WARNING TO CONTRACT | DB2W225SO | INT4 | 10 | 0 | |||
| DIST_QW0225GS | TOTAL GETMAINED STACK STORAGE | DB2W225GS | INT4 | 10 | 0 | |||
| DIST_QW0225SU | INT4 | 10 | 0 | |||||
| DIST_QW0225VR | TOTAL VARIABLE STORAGE | DB2W225VR | INT4 | 10 | 0 | |||
| DIST_QW0225FX | TOTAL FIXED STORAGE | DB2W225FX | INT4 | 10 | 0 | |||
| DIST_QW0225GM | TOTAL GETMAINED STORAGE | DB2W225GM | INT4 | 10 | 0 | |||
| DIST_QW0225AV | AMOUNT OF AVAILABLE STORAGE | DB2W225AV | INT4 | 10 | 0 | |||
| DIST_QW0225VA | private variable pool storage | DB2W225VA | DEC | 19 | 0 | |||
| DIST_QW0225FA | private fixed pool storage | DB2W225FA | DEC | 19 | 0 | |||
| DIST_QW0225GA | private getmained storage | DB2W225GA | DEC | 19 | 0 | |||
| DIST_QW0225SM | Total 64-bit private storage f. stor. manager control struct | DB2W225SM | DEC | 19 | 0 | |||
| DIST_QW0225RL | Number of real frames (4K) in use | DB2W225RL | DEC | 19 | 0 | |||
| DIST_QW0225AX | Number of auxiliary slots (4k) in use | DB2W225AX | DEC | 19 | 0 | |||
| DIST_QW0225HV_PAGES_IN_REAL | Number of real 4K frames in use for 64-bit private | DB2W225HV_PAGES_IN_REAL | DEC | 19 | 0 | |||
| DIST_QW0225HV_AUX_SLOTS | Number of 4K auxiliary slots in use for 64-bit private | DB2W225HV_AUX_SLOTS | DEC | 19 | 0 | |||
| DIST_QW0225HVG_PAGES_IN_REAL | High water mark for # of real 4K frames in use for 64-bit | DB2W225HVG_PAGES_IN_REAL | DEC | 19 | 0 | |||
| DIST_QW0225HVG_AUX_SLOTS | High water mark for 4K aux. slots in use for 64-bit private | DB2W225HVG_AUX_SLOTS | DEC | 19 | 0 | |||
| DBM1_QW0225RG | INT4 | 10 | 0 | |||||
| DBM1_QW0225LO | INT4 | 10 | 0 | |||||
| DBM1_QW0225HI | INT4 | 10 | 0 | |||||
| DBM1_QW0225EL | INT4 | 10 | 0 | |||||
| DBM1_QW0225EH | INT4 | 10 | 0 | |||||
| DBM1_QW0225TP | CHAR | 10 | 0 | |||||
| DBM1_QW0225EP | CHAR | 10 | 0 | |||||
| DBM1_QW0225CR | TOTAL STORAGE RESERVED FOR MUST-COMPLETE OPERATIONS | DB2W225CR | INT4 | 10 | 0 | |||
| DBM1_QW0225MV | TOTAL AMOUNT OF STORAGE FOR MVS USE | DB2W225MV | INT4 | 10 | 0 | |||
| DBM1_QW0225SO | STORAGE CUSHION WARNING TO CONTRACT | DB2W225SO | INT4 | 10 | 0 | |||
| DBM1_QW0225GS | TOTAL GETMAINED STACK STORAGE | DB2W225GS | INT4 | 10 | 0 | |||
| DBM1_QW0225SU | INT4 | 10 | 0 | |||||
| DBM1_QW0225VR | TOTAL VARIABLE STORAGE | DB2W225VR | INT4 | 10 | 0 | |||
| DBM1_QW0225FX | TOTAL FIXED STORAGE | DB2W225FX | INT4 | 10 | 0 | |||
| DBM1_QW0225GM | TOTAL GETMAINED STORAGE | DB2W225GM | INT4 | 10 | 0 | |||
| DBM1_QW0225AV | AMOUNT OF AVAILABLE STORAGE | DB2W225AV | INT4 | 10 | 0 | |||
| DBM1_QW0225VA | private variable pool storage | DB2W225VA | DEC | 19 | 0 | |||
| DBM1_QW0225FA | private fixed pool storage | DB2W225FA | DEC | 19 | 0 | |||
| DBM1_QW0225GA | private getmained storage | DB2W225GA | DEC | 19 | 0 | |||
| DBM1_QW0225SM | Total 64-bit private storage f. stor. manager control struct | DB2W225SM | DEC | 19 | 0 | |||
| DBM1_QW0225RL | Number of real frames (4K) in use | DB2W225RL | DEC | 19 | 0 | |||
| DBM1_QW0225AX | Number of auxiliary slots (4k) in use | DB2W225AX | DEC | 19 | 0 | |||
| DBM1_QW0225HV_PAGES_IN_REAL | Number of real 4K frames in use for 64-bit private | DB2W225HV_PAGES_IN_REAL | DEC | 19 | 0 | |||
| DBM1_QW0225HV_AUX_SLOTS | Number of 4K auxiliary slots in use for 64-bit private | DB2W225HV_AUX_SLOTS | DEC | 19 | 0 | |||
| DBM1_QW0225HVG_PAGES_IN_REAL | High water mark for # of real 4K frames in use for 64-bit | DB2W225HVG_PAGES_IN_REAL | DEC | 19 | 0 | |||
| DBM1_QW0225HVG_AUX_SLOTS | High water mark for 4K aux. slots in use for 64-bit private | DB2W225HVG_AUX_SLOTS | DEC | 19 | 0 | |||
| QW0225AT | NUMBER OF ACTIVE ALLIED THREADS | DB2W225AT | INT4 | 10 | 0 | |||
| QW0225DB | INT4 | 10 | 0 | |||||
| QW0225CE | NUMBER OF CASTOUT ENGINES | DB2W225CE | INT4 | 10 | 0 | |||
| QW0225DW | NUMBER OF DEFERRED WRITE ENGINES | DB2W225DW | INT4 | 10 | 0 | |||
| QW0225GW | NUMBER OF GBP WRITE ENGINES | DB2W225GW | INT4 | 10 | 0 | |||
| QW0225PF | NUMBER OF PREFETCH ENGINES | DB2W225PF | INT4 | 10 | 0 | |||
| QW0225PL | NUMBER OF P-LOCK/NOTIFY EXIT ENGINES | DB2W225PL | INT4 | 10 | 0 | |||
| QW0225EC | INT4 | 10 | 0 | |||||
| QW0225FC | INT4 | 10 | 0 | |||||
| QW0225VC | INT4 | 10 | 0 | |||||
| QW0225GC | INT4 | 10 | 0 | |||||
| QW0225FCG | Total 64-bit common fixed pool storage | DB2W225FCG | DEC | 19 | 0 | |||
| QW0225VCG | Total 64-bit common variable pool storage | DB2W225VCG | DEC | 19 | 0 | |||
| QW0225GCG | Total 64-bit common getmained storage | DB2W225GCG | DEC | 19 | 0 | |||
| QW0225SMC | Total 64-bit common storage f.storage manager control struct | DB2W225SMC | DEC | 19 | 0 | |||
| QW0225SF | Total fixed shared 64-bit storage | DB2W225SF | DEC | 19 | 0 | |||
| QW0225SG | Total GETMAINed shared 64-bit storage | DB2W225SG | DEC | 19 | 0 | |||
| QW0225SV | Total 64-bit shared variable pool storage | DB2WQW0225SV | DEC | 19 | 0 | |||
| QW0225SMS | Total 64-bit private storage f. stor. manager control struct | DB2W225SM | DEC | 19 | 0 | |||
| QW0225GSG_SYS | Total 64-bit shared system agent stack | DB2W225GSG_SYS | DEC | 19 | 0 | |||
| QW0225SUG_SYS | Total 64-bit shared system agent stack in use | DB2W225SUG_SYS | DEC | 19 | 0 | |||
| QW0225GSG | Total 64-bit shared non-system agent stack | DB2W225GSG | DEC | 19 | 0 | |||
| QW0225SUG | Total 64-bit shared non-system agent stack in use | DB2W225SUG | DEC | 19 | 0 | |||
| QW0225SHRNMOMB | INT4 | 10 | 0 | |||||
| QW0225SHRPAGES | # of 64-bit shared memory pages alloc. for this MVS LPAR | DB2W225SHRPAGES | DEC | 19 | 0 | |||
| QW0225SHRGBYTES | High water mark for # of 64-bit shared bytes for this MVS L. | DB2W225SHRGBYTES | DEC | 19 | 0 | |||
| QW0225SHRINREAL | # of 64-bit shared pages backed in real storage (4K pages) | DB2W225SHRINREAL | DEC | 19 | 0 | |||
| QW0225SHRAUXSLOTS | Number of auxiliary slots used for 64-bit shared storage | DB2W225SHRAUXSLOTS | DEC | 19 | 0 | |||
| QW0225SHRPAGEINS | Number of 64-bit shared pages paged in from aux. storage | DB2W225SHRPAGEINS | DEC | 19 | 0 | |||
| QW0225SHRPAGEOUTS | Number of 64-bit shared pages paged out to auxiliary storage | DB2W225SHRPAGEOUTS | DEC | 19 | 0 | |||
| QW0225SC | TOTAL STORAGE FOR THREAD COPIES OF CACHED SQL STATEMENTS | DB2W225SC | INT4 | 10 | 0 | |||
| QW0225LC | INT4 | 10 | 0 | |||||
| QW0225LS | INT4 | 10 | 0 | |||||
| QW0225SX | INT4 | 10 | 0 | |||||
| QW0225HS | INT4 | 10 | 0 | |||||
| QW0225HC | INT4 | 10 | 0 | |||||
| QW0225L2 | Allocated statement cache storage in 64-bit agent local pool | DB2W225L2 | DEC | 19 | 0 | |||
| QW0225H2 | High water mark for alloc. stmt cache storage in 64-bit pool | DB2W225H2 | DEC | 19 | 0 | |||
| QW0225S2 | Total 64-bit STMT CACHE BLOCKS 2G storage | DB2W225S2 | DEC | 19 | 0 | |||
| QW0225AL | TOTAL AGENT LOCAL POOL STORAGE | DB2W225AL | INT4 | 10 | 0 | |||
| QW0225AS | TOTAL AGENT SYSTEM STORAGE | DB2W225AS | INT4 | 10 | 0 | |||
| QW0225CD | TOTAL STORAGE FOR COMPRESSION DICTIONARY | DB2W225CD | DEC | 19 | 0 | |||
| QW0225ALG | Total agent local storage (64-bit shared variable pools) | DB2W225ALG | DEC | 19 | 0 | |||
| QW0225ASG | Total system agent storage (64-bit shared variable pools) | DB2W225ASG | DEC | 19 | 0 | |||
| QW0225BB | Total buffer manager storage blocks (31-bit DBM1) | DB2W225BB | DEC | 19 | 0 | |||
| QW0225RP | TOTAL STORAGE FOR RID POOL | DB2W225RP | DEC | 19 | 0 | |||
| DIST_QW0225SS | INT4 | 10 | 0 | |||||
| DBM1_QW0225SS | INT4 | 10 | 0 | |||||
| DBM1_QW0225PRI_STG_REAL | # of real 4 K frames in use for 64-bit priv. storage | DB2W225PRISTG_REAL | DEC | 19 | 0 | |||
| DBM1_QW0225PRI_STG_AUX | # of real 4 K aux slots in use for 64-bit priv. storage | DB2W225PRISTG_AUX | DEC | 19 | 0 | |||
| DIST_QW0225PRI_STG_REAL | # of real 4 K frames in use for 64-bit priv. storage | DB2W225PRISTG_REAL | DEC | 19 | 0 | |||
| DIST_QW0225PRI_STG_AUX | # of real 4 K aux slots in use for 64-bit priv. storage | DB2W225PRISTG_AUX | DEC | 19 | 0 | |||
| QW0225PT | INT4 | 10 | 0 | |||||
| QW0225SHR_STG_REAL | # of real 4K frames in use for 64- bit shared storage | DB2W225SHRSTG_REAL | DEC | 19 | 0 | |||
| QW0225SHR_STG_AUX | # of real 4 K aux slots in use for 64- bit shared storage | DB2W225SHRSTG_AUX | DEC | 19 | 0 | |||
| QW0225SHR_STK_STG_REAL | # of real 4K frames in use for 64- bit shared stack storage | DB2W225SHRSTKSTG_REAL | DEC | 19 | 0 | |||
| QW0225SHR_STK_STG_AUX | # of real 4K aux slots in use f 64- bit shared stack storage | DB2W225SHRSTKSTG_AUX | DEC | 19 | 0 | |||
| QW0225COM_STG_REAL | # of real 4K frames in use for 64- bit common storage | DB2W225COMSTG_REAL | DEC | 19 | 0 | |||
| QW0225COM_STG_AUX | # of real 4K aux slots in use for 64- bit common storage | DB2W225COMSTG_AUX | DEC | 19 | 0 | |||
| REALSTORBP | Real storage in use for 64-bit - used by DB2 buffer pools | DB2REALSTORBP | DEC | 19 | 0 | |||
| AUXSTORBP | Aux. storage in use for 64-bit - used by DB2 buffer pools | DB2AUXSTORBP | DEC | 19 | 0 | |||
