SAP ABAP Data Element - Index D, page 6
Data Element - D
| # | Data Element | Short Description | Domain | Data Type |
|---|---|---|---|---|
 |
|
|
|
|
| 1 |  DB2DITOTT |
Total time for IRLM |  DB2CHAR16 |
CHAR |
| 2 | DB2DPASS |
The password for the datasets of the tablespace | DB2DPASS |
CHAR |
| 3 | DB2DRLKP |
Percent of time spent in DB2 for drain locks | DB2CHAR10 |
CHAR |
| 4 | DB2DSCFFLD |
DB2SINT |
INT2 | |
| 5 | DB2DSCFTYP |
type field for dynamic statement cache | DB2SINT |
INT2 |
| 6 | DB2DSCFVAL |
DB2INT4 |
INT4 | |
| 7 | DB2DSCQAL |
DSC Qualification | DB2DSCQAL |
NUMC |
| 8 | DB2DSCTQAL |
DB2 IFI DSC qualification for top statements | DB2DSCTQAL |
NUMC |
| 9 | DB2DSCTRH |
DSC Threshold | DB2CHAR09 |
CHAR |
| 10 | DB2DSECNP |
DB2INT4 |
INT4 | |
| 11 | DB2DSECPR |
DB2INT4 |
INT4 | |
| 12 | DB2DSEXT |
Last qualifier of dataset name of a DB2 tablespace or index | CHAR4 |
CHAR |
| 13 | DB2DSGN |
DB2/390: Data sharing group | DB2CHAR08 |
CHAR |
| 14 | DB2DSGROUP |
Data sharing group | DB2CHAR10 |
CHAR |
| 15 | DB2DSIZE |
Maximum size of a dataset in KBytes | DB2DSIZE |
INT4 |
| 16 | DB2DSMEMB |
Data sharing member | DB2CHAR10 |
CHAR |
| 17 | DB2DSNAME |
Dataset name | DB2CHAR44 |
CHAR |
| 18 | DB2DSRBT |
SRB time for DB2 database service address space | DB2CHAR16 |
CHAR |
| 19 | DB2DSSPROP |
Qual. properties for DB2 data set statistics -IFCID 199 | DB2DSSPROP |
NUMC |
| 20 | DB2DSSQAL |
Qualification for DB2 data set statistics - IFCID 199 | DB2DSSQAL |
NUMC |
| 21 | DB2DSSTP |
Percent of time spent in DB2 for dataspace manager service | DB2CHAR10 |
CHAR |
| 22 | DB2DSTRC |
DBSL SQL trace level | INT4 | |
| 23 | DB2DSTYPE |
Pageset type | DB2CHAR05 |
CHAR |
| 24 | DB2DS_CREATDAY |
Day of creation of data set (Julian date) | INT4 | |
| 25 | DB2DS_CREATYEAR |
Year of creation of data set | INT4 | |
| 26 | DB2DS_HARBA |
Dataset High-Allocated RBA | INT4 | |
| 27 | DB2DS_HURBA |
Dataset High-Used RBA | INT4 | |
| 28 | DB2DS_TYPE |
Data set type in integer | INT4 | |
| 29 | DB2DTCBT |
TCB time for DB2 database service address space | DB2CHAR16 |
CHAR |
| 30 | DB2DTHRSTA |
Status of the thread | DB2CHAR22 |
CHAR |
| 31 | DB2DTOTT |
Total time for DB2 database service address space | DB2CHAR16 |
CHAR |
| 32 | DB2DUMPSZ |
Dump Size for IFI DB Trace | NUMC10 |
NUMC |
| 33 | DB2DURATIH |
IFI DB Trace: Duration of Operation | DB2CHAR15 |
CHAR |
| 34 | DB2ELEMENT |
DB2 z/OS: element of an object | CHAR | |
| 35 | DB2ENCODE |
Default encoding scheme of the tablespace | DB2ENCODE |
CHAR |
| 36 | DB2ENCODING |
Encoding | CHAR | |
| 37 | DB2ERRDEVT |
Device on which the SYSERR dataset resides | DB2DEVT |
CHAR |
| 38 | DB2ERRDSN |
Dataset allocated to the SYSERR DDNAME | DB2DDN |
CHAR |
| 39 | DB2ERRNO |
DB2 for OS/390: Number of error reported by DB system check | NUMC05 |
NUMC |
| 40 | DB2ERRSPC |
Primary space allocation for the SYSERR dataset (Cyl.) | DB2DDPQTYC |
INT2 |
| 41 | DB2ERULE |
Datasets are to be erased when dropped | DB2ERULE |
CHAR |
| 42 | DB2EUTX |
CHAR32 |
CHAR | |
| 43 | DB2EUWN |
DB2CHAR18 |
CHAR | |
| 44 | DB2EVTDATS |
Date when the event arises | DATS |
DATS |
| 45 | DB2EVTTIMS |
Time when the event arises | TIME |
TIMS |
| 46 | DB2EVTTMS |
Event time stamp (milliseconds) | DB2CHAR06 |
CHAR |
| 47 | DB2EXECS |
Sum of execution of updates, inserts, deletes and fetches | DEC12 |
DEC |
| 48 | DB2EXESEC |
Average executions per second | DB2DEC25V6 |
DEC |
| 49 | DB2EXTENT |
Number of extents of a tablespace | DB2EXTENT |
INT4 |
| 50 | DB2FAILOVER_PARAM_NAME |
Name of Failover Parameter, needed for special Documentation | STRG | |
| 51 | DB2FARINDR |
Number of rows relocated far from their original page | INT4 | |
| 52 | DB2FAROFFP |
Number of referred to rows far from optimal position | FLTP |
FLTP |
| 53 | DB2FCONRAT |
False contention rate | DB2CHAR10 |
CHAR |
| 54 | DB2FETCHES |
DB2 for OS/390: Number of fetches | DEC12 |
DEC |
| 55 | DB2FIELDNAME |
fieldname (of structure etc.) | CHAR | |
| 56 | DB2FILDEVT |
Device on which the FILTER dataset resides | DB2FILDEVT |
CHAR |
| 57 | DB2FILDSN |
Dataset allocated to the FILTER DDNAME | DB2FILDSN |
CHAR |
| 58 | DB2FILENAME |
File Name | CHAR | |
| 59 | DB2FILEPATH |
File Path | CHAR | |
| 60 | DB2FILSPC |
Primary space allocation for the SYSERR dataset (Cyl.) | DB2FILSPC |
INT2 |
| 61 | DB2FKTID |
DB2SINT |
INT2 | |
| 62 | DB2FLAG |
c1 flag | CHAR | |
| 63 | DB2FREDSCB |
Number of free DSCBs | INT4 | |
| 64 | DB2FREECYL |
Number of cylinders of freespace on an OS/390 DASD volume | INT4 | |
| 65 | DB2FREEPG |
Number of pages loaded before a page is left as free space | DB2SINT |
INT2 |
| 66 | DB2FRSTKEY |
Number of distinct values in the first key column | FLTP |
FLTP |
| 67 | DB2FULLKEY |
Number of distinct values of the key | FLTP |
FLTP |
| 68 | DB2FULLMEMBERNAME |
Full name of a PDS member (incl. PDS name and brackets) | CHAR54 |
CHAR |
| 69 | DB2FULLP |
Total number of prepares: full prepares + short prepares | DB2DEC19V |
DEC |
| 70 | DB2GBPCACH |
Group buffer pool cache option | DB2GBPCACH |
CHAR |
| 71 | DB2GBPCACHL |
Group buffer pool cache option | CHAR | |
| 72 | DB2GBPDEP |
Group bufferpool dependence | DB2CHAR03 |
CHAR |
| 73 | DB2GBPFAIL |
GBP: Read/Write failures due to storage shortage | DB2NUMC10 |
NUMC |
| 74 | DB2GBPREAD |
Group buffer pool: # of pages returned on CF read request | DB2NUMC10 |
NUMC |
| 75 | DB2GBPWRIT |
Group buffer pool: # of times a CF write request completed | DB2NUMC10 |
NUMC |
| 76 | DB2GCONRAT |
Global contention rate | DB2CHAR10 |
CHAR |
| 77 | DB2GDG_GENERATIONS |
Number of GDG generations | INT4 | |
| 78 | DB2GETPRAT |
Number of Getpage Requests per Second | DB2DEC19V |
DEC |
| 79 | DB2GETPRND |
Number of Random Access Getpage Requests | DB2DEC20V |
DEC |
| 80 | DB2GHITRAT |
Dynamic Statement Cache Global Hit Ratio | CHAR | |
| 81 | DB2GLOBTP |
Percent of time spent in DB2 for global locks | DB2CHAR10 |
CHAR |
| 82 | DB2GPPRPROC |
Getpages per rows processed | DB2DEC21V2 |
DEC |
| 83 | DB2GPRPROC |
Getpages per rows processed | CHAR | |
| 84 | DB2HDWT |
CHAR1 |
CHAR | |
| 85 | DB2HISTDT |
History start/end date | DB2DATE |
DATS |
| 86 | DB2HISTTM |
History data start/end time | DB2TIME |
TIMS |
| 87 | DB2HIST_RANGE |
Range for History ( daily, weekly, monthly ) | CHAR | |
| 88 | DB2HITRATI |
Prepare hit ratio | DB2CHAR06 |
CHAR |
| 89 | DB2HOSTNAME |
Hostname | DB2HOSTNAME |
CHAR |
| 90 | DB2HOSTTCP |
TCP address of database host | HOST_ID |
CHAR |
| 91 | DB2HOSTTYP |
Host type: Primary or standby | DB2HOSTTYP |
CHAR |
| 92 | DB2HPBACK |
Percentage of hiperpool buffers backed | DEC10_2 |
DEC |
| 93 | DB2HPCAPG |
Percentage of buffers in the HP containing pages of the PS | DB2DEC4_2 |
DEC |
| 94 | DB2HPCOA |
Hiperpool failures | DB2CHAR16 |
CHAR |
| 95 | DB2HPCSRWR |
Ratio of Sync. Reads vs Sync. Writes for the Hiperpool | DB2CHAR10 |
CHAR |
| 96 | DB2HPCUNSU |
No. of Unsuccessful Sync. Hiperpool Read or Write Requests | DB2NUMC10 |
NUMC |
| 97 | DB2HPEFF |
Hiperpool efficiency | DEC10_2 |
DEC |
| 98 | DB2HPFAIL |
Number of Hiperpool Failures | DEC | |
| 99 | DB2HPHIT |
Minimum hiperpool efficiency | DB2DEC8_2 |
DEC |
| 100 | DB2HPHITN |
Hiperpool with minimum efficiency | DB2CHAR08 |
CHAR |
| 101 | DB2HPHRA |
Hiperpool efficiency | DB2DEC13_2 |
DEC |
| 102 | DB2HPREARA |
Hiperpool reads ratio (high) | INT4 | |
| 103 | DB2HPRERAL |
Hiperpool read ratio (low) | INT4 | |
| 104 | DB2HPSRWRA |
Ratio of synch. reads vs synch. writes for the hiperpool | DB2CHAR10 |
CHAR |
| 105 | DB2HPUNSUC |
No. of Unsuccessful Sync. Hiperpool Read or Write Requests | DB2INT4U |
INT4 |
| 106 | DB2HWSTID |
DB2INT4 |
INT4 | |
| 107 | DB2ICOMSTA |
Start ICLI server communications trace | FLAG |
CHAR |
| 108 | DB2ICOMSTO |
Stop ICLI server communications trace | FLAG |
CHAR |
| 109 | DB2IDH |
IFI DB Trace: Identifier | DB2CHAR15 |
CHAR |
| 110 | DB2IDXNAME |
Name of a DB2 for OS/390 index | CHAR18 |
CHAR |
| 111 | DB2IDXNAML |
DB2 long index name | CHAR | |
| 112 | DB2IDXNAMX |
DB2 extended index name | STRG | |
| 113 | DB2IDXSIZD |
Storage reserved by all indexes of a table in KB | DEC15 |
DEC |
| 114 | DB2IDXUNKD |
Number of indexes of a table of unknown size | INT4 | |
| 115 | DB2IFAANIF |
Number of entries to and exits from IFI events | DB2NUMC10 |
NUMC |
| 116 | DB2IFAETP |
Elapsed IFI time to total DB2 time in percent | DB2TIMEP |
CHAR |
| 117 | DB2IFAETT |
Accumulated elapsed time spent processing IFI calls | DB2CHAR16 |
CHAR |
| 118 | DB2IFATTP |
Processing (CPU) times to total DB2 activity time in percent | DB2TIMEP |
CHAR |
| 119 | DB2IFATTT |
Accumulated CPU time spent processing IFI calls | DB2CHAR16 |
CHAR |
| 120 | DB2IFICPUA |
Average IFI entry/exit CPU time | DB2CHAR16 |
CHAR |
| 121 | DB2IFIDBAPP |
application type short | DB2CHAR02 |
CHAR |
| 122 | DB2IFIDBAPS |
IFI DB Trace Application Types | DB2CHAR32 |
CHAR |
| 123 | DB2IFIDBCA |
Start the IFI DB trace | FLAG |
CHAR |
| 124 | DB2IFIDBCD |
Display IFI DB trace files | FLAG |
CHAR |
| 125 | DB2IFIDBCO |
Stop IFI DB trace | FLAG |
CHAR |
| 126 | DB2IFIDBIP |
DB Trace Input | DB2CHAR60 |
CHAR |
| 127 | DB2IFIDBT1 |
DB Trace Level | DB2CHAR2 |
CHAR |
| 128 | DB2IFIDBTL |
DB Trace Level | DB2CHAR60 |
CHAR |
| 129 | DB2IFIDBTS |
IFI DB Trace: Timestamp | DB2CHAR15 |
CHAR |
| 130 | DB2IFITRCA |
Start the IFI server trace | FLAG |
CHAR |
| 131 | DB2IFITRCD |
Display IFI server trace files | FLAG |
CHAR |
| 132 | DB2IFITRCL |
IFI Trace Level | DB2INT4 |
INT4 |
| 133 | DB2IFITRCO |
Stop IFI server trace | FLAG |
CHAR |
| 134 | DB2IFIWPS |
Work Process Description | DB2CHAR30K |
CHAR |
| 135 | DB2IFRALEN |
DB2INT4 |
INT4 | |
| 136 | DB2IMSGLVL |
DB2 for OS/390: ICLI message level | DB2CHAR01 |
CHAR |
| 137 | DB2INDB2 |
Percentage of time spent in DB2 | DB2TIMEP |
CHAR |
| 138 | DB2INDREF |
Different of far and near relocated position in page | DB2INDREF |
INT2 |
| 139 | DB2INDXALL |
Parameter if INDEX ALL should used for a RUNSTATS | DB2INDXALL |
CHAR |
| 140 | DB2INETOFF |
Switch network statistics off | FLAG |
CHAR |
| 141 | DB2INETPAC |
Switch network statistics on (sampling rate in packets) | FLAG |
CHAR |
| 142 | DB2INETSEC |
Switch network statistics on (sampling rate in seconds) | FLAG |
CHAR |
| 143 | DB2INSCNT |
DB2 for OS/390: Number of database inserts | DB2NUMC10 |
NUMC |
| 144 | DB2INSTFIELD |
install field | CHAR | |
| 145 | DB2INSTNO |
Instance number (unique value) | DB2RAW12 |
RAW |
| 146 | DB2INSTPANEL |
Install Panel | CHAR | |
| 147 | DB2INT2AA |
Small integer | DB2SINT |
INT2 |
| 148 | DB2INT2D |
Field Type INT2, Length 2 | DB2SINT |
INT2 |
| 149 | DB2INT4 |
Field Type INT, Length 4 | DB2INT4 |
INT4 |
| 150 | DB2INT4U |
Field Type INT, Length 4 | DB2INT4U |
INT4 |
| 151 | DB2INTEVAL |
Time interval of the data | DB2TIME |
TIMS |
| 152 | DB2INTSTRT |
DB2 for OS/390 History Data Inteval (Start/End Time) | DB2RAW8 |
RAW |
| 153 | DB2INXNAME |
Index name | CHAR18 |
CHAR |
| 154 | DB2IRATE |
Sampling rate of network statistics | DB2NUMC10 |
NUMC |
| 155 | DB2IRATES |
Sampling rate for network statistics | DB2NUMC10 |
NUMC |
| 156 | DB2ISECFRE |
Number of free pages in EDM statement pool | DB2INT4 |
INT4 |
| 157 | DB2ISECPGE |
Number of pages in EDM statement pool | DB2INT4 |
INT4 |
| 158 | DB2ISECT |
Current number of pages in EDM pool used for cursor tables | DB2DEC10V |
DEC |
| 159 | DB2ISECTG |
Number of requests for cursor table sections | DB2DEC10V |
DEC |
| 160 | DB2ISECTL |
Number of CT sections not found in EDM pool | DB2DEC10V |
DEC |
| 161 | DB2ISEDBD |
Current number of pages in EDM pool used for DB descriptor | DB2DEC10V |
DEC |
| 162 | DB2ISEDBDG |
Number of requests for database descriptor | DB2DEC10V |
DEC |
| 163 | DB2ISEDBDL |
Number of DB descriptors not found in EDM pool | DB2DEC10V |
DEC |
| 164 | DB2ISEDFAL |
Number of failures because the data space is full | DB2DEC10V |
DEC |
| 165 | DB2ISEDFRE |
Number of free pages in the data space free chain | DB2DEC10V |
DEC |
| 166 | DB2ISEDPGE |
Number of pages in the data space used by the EDM pool | DB2DEC10V |
DEC |
| 167 | DB2ISEDSC |
Number of pages used for DSC | DB2DEC10V |
DEC |
| 168 | DB2ISEDSG |
Number of requests for DSC sections | DB2DEC10V |
DEC |
| 169 | DB2ISEDSI |
Number of inserts into EDM pool for dynamic statement cache | DB2DEC10V |
DEC |
| 170 | DB2ISEFREE |
Current number of free pages in the free chain | DB2DEC10V |
DEC |
| 171 | DB2ISEKT |
Current number of pages in EDM pool used for package tables | DB2DEC10V |
DEC |
| 172 | DB2ISEKTG |
Number of requests for package table sections | DB2DEC10V |
DEC |
| 173 | DB2ISEKTL |
Number of times a PT section was not found in EDM pool | DB2DEC10V |
DEC |
| 174 | DB2ISEPAGE |
Current number of pages in the EDM pool | DB2DEC10V |
DEC |
| 175 | DB2ISESKCT |
Current number of pages in EDM pool used for skeleton CT | DB2DEC10V |
DEC |
| 176 | DB2ISESKPT |
Current number of pages in EDM pool used for skeleton PT | DB2DEC10V |
DEC |
| 177 | DB2ISESTMT |
Number of statements in EDM pool for dynamic statement cache | DB2DEC10V |
DEC |
| 178 | DB2ISNAME |
DB2 indexspace name | CHAR8 |
CHAR |
| 179 | DB2ISTRCUR |
RID block allocated - current | DEC_10 |
DEC |
| 180 | DB2ISTRHIG |
RID blocks allocated - maximum | DEC_10 |
DEC |
| 181 | DB2ISTRLLM |
RDS limit exceeded | DEC_10 |
DEC |
| 182 | DB2ISTRMAX |
Process limit exceeded | DEC_10 |
DEC |
| 183 | DB2ISTRPLM |
Physical limit reached | DEC_10 |
DEC |
| 184 | DB2ISTRSTG |
RID list processing exhausted virtual storage | DEC_10 |
DEC |
| 185 | DB2ITRCDIS |
Display ICLI server trace files | FLAG |
CHAR |
| 186 | DB2ITRCLVL |
ICLI trace level | DB2NUMC01 |
NUMC |
| 187 | DB2ITRCSTA |
Start the ICLI server trace | FLAG |
CHAR |
| 188 | DB2ITRCSTO |
Stop ICLI server trace | FLAG |
CHAR |
| 189 | DB2IXCARDF |
Number of keys in the index that refer to data rows or LOBs | FLTP |
FLTP |
| 190 | DB2IXFREE |
Free size of an index in KB (allocated minus used storage) | DEC11 |
DEC |
| 191 | DB2IXFREEP |
Free size of an index partition in KB | DEC11 |
DEC |
| 192 | DB2IXFREET |
Total free size of all R/3 indexes in KB | DEC13 |
DEC |
| 193 | DB2IXMISDB |
Number of indexes missing in the database | DEC08 |
DEC |
| 194 | DB2IXMISDD |
Number of indexes missing in the ABAP dictionary | DEC08 |
DEC |
| 195 | DB2IXNAML |
Index name | CHAR | |
| 196 | DB2IXNUM |
Number of indexes in the R/3 system | DEC08 |
DEC |
| 197 | DB2IXPCTT |
Percentage of free size to allocated size of all indexes | NUMC03 |
NUMC |
| 198 | DB2IXPCTU |
Percentage of used size to allocated size of all indexes | DEC3 |
DEC |
| 199 | DB2IXPCTUP |
Percentage of used to alloc. size of a partition of an IX | DEC3 |
DEC |
| 200 | DB2IXPCTUS |
Percentage of used size to allocated size of an index | DEC3 |
DEC |
| 201 | DB2IXPCTUT |
Percentage of used size to allocated size of all indexes | DEC3 |
DEC |
| 202 | DB2IXPGSIZ |
Size in bytes of the leaf pages in the index | DB2SINT |
INT2 |
| 203 | DB2IXSIZ |
Total size of an index (allocated storage in KB) | DEC11 |
DEC |
| 204 | DB2IXSIZP |
Allocated storage of a partition of an index in KB | DEC11 |
DEC |
| 205 | DB2IXSIZT |
Total size of all R/3 indexes (allocated storage in kB) | DEC13 |
DEC |
| 206 | DB2IXSPACE |
Name of the indexspace that contains the index | CHAR8 |
CHAR |
| 207 | DB2IXSPACEL |
Index Space | CHAR | |
| 208 | DB2IXTYP |
IX Type | CHAR | |
| 209 | DB2IXTYPE |
Index type | DB2IXTYPE |
CHAR |
| 210 | DB2JCL_JOBCARD |
JCL job line | CHAR72 |
CHAR |
| 211 | DB2JESID |
DSNACCJP:Obsolete - System name of the target JES subsystem | CHAR8 |
CHAR |
| 212 | DB2JESJOBID |
z/OS JES Job ID | CHAR8 |
CHAR |
| 213 | DB2JESOUT |
Output of JCL Job | CHAR256 |
CHAR |
| 214 | DB2JSTALR |
Number of archive log read allocations | DB2INT4 |
INT4 |
| 215 | DB2JSTALW |
Number of archive log write allocations | DB2INT4 |
INT4 |
| 216 | DB2JSTBFFL |
Number of Active Log Output Control Intervals Created | DB2INT4 |
INT4 |
| 217 | DB2JSTBFWR |
Number of calls to the log write routine | DB2INT4 |
INT4 |
| 218 | DB2JSTBPAG |
The number of times a log output buffer had to be paged-in | DB2NUMC10 |
NUMC |
| 219 | DB2JSTBSDS |
Number of BSDS Access Requests | DB2INT4 |
INT4 |
| 220 | DB2JSTCIOF |
Count of Control Intervals Offloaded | DB2INT4 |
INT4 |
| 221 | DB2JSTCIWR |
Number of control intervals written for active log (second) | DB2NUMC10 |
NUMC |
| 222 | DB2JSTLAMA |
Check Tape Mounts Attempted | DB2INT4 |
INT4 |
| 223 | DB2JSTLAMS |
Successful "look ahead" (tape volume) mounts attempted | DB2INT4 |
INT4 |
| 224 | DB2JSTLOGW |
The total number of log-write I/O requests | DB2NUMC10 |
NUMC |
| 225 | DB2JSTLSUS |
Number of times a log manager request results in suspend | DB2NUMC10 |
NUMC |
| 226 | DB2JSTRACT |
Number of Log Reads Satisfied from Active Log Data Set | DB2INT4 |
INT4 |
| 227 | DB2JSTRARH |
Number of Log Reads Satisfied from Archive Log Data Set | DB2INT4 |
INT4 |
| 228 | DB2JSTRBUF |
Number of Log Reads Satisfied from Output Buffer | DB2INT4 |
INT4 |
| 229 | DB2JSTSERW |
The number of "serial" log-write I/O requests | DB2NUMC10 |
NUMC |
| 230 | DB2JSTTHRW |
Number of times an async. log-write request was scheduled | DB2NUMC10 |
NUMC |
| 231 | DB2JSTTVC |
Read accesses delayed due to tape volume contention | DB2INT4 |
INT4 |
| 232 | DB2JSTWRNW |
Number of Write-No-Wait Requests | DB2INT4 |
INT4 |
| 233 | DB2JSTWRNWD |
Number of Write-No-Wait Requests | DB2DEC10V |
DEC |
| 234 | DB2JSTWTB |
Unavailable output log buffers | DB2INT4 |
INT4 |
| 235 | DB2JSTWUR |
Read accesses delayed due to unavailable resource | DB2INT4 |
INT4 |
| 236 | DB2KCOLCNT |
Number of columns in the key | DB2SINT |
INT2 |
| 237 | DB2KEYCARD |
Number of distinct values in key (first column or full key) | FLOATING |
FLTP |
| 238 | DB2KEYCOLS |
Number of columns in the table's primary key | DB2SINT |
INT2 |
| 239 | DB2KYCRD |
KEYCARD collects all distinct values | DB2KYCRD |
CHAR |
| 240 | DB2LANG |
DB2/390: Language for alert receiver | DB2CHAR02 |
CHAR |
| 241 | DB2LEAFDIS |
100 * avg number of leaf pages between successive leaf pages | INT4 | |
| 242 | DB2LEUID |
DB2/390: End user ID (in DB2 sense) | CHAR128 |
CHAR |
| 243 | DB2LEUTX |
End user transaction name | DB2CHAR32 |
CHAR |
| 244 | DB2LEUWN |
End user workstation name | DB2CHAR18 |
CHAR |
| 245 | DB2LHITRAT |
Dynamic Statement Cache Local Hit Ratio | CHAR | |
| 246 | DB2LIMITKEY |
limitkey | CHAR | |
| 247 | DB2LKLAP |
Percent of time spent in DB2 for locks and latches | DB2CHAR10 |
CHAR |
| 248 | DB2LMAX |
Maximum number of locks per user before escalating | DB2LMAX |
INT4 |
| 249 | DB2LOCKATT |
Lock attribute (logical lock or physical lock) | CHAR6 |
CHAR |
| 250 | DB2LOCKCMO |
The mode of the lock held on the resource | DB2CHAR06 |
CHAR |
| 251 | DB2LOCKDUR |
Lock duration of the thread holding the resource | CHAR12 |
CHAR |
| 252 | DB2LOCKESC |
Total number of lock escalations | DB2DEC10V |
DEC |
| 253 | DB2LOCKMOD |
The mode of the lock held on the resource | DB2CHAR06 |
CHAR |
| 254 | DB2LOCKMS |
The mode of the lock held on the resource | DB2CHAR03 |
CHAR |
| 255 | DB2LOCKNUC |
Locks held and suspended on the database/object combination | DB2NUMC10 |
NUMC |
| 256 | DB2LOCKNUM |
Locks held and suspended on the database/object combination | DB2NUMC10 |
NUMC |
| 257 | DB2LOCKST |
CHAR1 |
CHAR | |
| 258 | DB2LOCKTYP |
State of lock | CHAR10 |
CHAR |
| 259 | DB2LOG |
Whether the changes to a tablespace are to be logged | DB2LOG |
CHAR |
| 260 | DB2LOGLCR |
Number of internal log latch contentions per second | DB2CHAR10 |
CHAR |
| 261 | DB2LOGONG |
DB2/390: Logon group | DB2CHAR132 |
CHAR |
| 262 | DB2LOGSCP |
The active log copy number (1 or 2) | DB2CHAR10 |
CHAR |
| 263 | DB2LOGSER |
Number of log write I/O requests minus serial requests | DB2NUMC10 |
NUMC |
| 264 | DB2LOGSPC |
Percentage filled of last available log DS for this log copy | DB2CHAR10 |
CHAR |
| 265 | DB2LOGW |
Log writes suspension time | DB2CHAR16 |
CHAR |
| 266 | DB2LOGWA |
Average log writes | DB2CHAR10 |
CHAR |
| 267 | DB2LOGWC |
DB2DEC16 |
DEC | |
| 268 | DB2LOGWE |
Number of log writes | DB2NUMC10 |
NUMC |
| 269 | DB2LOGWEC |
DB2INT4 |
INT4 | |
| 270 | DB2LOGWP |
Percent of time spent in DB2 for log writes | DB2CHAR10 |
CHAR |
| 271 | DB2LOGWRA |
Average duration of a suspension for log write I/O | DB2CHAR10 |
CHAR |
| 272 | DB2LPART |
Lockpart for the tablespace | DB2LPART |
CHAR |
| 273 | DB2LRULE |
Lock size of the tablespace | DB2LRULE |
CHAR |
| 274 | DB2MACRO |
Macro Name | CHAR | |
| 275 | DB2MANDT |
DB2/390: Alert receiver client | DB2CHAR04 |
CHAR |
| 276 | DB2MAPDEVT |
Device on which the SYSMAP dataset resides | DB2DEVT |
CHAR |
| 277 | DB2MAPDSN |
Dataset allocated to the SYSMAP DDNAME | DB2DDN |
CHAR |
| 278 | DB2MAPSPC |
Primary space allocation for the SYSMAP dataset (cyl.) | DB2DDPQTYC |
INT2 |
| 279 | DB2MAXEXTS |
Maximum number of extents of a partition of the TS or IX | INT4 | |
| 280 | DB2MCPDS |
Partition or dataset whose incr. copies are to be merged | CHAR3 |
CHAR |
| 281 | DB2MCPNEW |
Whether incr. image copies are to be merged with full ones | DB2YESNO |
CHAR |
| 282 | DB2MCPTS |
Name of the tablespace whose incr. image copies are merged | DB2TSNAME |
CHAR |
| 283 | DB2MEMBERNAME |
Name of partitioned dataset (PDS) member | CHAR8 |
CHAR |
| 284 | DB2MEMN |
DB2 member name in data sharing environment | DB2CHAR08 |
CHAR |
| 285 | DB2MODDATE |
Date of last modification | DATUM |
DATS |
| 286 | DB2MODFLG |
DB2/OS390: Shows if check in DB system check can be modified | CHAR1 |
CHAR |
| 287 | DB2MODTIME |
Time of last modification | TIMES |
TIMS |
| 288 | DB2MOD_REC_AGE |
AGE parameter of MODIFY RECOVERY utility | INT4 | |
| 289 | DB2MOD_STAT_AGE |
AGE parameter of MODIFY STATISTICS utility | INT4 | |
| 290 | DB2MONIVER |
Version marker for DB02's data stored in table MONI | CHAR1 |
CHAR |
| 291 | DB2MROW |
Maximum number of rows that DB2 will place on a data page | DB2MROW |
INT2 |
| 292 | DB2MSGLVL |
DB2 for OS/390: ICLI message level | DB2CHAR01 |
CHAR |
| 293 | DB2MSHOST |
Message server host | DB2SERVER |
CHAR |
| 294 | DB2MSSERV |
Message server service | DB2CHAR22 |
CHAR |
| 295 | DB2NACTIVE |
Number of active pages in the tablespace | INT4 | |
| 296 | DB2NAIDB2 |
Time not attributed in DB2 / Time spent in DB2 (%) | DB2TIMEP |
CHAR |
| 297 | DB2NEARIND |
Number of rows relocated near their original page | INT4 | |
| 298 | DB2NEAROFF |
Number of referred to rows near the optimal position | FLTP |
FLTP |
| 299 | DB2NETGEN |
Field to display network statistics | DB2DEC14_3 |
DEC |
| 300 | DB2NETTIME |
Time spent in network in milliseconds | DB2DEC8_3 |
DEC |
| 301 | DB2NETUNS |
Network statistics | DB2INT4U |
INT4 |
| 302 | DB2NGTONP |
Getpages per rows processed | DB2DEC25V6 |
DEC |
| 303 | DB2NLEAF |
Number of active leaf pages in the index | INT4 | |
| 304 | DB2NLEVELS |
DB2 for OS/390 number of levels in the index tree | DB2SINT |
INT2 |
| 305 | DB2NONCONVREASON |
Reason for non-convertible | CHAR | |
| 306 | DB2NOREORG |
A reorg should never work on this tablespace or index | DB2NOREORG |
CHAR |
| 307 | DB2NOTABS |
Number of Tables | INT4 | |
| 308 | DB2NOTMP |
Percent of time spent in DB2 for notify messages | DB2CHAR10 |
CHAR |
| 309 | DB2NPAGES |
Number of pages on which rows of the table appear | INT4 | |
| 310 | DB2NPAGESD |
Number of pages on which rows of the table appear | DB2DEC12 |
DEC |
| 311 | DB2NROWSD |
Number of records in a table | DEC15 |
DEC |
| 312 | DB2NRTONP |
Examined/rows processed (Only data rows are taken into acc.) | DB2DEC25V6 |
DEC |
| 313 | DB2NTAB |
Number of tables defined in the tablespace | DB2NTAB |
INT2 |
| 314 | DB2NTABLES |
Number of tables defined in the tablespace | INT4 | |
| 315 | DB2NULLS |
Whether the column can contain null values | DB2YNFLAG |
CHAR |
| 316 | DB2NUMC03 |
Field type numc, length 3, 1 byte | DB2NUMC03 |
NUMC |
| 317 | DB2NUMC05 |
Field type numc, length 5, short integer | NUM5 |
NUMC |
| 318 | DB2NUMC10 |
Field type numc, length 10, integer | DB2INT4 |
INT4 |
| 319 | DB2NUMERIC |
'X' if parameter is numeric, ' ' otherwise | AS4FLAG |
CHAR |
| 320 | DB2NUMEXT5 |
Total number of extents of a tablespace or index | DEC5 |
DEC |
| 321 | DB2NUMEXTD |
Number of extents of the dataset | INT2 |
INT2 |
| 322 | DB2NUMEXTI |
Number of extents | INT4 | |
| 323 | DB2NUMEXTP |
Number of extents of a partition of a tablespace or index | DEC3 |
DEC |
| 324 | DB2NUMEXTS |
Total number of extents of a tablespace or index | DEC3 |
DEC |
| 325 | DB2NUMH |
Number of holders | DB2NUMC10 |
NUMC |
| 326 | DB2NUMIDXD |
Number of indexes on a table | INT4 | |
| 327 | DB2NUMPART |
Number of partitions of a tablespace or index | DB2SINT |
INT2 |
| 328 | DB2NUMPG |
Number of pages | DEC | |
| 329 | DB2OBID |
DB2 page set ID | INT2 |
INT2 |
| 330 | DB2OBJECTNAME |
Object name (table, index, column) | CHAR | |
| 331 | DB2OBJECTTYPE |
Type of object e.g. TS, IS, TB, IX | DB2CHAR02 |
CHAR |
| 332 | DB2OBLKB |
Used storage space of a table (in KB) | DEC11 |
DEC |
| 333 | DB2OCIKB |
Used storage space for the indexes of a table (in KB) | DEC15 |
DEC |
| 334 | DB2OCSTP |
Percent of time spent in DB2 for open ,close, HSM recall | DB2CHAR10 |
CHAR |
| 335 | DB2OFFLOAD |
Whether offload is switched on | DB2CHAR03L |
CHAR |
| 336 | DB2OFFPOS |
Different of far and near optimal position in page | DB2OFFPOS |
INT2 |
| 337 | DB2OFFPOSF |
Number of referred to rows near/far from optimal position | FLOATING |
FLTP |
| 338 | DB2OPERH |
IFI DB Trace: Operation | DB2CHAR15 |
CHAR |
| 339 | DB2ORDER |
Order of the column in the key | DB2ORDER |
CHAR |
| 340 | DB2ORDERL |
Order of the column in the key | DB2ORDERL |
CHAR |
| 341 | DB2OTHRP |
Percent of time spent in DB2 for other agents' read | DB2CHAR10 |
CHAR |
| 342 | DB2OTHRSP |
Percent time in DB2 for other synchronous EU switch services | DB2CHAR10 |
CHAR |
| 343 | DB2OTHWP |
Percent of time spend in DB2 for other agents' writes | DB2CHAR10 |
CHAR |
| 344 | DB2OUTCP |
CPU time spent out of DB2 | DB2CHAR16 |
CHAR |
| 345 | DB2OUTDB2 |
Time spent out of DB2 | DB2CHAR16 |
CHAR |
| 346 | DB2OUTDB2C |
Time spent out of DB2 | DB2DEC16 |
DEC |
| 347 | DB2OUTPRO |
Percentage of time spent processing in DB2 | DB2CHAR08 |
CHAR |
| 348 | DB2P1TMR |
Pseudo-close timer | DB2NUMC10 |
NUMC |
| 349 | DB2PADDED |
Index - padded | CHAR | |
| 350 | DB2PAGEIN |
Number of page-ins | DB2DEC20V |
DEC |
| 351 | DB2PAGENR |
Page number | DB2CHAR10 |
CHAR |
| 352 | DB2PAGEPR |
Page-ins per pages read | DB2DECPCT |
DEC |
| 353 | DB2PAGES2 |
Object name | DB2CHAR18 |
CHAR |
| 354 | DB2PAGESET |
Object name | DB2CHAR22 |
CHAR |
| 355 | DB2PALONG |
Page-ins per pages read | DB2DEC28_2 |
DEC |
| 356 | DB2PARAM |
DB2 for OS/390: Paramter to be checked in DB system check | CHAR50 |
CHAR |
| 357 | DB2PARCHQ |
Archive log quiesce suspension time / time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 358 | DB2PARCHR |
Archive read suspension time / Time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 359 | DB2PARMCHK |
No of Checked DB2 Installation Parameters | NUMC05 |
NUMC |
| 360 | DB2PARMERR |
No of Checked DB2 Installation Parameters with Error | NUMC05 |
NUMC |
| 361 | DB2PARMNOCHK |
No of unchecked DB2 Installation Parameters | NUMC05 |
NUMC |
| 362 | DB2PARMOK |
No of Successfully Checked DB2 Installation Parameters | NUMC05 |
NUMC |
| 363 | DB2PARMWAR |
No of Checked DB2 Installation Parameters | NUMC05 |
NUMC |
| 364 | DB2PART |
Number of partitions of the tablespace or indexspace | DB2PART |
INT2 |
| 365 | DB2PARTEXT |
Extension or Partition (non-partitioned TS) number | INT4 | |
| 366 | DB2PARTNR |
Row ID or partition number, depending on resource type | DB2CHAR03 |
CHAR |
| 367 | DB2PARTNRI |
Number of partition | INT4 | |
| 368 | DB2PARTNRS |
Partition number | DB2SINT |
INT2 |
| 369 | DB2PASHOR |
Page-ins per pages read (%) | DB2DEC5_2 |
DEC |
| 370 | DB2PATCHLV |
DB2 for OS/390: Kernel patch level | INT4 | |
| 371 | DB2PBDFLT |
Default Bufferpools | CHAR | |
| 372 | DB2PCLREL |
Claim release suspension time / Time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 373 | DB2PCPUIN |
CPU time spent in DB2 / Time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 374 | DB2PCT |
Percentage | INT2 |
INT2 |
| 375 | DB2PCTCOM2 |
Copy of DB2PCTCOMP as INT2 to be DB2 SMALLINT-conform | INT2 |
INT2 |
| 376 | DB2PCTCOMP |
Percentage of rows compressed within total number of rows | INT1 |
INT1 |
| 377 | DB2PCTFREE |
DB2/390: Free space percentage on each page | DB2PCTFREE |
NUMC |
| 378 | DB2PCTFRES |
Percentage of each page left as free space | DB2SINT |
INT2 |
| 379 | DB2PCTRCMP |
Percentage of rows compressed within the total no. of rows | DB2SINT |
INT2 |
| 380 | DB2PDRLK |
Drain lock suspension time / Time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 381 | DB2PDSST |
Time dataset service task / time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 382 | DB2PECDT |
Accumulated CPU time user for DB2 | DB2CHAR16 |
CHAR |
| 383 | DB2PECTT |
Accumulated TCB time used before enclave is created | DB2CHAR16 |
CHAR |
| 384 | DB2PERCACT |
Percentage of space occupied by rows of active tables | DB2SINT |
INT2 |
| 385 | DB2PGLAP |
Percent of time spent in DB2 for page latches | DB2CHAR10 |
CHAR |
| 386 | DB2PGLOBTM |
Global locking suspension time / Time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 387 | DB2PGPDYNP |
Number of Pages Read per Dynamic Prefetch Read | CHAR | |
| 388 | DB2PGPLISP |
Number of Pages Read per List Prefetch Read | CHAR | |
| 389 | DB2PGPSEQP |
Number of Pages Read per Sequential Prefetch Read | CHAR | |
| 390 | DB2PGSAVE |
Percentage of pages saved in the TS because of compression | DB2SINT |
INT2 |
| 391 | DB2PGSIZE |
DB2 for OS/390 page size in KBytes | DB2PGSIZE |
INT2 |
| 392 | DB2PIECEI4 |
Maximum size of a data set storage piece in KBytes | INT4 | |
| 393 | DB2PIECEIZ |
Maximum size of a dataset storage piece in KBytes | DB2PIECEIZ |
INT2 |
| 394 | DB2PINDB2 |
Time spent in DB2 / Activity time (%) | DB2CHAR10 |
CHAR |
| 395 | DB2PIO |
I/O suspension time / Time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 396 | DB2PIXNAME |
Name of the partitioned index | CHAR18 |
CHAR |
| 397 | DB2PLKLA |
Lock (Latch) supension time / Time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 398 | DB2PLOGWR |
Percent of time spent in DB2 for log write I/O | DB2CHAR10 |
CHAR |
| 399 | DB2PMDELCM |
Delete DB2PM API command trace file | FLAG |
CHAR |
| 400 | DB2PMDELCN |
Delete DB2PM API connection trace file | FLAG |
CHAR |
| 401 | DB2PMDELDT |
Delete DB2PM API data trace file | FLAG |
CHAR |
| 402 | DB2PMDISCM |
Display DB2PM API command trace | FLAG |
CHAR |
| 403 | DB2PMDISCN |
Display DB2PM API connection trace | FLAG |
CHAR |
| 404 | DB2PMDISDT |
Display DB2PM API data trace | FLAG |
CHAR |
| 405 | DB2PMSTACM |
Start DB2PM API command trace | FLAG |
CHAR |
| 406 | DB2PMSTACN |
Start DB2PM API connection trace | FLAG |
CHAR |
| 407 | DB2PMSTADT |
Start DB2PM API data trace | FLAG |
CHAR |
| 408 | DB2PMSTOCM |
Stop DB2PM API command trace | FLAG |
CHAR |
| 409 | DB2PMSTOCN |
Stop DB2PM API connection trace | FLAG |
CHAR |
| 410 | DB2PMSTODT |
Stop DB2PM API data trace | FLAG |
CHAR |
| 411 | DB2PMTRLVL |
DB2PM API trace level | DB2PMTRLVL |
INT4 |
| 412 | DB2PMTRTYP |
DB2PM API trace type | DB2PMTRTYP |
INT4 |
| 413 | DB2PNAINDB |
Not attributed time in DB2 / Time spent in DB2 | DB2CHAR10 |
CHAR |
| 414 | DB2PNCDEVT |
Device on which the SYSREC dataset resides | DB2DEVT |
CHAR |
| 415 | DB2PNCHDSN |
Dataset allocated to the SYSPUNCH DDNAME | DB2DDN |
CHAR |
| 416 | DB2PNCHSPC |
Primary space allocation for the SYSPNCH dataset (cyl.) | DB2DDPQTYC |
INT2 |
| 417 | DB2PNOTM |
Notify messages suspension time / Time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 418 | DB2POCST |
Time for open/close ST / time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 419 | DB2POTHR |
Other read suspensions time / Time spent in db2 (%) | DB2CHAR10 |
CHAR |
| 420 | DB2POTHRST |
Time for other service task / time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 421 | DB2POTHW |
Other write suspensions time / Time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 422 | DB2POUDB2 |
Time spent out of DB2 / Activity time (%) | DB2CHAR10 |
CHAR |
| 423 | DB2POUTDB2 |
Time spent out of DB2 / Activity time (%) | DB2TIMEP |
CHAR |
| 424 | DB2PPGLA |
Page latch suspension time / Time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 425 | DB2PQTY |
Primary space allocation | INT4 | |
| 426 | DB2PRCIN |
Thread activity: % processing in DB2 | DB2CHAR10 |
CHAR |
| 427 | DB2PREFDIS |
Number of Times Sequential Prefetch Was Disabled | DB2DEC20V |
DEC |
| 428 | DB2PREPR |
Number of Prepare Requests | DB2DEC19V |
DEC |
| 429 | DB2PRIQTY |
DB2/390: Primary quantity | DB2PRIQTY |
NUMC |
| 430 | DB2PROCDB2 |
Percentage of time spent processing in DB2 | DB2TIMEP |
CHAR |
| 431 | DB2PROCID |
process ID | NUMC | |
| 432 | DB2PROCTYP |
process type | CHAR | |
| 433 | DB2PSID |
DB2 page set ID | INT2 |
INT2 |
| 434 | DB2PSIDC |
DB2 page set ID | DB2INT4 |
INT4 |
| 435 | DB2PSLST |
Time SYSLGRNG recording service task / time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 436 | DB2PSNAME |
Pageset name | DB2CHAR08 |
CHAR |
| 437 | DB2PSRVT |
Time commit phase 2 or abort / Time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 438 | DB2PSTYPE |
Type of pageset | DB2CHAR5 |
CHAR |
| 439 | DB2PSUSPIN |
Time spent suspended in DB2 / Time spent in DB2 (%) | DB2CHAR10 |
CHAR |
| 440 | DB2PTCPU |
Total CPU time / Activity time | DB2TIMEP |
CHAR |
| 441 | DB2PWPWIO |
Pages written per write I/O | DB2DEC19V2 |
DEC |
| 442 | DB2Q316CCT |
Accumulated CPU Time | CHAR | |
| 443 | DB2Q316CLX |
Statement Line Number | DB2CHAR10 |
CHAR |
| 444 | DB2Q316CRS |
RID List Not Used due to Insufficient Storage | CHAR | |
| 445 | DB2Q316CRT |
RID List Not Used due to DB2 Limits Exceeded | CHAR | |
| 446 | DB2QM316CT |
Accumulated CPU Time | DB2CHAR16 |
CHAR |
| 447 | DB2QM316TS |
Timestamp: Begin of Statistics Collection | DB2CHAR16 |
CHAR |
| 448 | DB2QM316W1 |
Accumulated Wait Time for Synchronous I/O | DB2CHAR16 |
CHAR |
| 449 | DB2QM316W2 |
Accumulated Wait Time for Lock and Latch Req. | DB2CHAR16 |
CHAR |
| 450 | DB2QM316W3 |
Accumulated Wait Time for Sync. Execution Unit Switch | DB2CHAR16 |
CHAR |
| 451 | DB2QM316W4 |
Accumulated Wait Time for Global Locks | DB2CHAR16 |
CHAR |
| 452 | DB2QM316W5 |
Accumulated Wait Time for Read Activity by Another Thread | DB2CHAR16 |
CHAR |
| 453 | DB2QM316W6 |
Accumulated Wait Time for Write Activity by Another Thread | DB2CHAR16 |
CHAR |
| 454 | DB2QR4ADM |
DB2 for OS/390: Data collector admin userid | CHAR8 |
CHAR |
| 455 | DB2QR4DATA |
DB2 for OS/390: Types of collected history | CHAR20 |
CHAR |
| 456 | DB2QR4DSET |
DB2 for OS/390: History data set name | CHAR44 |
CHAR |
| 457 | DB2QR4DSPS |
DB2 for OS/390: History data space size | INT4 | |
| 458 | DB2QR4DSS |
DB2 for OS/390: History data set size | INT4 | |
| 459 | DB2QR4DTI |
DB2 for OS/390: History collection interval in seconds | INT4 | |
| 460 | DB2QR4INTV |
DB2 for OS/390: Common history interval in seconds | INT4 | |
| 461 | DB2QR4MODE |
DB2 for OS/390: History uses data space field | CHAR9 |
CHAR |
| 462 | DB2QR4QNM |
DB2 for OS/390: History qualifier names | CHAR256 |
CHAR |
| 463 | DB2QR4QVAL |
DB2 for OS/390: History qualifier value | CHAR12 |
CHAR |
| 464 | DB2QR4STAT |
DB2 for OS/390: History processing on/off | BYTE |
RAW |
| 465 | DB2QSTAET |
Time elapsed | DB2DEC16 |
DEC |
| 466 | DB2QSTAETC |
Time elapsed | CHAR | |
| 467 | DB2QSTCAET |
Time elapsed | CHAR | |
| 468 | DB2QSTCCOP |
Number of copies of the statement | DB2NUMC10 |
NUMC |
| 469 | DB2QSTCERO |
Rows Examined | NUMC | |
| 470 | DB2QSTCEXE |
Number of executions of the statement | NUMC | |
| 471 | DB2QSTCGPA |
Getpages | NUMC | |
| 472 | DB2QSTCIND |
Number of index scans performed for statement | NUMC | |
| 473 | DB2QSTCLRU |
Statement removed from cache by LRU (last recently used) | DB2CHAR05 |
CHAR |
| 474 | DB2QSTCOPY |
Number of copies of the statement | DB2INT4 |
INT4 |
| 475 | DB2QSTCPLG |
Number of parallel groups created for statement | NUMC | |
| 476 | DB2QSTCPRO |
Rows Processed | NUMC | |
| 477 | DB2QSTCRBU |
Synchronous Reads | NUMC | |
| 478 | DB2QSTCSOR |
Number of sorts performed for statement | NUMC | |
| 479 | DB2QSTCSTN |
DB2 statement name | DB2RAW16 |
RAW |
| 480 | DB2QSTCTOK |
Statement ID | DB2NUMC10 |
NUMC |
| 481 | DB2QSTCTSC |
Number of tablespace scans performed for statement | NUMC | |
| 482 | DB2QSTCUSE |
Current Copies | NUMC | |
| 483 | DB2QSTCWRI |
Synchronous Writes | NUMC | |
| 484 | DB2QSTEROW |
Rows examined (Only data rows are taken into account) | DB2DEC19V |
DEC |
| 485 | DB2QSTEXEC |
Number of executions of the statement | DB2DEC19V |
DEC |
| 486 | DB2QSTGPAG |
Getpages | DB2DEC19V |
DEC |
| 487 | DB2QSTIDDL |
Statement invalidated by DROP or ALTER | DB2CHAR05 |
CHAR |
| 488 | DB2QSTINDX |
Number of index scans performed for statement | DB2DEC19V |
DEC |
| 489 | DB2QSTIRST |
Statement invalidated by RUNSTATS | DB2CHAR05 |
CHAR |
| 490 | DB2QSTIRVK |
Statement invalidated by REVOKE | DB2CHAR05 |
CHAR |
| 491 | DB2QSTISTC |
Time when statement was inserted into cache | DB2CHAR14 |
CHAR |
| 492 | DB2QSTISTM |
Time when statement was inserted into cache | DB2RAW10 |
RAW |
| 493 | DB2QSTLR |
Cache literal replacement indicator | CHAR | |
| 494 | DB2QSTPLGP |
Number of parallel groups created for statement | DB2DEC19V |
DEC |
| 495 | DB2QSTPROW |
Rows Processed | DB2DEC19V |
DEC |
| 496 | DB2QSTRBUF |
Synchronous Reads | DB2DEC19V |
DEC |
| 497 | DB2QSTSORT |
Number of sorts performed for statement | DB2DEC19V |
DEC |
| 498 | DB2QSTSTAC |
Status of the statement | DB2CHAR01 |
CHAR |
| 499 | DB2QSTSTAT |
Status of the statement | DB2CHAR30 |
CHAR |
| 500 | DB2QSTSTLN |
The length of the SQL Statement | INT2 |
INT2 |
