SAP ABAP Data Element - Index D, page 5
Data Element - D
| # | Data Element | Short Description | Domain | Data Type |
|---|---|---|---|---|
 |
|
|
|
|
| 1 |  DB2CGETPRN |
Number of Random Access Getpage Requests |  DB2CHAR10 |
CHAR |
| 2 | DB2CGHITRA |
Dynamic Statement Cache Global Hit Ratio | DB2DEC5_2 |
DEC |
| 3 | DB2CHANGES |
DB2/390: changes vs. all executions in percent | DB2NUMC05 |
NUMC |
| 4 | DB2CHANPG |
Changed pages | DB2DECPCT |
DEC |
| 5 | DB2CHAR01 |
Field type char, length 1 | DB2CHAR01 |
CHAR |
| 6 | DB2CHAR02 |
Field type char, length 2 | DB2CHAR02 |
CHAR |
| 7 | DB2CHAR03 |
Field type char, length 3 | DB2CHAR03 |
CHAR |
| 8 | DB2CHAR04 |
Field type char, length 4 | DB2CHAR04 |
CHAR |
| 9 | DB2CHAR05 |
Field type char, length 5 | DB2CHAR05 |
CHAR |
| 10 | DB2CHAR06 |
Field type char, length 6 | DB2CHAR06 |
CHAR |
| 11 | DB2CHAR08 |
Field type char, length 8 | DB2CHAR08 |
CHAR |
| 12 | DB2CHAR12 |
Field type char, length 12 | DB2CHAR12 |
CHAR |
| 13 | DB2CHAR16 |
Field type char, length 16 | DB2CHAR16 |
CHAR |
| 14 | DB2CHAR17 |
Field type char, length 17 | DB2CHAR17 |
CHAR |
| 15 | DB2CHAR20 |
Data element of length 20 | DB2CHAR20 |
CHAR |
| 16 | DB2CHAR22 |
Field type char, length 22 | DB2CHAR22 |
CHAR |
| 17 | DB2CHAR256 |
char 256 | CHAR256 |
CHAR |
| 18 | DB2CHAR30 |
Field type CHAR, length 30 | DB2CHAR30 |
CHAR |
| 19 | DB2CHAR40 |
Data element of length 40 | DB2CHAR40 |
CHAR |
| 20 | DB2CHGEXD5 |
Number of extents: change per day | DEC5 |
DEC |
| 21 | DB2CHGEXDI |
Number of extents: change per day | INT4 | |
| 22 | DB2CHGEXM5 |
Number of extents: change per month | DEC5 |
DEC |
| 23 | DB2CHGEXMI |
Number of extents: change per month | INT4 | |
| 24 | DB2CHGEXT5 |
Number of extents: change per day | DEC5 |
DEC |
| 25 | DB2CHGEXTD |
Number of extents: change per day | DEC3 |
DEC |
| 26 | DB2CHGEXTM |
Number of extents: change per month | DEC3 |
DEC |
| 27 | DB2CHGEXTT |
Number of extents: change per time interval | DEC3 |
DEC |
| 28 | DB2CHGEXTW |
Number of extents: change per week | DEC3 |
DEC |
| 29 | DB2CHGEXW5 |
Number of extents: change per week | DEC5 |
DEC |
| 30 | DB2CHGEXWI |
Number of extents: change per week | INT4 | |
| 31 | DB2CHGFRED |
Free storage (allocated minus used) in KB: change per day | DEC11 |
DEC |
| 32 | DB2CHGFREM |
Free storage (allocated minus used) in KB: change per month | DEC11 |
DEC |
| 33 | DB2CHGFRET |
Free storage in KB: Change per time interval | DEC11 |
DEC |
| 34 | DB2CHGFREW |
Free storage (allocated minus used) in KB: change per week | DEC11 |
DEC |
| 35 | DB2CHGROWD |
Number of Rows: changes per day | FLTP |
FLTP |
| 36 | DB2CHGROWM |
Number of Rows: changes per month | FLTP |
FLTP |
| 37 | DB2CHGROWW |
Number of Rows: changes per week | FLTP |
FLTP |
| 38 | DB2CHGSIZD |
Allocated storage in KB: change per day | DEC11 |
DEC |
| 39 | DB2CHGSIZM |
Allocated storage in KB: change per month | DEC11 |
DEC |
| 40 | DB2CHGSIZT |
Allocated storage in KB: change per time interval | DEC11 |
DEC |
| 41 | DB2CHGSIZW |
Allocated storage in KB: change per week | DEC11 |
DEC |
| 42 | DB2CHGSPFD |
Change/day for DASD space (SYSIBM.SYSTABLES(SPACEF)) | FLTP |
FLTP |
| 43 | DB2CHGSPFM |
Change/month for DASD space (SYSIBM.SYSTABLES(SPACEF)) | FLTP |
FLTP |
| 44 | DB2CHGSPFW |
Change/week for DASD space (SYSIBM.SYSTABLES(SPACEF)) | FLTP |
FLTP |
| 45 | DB2CHGTBSD |
RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes | FLTP |
FLTP |
| 46 | DB2CHGTBSF |
Tx DB02: Absolute difference in comparison to first run | FLTP |
FLTP |
| 47 | DB2CHGTBSL |
Tx DB02: Absolute difference in comparison to previous run | FLTP |
FLTP |
| 48 | DB2CHGTBSM |
RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes | FLTP |
FLTP |
| 49 | DB2CHGTBSP |
Tx DB02: Difference (percent) in comparison to previous run | INT4 | |
| 50 | DB2CHGTBSW |
RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes | FLTP |
FLTP |
| 51 | DB2CHKCORR |
DB2 OS/390: corrective action for error in DB system check | CHAR80 |
CHAR |
| 52 | DB2CHKDATE |
DB2 for OS/390: Date of the check | DATUM |
DATS |
| 53 | DB2CHKDESC |
DB2 OS/390: Description of error reported by DB system check | CHAR80 |
CHAR |
| 54 | DB2CHKMSG |
DB2 for OS/390: Description of DB system check error message | CHAR254 |
CHAR |
| 55 | DB2CHKNAME |
DB2 for OS/390 DB system check - name of a check | CHAR50 |
CHAR |
| 56 | DB2CHKNUM |
DB2 for OS/390: Number of checks performed | NUM06 |
NUMC |
| 57 | DB2CHKOBJ |
DB2 for OS/390: Type of object checked in DB system check | DB2CHKOBJ |
CHAR |
| 58 | DB2CHKPTS |
Number of checkpoints taken | DB2NUMC05 |
NUMC |
| 59 | DB2CHKQUAL |
DB2 for OS/390: Qualifier of check object | CHAR50 |
CHAR |
| 60 | DB2CHKRSLT |
Result of DB2 Installation Parameter Check | CHAR10 |
CHAR |
| 61 | DB2CHKSEV |
DB2 for OS/390: Severity of error detected | DB2CHKSEV |
CHAR |
| 62 | DB2CHKTEXT |
Type of Check for DB2 Installation Parameter(s) Check | CHAR20 |
CHAR |
| 63 | DB2CHKTIME |
DB2 for OS/390: Time of the check | TIMES |
TIMS |
| 64 | DB2CHKTYPE |
DB2 for OS/390: Type of DB system check | CHAR20 |
CHAR |
| 65 | DB2CHKVAL |
DB2 for OS/390: Parameter value in DB system check | CHAR50 |
CHAR |
| 66 | DB2CHKVAL_FOUND |
DB2 for OS/390: Parameter value in DB system check | CHAR50 |
CHAR |
| 67 | DB2CHKVAL_REC |
DB2 for OS/390: Parameter value in DB system check | CHAR50 |
CHAR |
| 68 | DB2CHPBACK |
Percentage of Hiperpool Buffers Backed | DB2CHAR06 |
CHAR |
| 69 | DB2CHPEFF |
Hiperpool efficiency | DB2CHAR06 |
CHAR |
| 70 | DB2CHPFAIL |
Number of Hiperpool Failures | DB2CHAR10 |
CHAR |
| 71 | DB2CHPREAR |
Hiperpool reads ratio (high) | DB2CHAR10 |
CHAR |
| 72 | DB2CHPRERA |
Hiperpool read ratio (low) | DB2CHAR10 |
CHAR |
| 73 | DB2CIFAANI |
Number of entries to and exits from IFI events | DB2NUMC10 |
NUMC |
| 74 | DB2CIFAETT |
Accumulated elapsed time spent processing IFI calls | DB2CHAR16 |
CHAR |
| 75 | DB2CIFATTT |
Accumulated CPU time spent processing IFI calls | DB2CHAR16 |
CHAR |
| 76 | DB2CINDB2 |
Percentage of time spent in DB2 | DB2TIMEP |
CHAR |
| 77 | DB2CINT2 |
DB2SINT |
INT2 | |
| 78 | DB2CINT4 |
Field Type INT, Length 4 | DB2INT4 |
INT4 |
| 79 | DB2CISECT |
Current number of pages in EDM pool used for cursor tables | DB2NUMC10 |
NUMC |
| 80 | DB2CISECTG |
Number of requests for cursor table sections | DB2NUMC10 |
NUMC |
| 81 | DB2CISECTL |
Number of CT sections not found in EDM pool | DB2NUMC10 |
NUMC |
| 82 | DB2CISEDBD |
Current number of pages in EDM pool used for DB descriptor | DB2NUMC10 |
NUMC |
| 83 | DB2CISEDBG |
Number of requests for database descriptor | DB2NUMC10 |
NUMC |
| 84 | DB2CISEDBL |
Number of DB descriptors not found in EDM pool | DB2NUMC10 |
NUMC |
| 85 | DB2CISEDFA |
Number of failures because the data space is full | DB2NUMC10 |
NUMC |
| 86 | DB2CISEDFR |
Number of free pages in the data space free chain | DB2NUMC10 |
NUMC |
| 87 | DB2CISEDPG |
Number of pages in the data space used by the EDM pool | DB2NUMC10 |
NUMC |
| 88 | DB2CISEDSC |
Number of pages used for DSC | DB2NUMC10 |
NUMC |
| 89 | DB2CISEDSG |
Number of requests for DSC sections | DB2NUMC10 |
NUMC |
| 90 | DB2CISEDSI |
Number of inserts into EDM pool for dynamic statement cache | DB2NUMC10 |
NUMC |
| 91 | DB2CISEFRE |
Current number of free pages in the free chain | DB2NUMC10 |
NUMC |
| 92 | DB2CISEKT |
Current number of pages in EDM pool used for package tables | DB2NUMC10 |
NUMC |
| 93 | DB2CISEKTG |
Number of requests for package table sections | DB2NUMC10 |
NUMC |
| 94 | DB2CISEKTL |
Number of times a PT section was not found in EDM pool | DB2NUMC10 |
NUMC |
| 95 | DB2CISEPAG |
Current number of pages in the EDM pool | DB2NUMC10 |
NUMC |
| 96 | DB2CISESKC |
Current number of pages in EDM pool used for skeleton CT | DB2NUMC10 |
NUMC |
| 97 | DB2CISESKP |
Current number of pages in EDM pool used for skeleton PT | DB2NUMC10 |
NUMC |
| 98 | DB2CISTRCU |
RID block allocated - current | DB2NUMC10 |
NUMC |
| 99 | DB2CISTRHI |
RID blocks allocated - maximum | DB2NUMC10 |
NUMC |
| 100 | DB2CISTRLL |
RDS limit exceeded | DB2NUMC10 |
NUMC |
| 101 | DB2CISTRMA |
Process limit exceeded | DB2NUMC10 |
NUMC |
| 102 | DB2CISTRPL |
Physical limit reached | DB2NUMC10 |
NUMC |
| 103 | DB2CISTRST |
RID list processing exhausted virtual storage | DB2NUMC10 |
NUMC |
| 104 | DB2CJSTALR |
Number of archive log read allocations | DB2NUMC10 |
NUMC |
| 105 | DB2CJSTALW |
Number of archive log write allocations | DB2NUMC10 |
NUMC |
| 106 | DB2CJSTBFF |
Number of Active Log Output Control Intervals Created | DB2NUMC10 |
NUMC |
| 107 | DB2CJSTBFW |
Number of calls to the log write routine | DB2NUMC10 |
NUMC |
| 108 | DB2CJSTBSD |
Number of BSDS Access Requests | DB2NUMC10 |
NUMC |
| 109 | DB2CJSTCIO |
Count of Control Intervals Offloaded | DB2NUMC10 |
NUMC |
| 110 | DB2CJSTLAM |
Check Tape Mounts Attempted | DB2NUMC10 |
NUMC |
| 111 | DB2CJSTLAS |
Successful "look ahead" (tape volume) mounts attempted | DB2NUMC10 |
NUMC |
| 112 | DB2CJSTRAC |
Number of Log Reads Satisfied from Active Log Data Set | DB2NUMC10 |
NUMC |
| 113 | DB2CJSTRAR |
Number of Log Reads Satisfied from Archive Log Data Set | DB2NUMC10 |
NUMC |
| 114 | DB2CJSTRBU |
Number of Log Reads Satisfied from Output Buffer | DB2NUMC10 |
NUMC |
| 115 | DB2CJSTTVC |
Read accesses delayed due to tape volume contention | DB2NUMC10 |
NUMC |
| 116 | DB2CJSTWRN |
Number of Write-No-Wait Requests | DB2NUMC10 |
NUMC |
| 117 | DB2CJSTWTB |
Unavailable output log buffers | DB2NUMC10 |
NUMC |
| 118 | DB2CJSTWUR |
Read accesses delayed due to unavailable resource | DB2NUMC10 |
NUMC |
| 119 | DB2CKCLASS |
DB2 for OS/390 check class for system check | DB2CKCLASS |
CHAR |
| 120 | DB2CKOP |
DB2 for OS/390: check operator (system check) | DB2CKOP |
CHAR |
| 121 | DB2CLCMD |
DB2CHAR256 |
LCHR | |
| 122 | DB2CLCMDL |
DB2SINT |
INT2 | |
| 123 | DB2CLERRL |
DB2SINT |
INT2 | |
| 124 | DB2CLGUID |
SMAPGUID |
CHAR | |
| 125 | DB2CLHITRA |
Dynamic Statement Cache Local Hit Ratio | DB2DEC5_2 |
DEC |
| 126 | DB2CLKEY |
DB2INT4 |
INT4 | |
| 127 | DB2CLRC |
DB2INT4 |
INT4 | |
| 128 | DB2CLRELP |
Percent of time spent in DB2 for claim locks | DB2CHAR10 |
CHAR |
| 129 | DB2CLTESTM |
Field type char, length 1 | DB2CHAR01 |
CHAR |
| 130 | DB2CLTEXT |
CHAR254 |
CHAR | |
| 131 | DB2CLTRLV |
ICLI client trace level | INT4 | |
| 132 | DB2CLTSTP |
DB2INT4 |
INT4 | |
| 133 | DB2CLURAT |
DB2 for OS/390 cluster ratio | INT1 |
INT1 |
| 134 | DB2CLURAT2 |
Clusterratio: Percentage of rows in clustering order | DB2SINT |
INT2 |
| 135 | DB2CLURATI |
DB2 for OS/390 cluster ratio | DB2CLURATI |
CHAR |
| 136 | DB2CLUSTER |
Whether CLUSTER was specified when the index was created | DB2YNFLAG |
CHAR |
| 137 | DB2CLUSTRD |
Whether the table is actually clustered by the index | DB2YNFLAG |
CHAR |
| 138 | DB2CMPRESS |
Indicates whether the COMPRESS attribute is YES | CHAR1 |
CHAR |
| 139 | DB2CNUMC03 |
Field type numc, length 3, 1 byte | DB2NUMC03 |
NUMC |
| 140 | DB2CNUMC05 |
Field type numc, length 5, short integer | DB2NUMC05 |
NUMC |
| 141 | DB2CNUMC10 |
Field type numc, length 10, integer | DB2NUMC10 |
NUMC |
| 142 | DB2COLCNT |
Number of columns in the table or view | DB2SINT |
INT2 |
| 143 | DB2COLLEN |
Length attribute of the column | DB2SINT |
INT2 |
| 144 | DB2COLLEN2 |
column length | INT4 | |
| 145 | DB2COLNAME |
Column name | CHAR18 |
CHAR |
| 146 | DB2COLNAML |
DB2 column name | CHAR | |
| 147 | DB2COLNO |
Numeric position of the column in the table or view | DB2SINT |
INT2 |
| 148 | DB2COLSEQ |
Numeric position of the column in the key | DB2SINT |
INT2 |
| 149 | DB2COLTYPE |
Column type specified in the column definition | DB2COLTYPE |
CHAR |
| 150 | DB2COMRES |
The SQL statement text | DB2CHAR72 |
CHAR |
| 151 | DB2CONTYPE |
connection type | CHAR | |
| 152 | DB2CONVERTTYPE |
DB2 Type of Conversion | CHAR | |
| 153 | DB2COPY |
Index can be copied | CHAR1 |
CHAR |
| 154 | DB2CP1DEVT |
Device on which the SYSCOPY dataset resides | DB2DEVT |
CHAR |
| 155 | DB2CP1DSN |
Dataset allocated to the SYSCOPY DDNAME | DB2DDN |
CHAR |
| 156 | DB2CP1SPC |
Primary space allocation for the SYSCOPY dataset (cyl.) | DB2DDPQTYC |
INT2 |
| 157 | DB2CP2DEVT |
Device on which the SYSCOPY2 dataset resides | DB2DEVT |
CHAR |
| 158 | DB2CP2DSN |
Dataset allocated to the SYSCOPY2 DDNAME | DB2DDN |
CHAR |
| 159 | DB2CP2SPC |
Primary space allocation for the SYSCOPY2 dataset (cyl.) | DB2DDPQTYC |
INT2 |
| 160 | DB2CPAGEIN |
Number of page-ins | DB2CHAR10 |
CHAR |
| 161 | DB2CPGPDYN |
Number of Pages Read per Dynamic Prefetch Read | DB2CHAR10 |
CHAR |
| 162 | DB2CPGPLIS |
Number of Pages Read per List Prefetch Read | DB2CHAR10 |
CHAR |
| 163 | DB2CPGPSEQ |
Number of Pages Read per Sequential Prefetch Read | DB2CHAR10 |
CHAR |
| 164 | DB2CPREFDI |
Number of Times Sequential Prefetch Was Disabled | DB2CHAR10 |
CHAR |
| 165 | DB2CPREPR |
Number of Prepare Requests | DB2NUMC10 |
NUMC |
| 166 | DB2CPRODB2 |
Percentage of time spent processing in DB2 | DB2TIMEP |
CHAR |
| 167 | DB2CPUTOT |
Total CPU processing time | DB2CHAR16 |
CHAR |
| 168 | DB2CPWPWI |
Pages written per write I/O | DB2CHAR10 |
CHAR |
| 169 | DB2CPYCHG |
CHANGELIMIT option of COPY utility | DB2YESNO |
CHAR |
| 170 | DB2CPYCL1 |
First value in the CHANGELIMIT range | DB2PCTC |
CHAR |
| 171 | DB2CPYCL2 |
Second value in the CHANGELIMIT range | DB2PCTC |
CHAR |
| 172 | DB2CPYDB |
Name of the database the tablespace belongs to | DB2DBNAME |
CHAR |
| 173 | DB2CPYDS |
Partition or data set that is to be copied | CHAR3 |
CHAR |
| 174 | DB2CPYFULL |
Specifies if either a full or an incremental copy is taken | DB2YESNO |
CHAR |
| 175 | DB2CPYREPO |
Specifies that image copy information is only displayed | DB2YNFLAG |
CHAR |
| 176 | DB2CPYSHR |
COPY share level | DB2SHRLVL |
CHAR |
| 177 | DB2CPYTS |
Table space that is to be copied | DB2TSNAME |
CHAR |
| 178 | DB2CRACNAC |
Number of failures in adding an entry to authorization cache | DB2NUMC10 |
NUMC |
| 179 | DB2CRACOW1 |
Number of authorization ID overrides in authorization cache | DB2NUMC10 |
NUMC |
| 180 | DB2CRACOW2 |
Number of routine entry overrides in authorization cache | DB2NUMC10 |
NUMC |
| 181 | DB2CRACPUB |
Number of successful public authorization checks | DB2NUMC10 |
NUMC |
| 182 | DB2CRANOT |
Number of authorization checks without authorization cache | DB2NUMC10 |
NUMC |
| 183 | DB2CRAW01 |
Field type raw, length 2, 1 byte | DB2RAW01 |
RAW |
| 184 | DB2CRAW04 |
Field type raw, length 8, 4 bytes | DB2INT4 |
INT4 |
| 185 | DB2CREADRA |
Read rate per second | DB2CHAR10 |
CHAR |
| 186 | DB2CREADTS |
Time when the CREATE statement was executed | DB2TMSTMP |
CHAR |
| 187 | DB2CREADWR |
Pages read vs. pages written | DB2CHAR10 |
CHAR |
| 188 | DB2CREATOR |
DB2 creator name | CHAR8 |
CHAR |
| 189 | DB2CREATORL |
DB2 creator name | CHAR | |
| 190 | DB2CREATPI |
Authorization ID of the creator of the partitioned index | DB2CREATOR |
CHAR |
| 191 | DB2CRES01 |
Field type char, length 1, reserved | DB2CHAR01 |
CHAR |
| 192 | DB2CRES02 |
Field type char, length 2, reserved | DB2CHAR02 |
CHAR |
| 193 | DB2CRES03 |
Field type char, length 3, reserved | DB2CHAR03 |
CHAR |
| 194 | DB2CRES04 |
Field type char, length 4, reserved | DB2CHAR04 |
CHAR |
| 195 | DB2CRES05 |
Character field of length 5 (reserved) | DB2CHAR05 |
CHAR |
| 196 | DB2CRLFERR |
Resource limit facility error parameter | DB2CHAR15 |
CHAR |
| 197 | DB2CRNDHIT |
Random hit ratio | DB2CHAR10 |
CHAR |
| 198 | DB2CRPRERA |
Reprepare Ratio | DB2DEC5_2 |
DEC |
| 199 | DB2CRULE |
Data sets for closure when limit of open data sets reached | DB2CRULE |
CHAR |
| 200 | DB2CSHPREP |
Number of Short Prepares | DB2NUMC10 |
NUMC |
| 201 | DB2CSQTYK |
Current value (KB) of secondary quantity from catalog | INT4 | |
| 202 | DB2CSTOTOT |
DB2/390: Total central storage available for all bufferpools | DB2NUMC10 |
NUMC |
| 203 | DB2CSYNRRN |
Number of Random Access Synchronous Reads | DB2NUMC10 |
NUMC |
| 204 | DB2CTDSDRN |
Number of datasets that were closed via the DRAIN process | DB2NUMC10 |
NUMC |
| 205 | DB2CTDSOPN |
Number of datasets open concurrently | DB2NUMC10 |
NUMC |
| 206 | DB2CTIFIEL |
IFI entry/exit duration elapsed time | DB2CHAR10 |
CHAR |
| 207 | DB2CTIFIPR |
IFI entry/exit duration processing (CPU) | DB2CHAR10 |
CHAR |
| 208 | DB2CTIME |
Field type time, HHMMSS | DB2TIME |
TIMS |
| 209 | DB2CTMAXDS |
Max. no. of datasets open concurrently | DB2NUMC10 |
NUMC |
| 210 | DB2CTMAXPB |
Page sets available to drain since last statistics interval | DB2NUMC10 |
NUMC |
| 211 | DB2CTPCCT |
No. of infrequently updated datasets conv. from R/W to R/O | DB2NUMC10 |
NUMC |
| 212 | DB2CTRACAU |
Number of successful authorization checks | DB2NUMC10 |
NUMC |
| 213 | DB2CTREOPN |
Number of times a previously unused dataset was used | DB2NUMC10 |
NUMC |
| 214 | DB2CTSLWDD |
Datasets not used, but not closed due to deferred close | DB2NUMC10 |
NUMC |
| 215 | DB2CTXACHG |
Number of change requests | DB2NUMC10 |
NUMC |
| 216 | DB2CTXACLN |
Number of claim requests | DB2NUMC10 |
NUMC |
| 217 | DB2CTXACLU |
Number of claim requests that were unsuccessful | DB2NUMC10 |
NUMC |
| 218 | DB2CTXADEA |
Number of deadlocks | DB2NUMC10 |
NUMC |
| 219 | DB2CTXADRN |
Number of drain requests | DB2NUMC10 |
NUMC |
| 220 | DB2CTXADRU |
Number of drain requests that were unsuccessful | DB2NUMC10 |
NUMC |
| 221 | DB2CTXAIRL |
Number of other requests | DB2NUMC10 |
NUMC |
| 222 | DB2CTXALES |
Number of lock escalations (shared) | DB2NUMC10 |
NUMC |
| 223 | DB2CTXALEX |
Number of lock escalations (exclusive) | DB2NUMC10 |
NUMC |
| 224 | DB2CTXALOC |
Number of lock requests | DB2NUMC10 |
NUMC |
| 225 | DB2CTXANLP |
Maximum page or row locks held | DB2NUMC10 |
NUMC |
| 226 | DB2CTXAQRY |
Number of query requests | DB2NUMC10 |
NUMC |
| 227 | DB2CTXASLA |
Number of latch suspensions | DB2NUMC10 |
NUMC |
| 228 | DB2CTXASLO |
Number of lock suspensions | DB2NUMC10 |
NUMC |
| 229 | DB2CTXASOT |
Number of other suspensions | DB2NUMC10 |
NUMC |
| 230 | DB2CTXATIM |
Number of timeouts | DB2NUMC10 |
NUMC |
| 231 | DB2CTXAUNL |
Number of unlock requests | DB2NUMC10 |
NUMC |
| 232 | DB2CUPPPWR |
Buffer update per pages written | DB2CHAR10 |
CHAR |
| 233 | DB2CVPSHOR |
Number of Virtual Pool Shortages | DB2CHAR10 |
CHAR |
| 234 | DB2CVRSLT |
DB2/390: Conversion Result Set | DB2CVRESLT |
CHAR |
| 235 | DB2CW5DCYC |
Deadlock cycle | DB2NUMC05 |
NUMC |
| 236 | DB2CW5DLOK |
Deadlock time (ms) | DB2NUMC05 |
NUMC |
| 237 | DB2CW5MCSA |
IRLM maximum CSA usage allowed | DB2NUMC10 |
NUMC |
| 238 | DB2CW5TVAL |
Actual resource timeout | DB2NUMC10 |
NUMC |
| 239 | DB2CWACLRA |
Total number bytes of log records written | DB2CHAR10 |
CHAR |
| 240 | DB2CWACLRN |
Number of log records written | DB2NUMC10 |
NUMC |
| 241 | DB2CWFNPDM |
Average Work Files Not Given per Degraded Merge Pass | DB2CHAR10 |
CHAR |
| 242 | DB2CWFPMRG |
Average Work Files per Merge Pass | DB2CHAR10 |
CHAR |
| 243 | DB2CWHCEUI |
The end user's work station user ID | CHAR16 |
CHAR |
| 244 | DB2CWHCEUT |
Transaction or application the end user is running | CHAR32 |
CHAR |
| 245 | DB2CWHCEUW |
The end user's workstation name | CHAR18 |
CHAR |
| 246 | DB2CWP4ABN |
Indicates whether autobind operations are allowed | DB2CHAR03L |
CHAR |
| 247 | DB2CWP4ABX |
Indicates Whether Explain is Allowed During Autobind | DB2CHAR03L |
CHAR |
| 248 | DB2CWP4AD2 |
The authorization ID of the system administrator 2 | CHAR8 |
CHAR |
| 249 | DB2CWP4AUC |
Indicates the size of the authorization cache | DB2NUMC10 |
NUMC |
| 250 | DB2CWP4AUT |
DB2 authorization | DB2CHAR08L |
CHAR |
| 251 | DB2CWP4BNV |
Indicates the authorities required to add a new package | CHAR10 |
CHAR |
| 252 | DB2CWP4CD |
Indicates Whether Change Data Capture is Enabled | DB2CHAR03L |
CHAR |
| 253 | DB2CWP4CDE |
Default Parallelism Degree | DB2CHAR03 |
CHAR |
| 254 | DB2CWP4CDY |
Cache prepared dynamic SQL statements | DB2CHAR03L |
CHAR |
| 255 | DB2CWP4CON |
Storage Contraction | DB2CHAR03L |
CHAR |
| 256 | DB2CWP4CTH |
Storage Contraction Threshold (Commits) | DB2NUMC05 |
NUMC |
| 257 | DB2CWP4DCF |
SMS Dataclass for tablespaces | DB2CHAR08 |
CHAR |
| 258 | DB2CWP4DCI |
SMS Dataclass for indexspaces | DB2CHAR08 |
CHAR |
| 259 | DB2CWP4DDN |
Asynchronous drain start | DB2NUMC10 |
NUMC |
| 260 | DB2CWP4DFI |
The authorization ID of the system default user | CHAR8 |
CHAR |
| 261 | DB2CWP4DI3 |
Minimum Divide Scale | DB2CHAR03L |
CHAR |
| 262 | DB2CWP4DSP |
Maximum locks per table(space) before escalation | DB2NUMC10 |
NUMC |
| 263 | DB2CWP4DSS |
If an SQLDA for Describe is Built During Bind for Static SQL | DB2CHAR03L |
CHAR |
| 264 | DB2CWP4DXT |
Default index type | DB2NUMC10 |
NUMC |
| 265 | DB2CWP4EBF |
EDM Pool Algorithm | DB2CHAR10 |
CHAR |
| 266 | DB2CWP4EDD |
EDM Pool Data Space Size (MB) | DB2NUMC10 |
NUMC |
| 267 | DB2CWP4EDP |
Maximum Size of the EDM Pool (MB) | DB2NUMC10 |
NUMC |
| 268 | DB2CWP4ENF |
Indicates Whether DPROP is Supported | DB2CHAR03L |
CHAR |
| 269 | DB2CWP4ESC |
The data definition escape character for ART and ORT search | CHAR4 |
CHAR |
| 270 | DB2CWP4HIN |
Indicates Whether Access Path Hints are Allowed | DB2CHAR03L |
CHAR |
| 271 | DB2CWP4HOP |
Hop site authorization | DB2CHAR10 |
CHAR |
| 272 | DB2CWP4IAT |
Autostart of IRLM | CHAR4 |
CHAR |
| 273 | DB2CWP4IAU |
Indicates whether IRLM is started automatically by DB2 | CHAR4 |
CHAR |
| 274 | DB2CWP4IPR |
Name of IRLM procedure which DB2 uses to start IRLM | CHAR8 |
CHAR |
| 275 | DB2CWP4ISI |
Name of the IRLM subsystem by which IRLM is known to MVS | CHAR4 |
CHAR |
| 276 | DB2CWP4ISW |
Seconds DB2 will wait for IRLM start | DB2NUMC10 |
NUMC |
| 277 | DB2CWP4LEM |
Max. no. of language environment tokens active at any time | DB2NUMC05 |
NUMC |
| 278 | DB2CWP4LKT |
Maximum number of locks per tablespace | DB2NUMC10 |
NUMC |
| 279 | DB2CWP4LKU |
Maximum number of locks per user | DB2NUMC10 |
NUMC |
| 280 | DB2CWP4MDD |
Asynchronous drain stop | DB2NUMC10 |
NUMC |
| 281 | DB2CWP4MXK |
Maximum number of prepared dynamic statements | DB2NUMC10 |
NUMC |
| 282 | DB2CWP4NPA |
NPAGES threshold for index scan | DB2NUMC05 |
NUMC |
| 283 | DB2CWP4OJE |
Outer Join Performance Enhancement | DB2CHAR03L |
CHAR |
| 284 | DB2CWP4OP1 |
The authorization ID of the system operator 1 | CHAR8 |
CHAR |
| 285 | DB2CWP4OP2 |
The authorization ID of the system operator 2 | CHAR8 |
CHAR |
| 286 | DB2CWP4PAC |
Package authorization cache | DB2NUMC10 |
NUMC |
| 287 | DB2CWP4PST |
Utility Cache Option | DB2CHAR03L |
CHAR |
| 288 | DB2CWP4RAC |
Routine authorization cache size | DB2NUMC10 |
NUMC |
| 289 | DB2CWP4RCH |
If Page or Row Locks for Held Cursors are Released at Commit | DB2CHAR03L |
CHAR |
| 290 | DB2CWP4REA |
Name of the application registration table | CHAR17 |
CHAR |
| 291 | DB2CWP4RED |
Whether Only Registered Packages or Plans Can Use DDL | DB2CHAR03L |
CHAR |
| 292 | DB2CWP4REG |
Owner of the application registration table | CHAR8 |
CHAR |
| 293 | DB2CWP4REI |
Whether Data Definition Control Support is to Be Used | DB2CHAR03L |
CHAR |
| 294 | DB2CWP4REN |
Name of the database containing the registration tables | CHAR8 |
CHAR |
| 295 | DB2CWP4REO |
The name of the object registration table | CHAR17 |
CHAR |
| 296 | DB2CWP4REQ |
Whether Two-Part Names are Required for Objects Reg. in ORT | DB2CHAR03L |
CHAR |
| 297 | DB2CWP4REU |
Unregistered DDL Default | DB2CHAR10L |
CHAR |
| 298 | DB2CWP4RMA |
Maximum Size of RID Pool in the DB2 Subsystem (MB) | NUMC10 |
NUMC |
| 299 | DB2CWP4RRU |
UPDATE lock for repeatable read or read stability | DB2CHAR03L |
CHAR |
| 300 | DB2CWP4SAD |
The authorization ID of the system administrator 1 | CHAR8 |
CHAR |
| 301 | DB2CWP4SCA |
Sequential Mode to Read Cached Data from a 3990 Controller | CHAR | |
| 302 | DB2CWP4SIT |
Indicates Whether the Site is Local or Remote | DB2CHAR10L |
CHAR |
| 303 | DB2CWP4SPO |
Maximum Size of the Sort Pool (MB) | DB2INT4U |
INT4 |
| 304 | DB2CWP4STH |
Storage Contraction Threshold (MB) | DB2NUMC10 |
NUMC |
| 305 | DB2CWP4TOU |
Maximum time DB2 waits for the release of a locked resource | DB2NUMC10 |
NUMC |
| 306 | DB2CWP4UMD |
Maximum degree of utility parallelism | DB2NUMC10 |
NUMC |
| 307 | DB2CWP4UTO |
Utility timeout factor | NUMC6 |
NUMC |
| 308 | DB2CWP4VCF |
VARCHAR from Index | DB2CHAR03L |
CHAR |
| 309 | DB2CWP4WAI |
Multiplier for Determining Retained Lock Timeout | DB2NUMC05 |
NUMC |
| 310 | DB2CWP4XLD |
Whether X lock is Used for Searched Update or Delete | DB2CHAR06L |
CHAR |
| 311 | DB2CWP4XLU |
Flag if X lock is Used for Searched Update or Delete | DB2CHAR03L |
CHAR |
| 312 | DB2CWP6CAT |
High qualifier name for all DB2 system datasets | CHAR8 |
CHAR |
| 313 | DB2CWP8DBN |
Name of database to be automatically started | CHAR10 |
CHAR |
| 314 | DB2CWP8SPN |
Table space name or index space name | CHAR10 |
CHAR |
| 315 | DB2CWP9CMS |
Status of a DBAT | CHAR10 |
CHAR |
| 316 | DB2CWP9MX1 |
Maximum type 1 inactive threads allowed by DB2 | DB2NUMC10 |
NUMC |
| 317 | DB2CWP9RLE |
Resource Limit Facility Error Parameter | DB2CHAR10L |
CHAR |
| 318 | DB2CWP9RLF |
Specifies the Limit in CPU Time Service Units | DB2NUMC10 |
NUMC |
| 319 | DB2CWP9RYC |
Number of minutes between two resynchronization intervals | DB2NUMC10 |
NUMC |
| 320 | DB2CWP9STR |
The startup option for the distributed data facility (DDF) | CHAR14 |
CHAR |
| 321 | DB2CWP9TCP |
Whether Verified Conn. Are Accepted from TCP/IP Clients | DB2CHAR03L |
CHAR |
| 322 | DB2CWP9TTO |
Idle thread timeout | DB2NUMC10 |
NUMC |
| 323 | DB2CWPAASS |
Indicates whether this DB2 can assist parallel processing | DB2CHAR08 |
CHAR |
| 324 | DB2CWPACOO |
Whether a DB2 subsystem can be a parallelism coordinator | DB2CHAR08 |
CHAR |
| 325 | DB2CWPAGRP |
Name of a DB2 data sharing group | CHAR10 |
CHAR |
| 326 | DB2CWPAIOP |
Whether data sharing function is used or not | CHAR6 |
CHAR |
| 327 | DB2CWPAMAX |
Maximum Number of Members | DB2NUMC10 |
NUMC |
| 328 | DB2CWPAMBR |
Name of a new or existing DB2 data sharing member | CHAR10 |
CHAR |
| 329 | DB2CWPASUC |
CPU Service Unit Conversion Factor | DB2NUMC10 |
NUMC |
| 330 | DB2CWPBAGI |
ASCII GBCS CCSID | DB2NUMC10 |
NUMC |
| 331 | DB2CWPBAMI |
The ASCII mixed coded character set ID | DB2NUMC05 |
NUMC |
| 332 | DB2CWPBAR |
Indicates the rules of precision for a decimal field | DB2CHAR10L |
CHAR |
| 333 | DB2CWPBASI |
The ASCII single-byte coded character set ID | DB2NUMC05 |
NUMC |
| 334 | DB2CWPBCHA |
The default character set, which can be ALPHANUM or KATAKANA | CHAR10 |
CHAR |
| 335 | DB2CWPBDAT |
The default output format for dates | CHAR10 |
CHAR |
| 336 | DB2CWPBDE |
Whether the decimal contains a comma (,) or a period (.) | DB2CHAR08L |
CHAR |
| 337 | DB2CWPBDEL |
Default Delimiter | DB2CHAR10L |
CHAR |
| 338 | DB2CWPBDLE |
Local date length | NUMC10 |
NUMC |
| 339 | DB2CWPBDRU |
Indicates if DSNHDECP values are used for dyn.SQL statements | DB2CHAR03L |
CHAR |
| 340 | DB2CWPBDSD |
Distributed SQL string delimiter | DB2CHAR10L |
CHAR |
| 341 | DB2CWPBENS |
The default encoding scheme, which can be ASCII or EBCDIC. | CHAR8 |
CHAR |
| 342 | DB2CWPBGID |
The EBCDIC graphic coded character set ID | DB2NUMC05 |
NUMC |
| 343 | DB2CWPBGRA |
Default mixed graphic | DB2CHAR03L |
CHAR |
| 344 | DB2CWPBLAN |
The default programming language for your site | CHAR10 |
CHAR |
| 345 | DB2CWPBLCT |
Default Locale LC_CTYPE | DB2CHAR50L |
CHAR |
| 346 | DB2CWPBMID |
The EBCDIC mixed coded character set ID | DB2NUMC05 |
NUMC |
| 347 | DB2CWPBSDL |
The string delimiter for SQL | DB2CHAR10L |
CHAR |
| 348 | DB2CWPBSID |
The EBCDIC single-byte coded character set ID | DB2NUMC05 |
NUMC |
| 349 | DB2CWPBSQL |
SQL language support level | DB2CHAR03L |
CHAR |
| 350 | DB2CWPBTIM |
The default output format for times | CHAR10 |
CHAR |
| 351 | DB2CWPBTLE |
Local time length | NUMC10 |
NUMC |
| 352 | DB2CWRITRA |
Write rate = ( Synchronous + async. writes ) / interval | DB2CHAR10 |
CHAR |
| 353 | DB2CWSDCKP |
Number of checkpoints DB2 has taken since startup | DB2NUMC10 |
NUMC |
| 354 | DB2CWSDSC |
Count of IFI abends | DB2NUMC10 |
NUMC |
| 355 | DB2CWSDSCC |
Count of IFI command requests | DB2NUMC10 |
NUMC |
| 356 | DB2CWSDSCR |
Count of IFI READA requests | DB2NUMC10 |
NUMC |
| 357 | DB2CWSDSCS |
Count of IFI READS requests | DB2NUMC10 |
NUMC |
| 358 | DB2CWSDSCW |
Count of IFI WRITE requests | DB2NUMC10 |
NUMC |
| 359 | DB2CWSDSU |
Count of IFI unrecognized functions. | DB2NUMC10 |
NUMC |
| 360 | DB2CXALDAB |
Number of ALTER DATABASE statements executed | DB2NUMC10 |
NUMC |
| 361 | DB2CXALPRO |
Number of ALTER PROCEDURE statements | DB2NUMC10 |
NUMC |
| 362 | DB2CXALTIX |
Number of ALTER INDEX statements executed | DB2NUMC10 |
NUMC |
| 363 | DB2CXALTST |
Number of ALTER STORAGE GROUP statements executed | DB2NUMC10 |
NUMC |
| 364 | DB2CXALTTA |
Number of ALTER TABLE statements executed | DB2NUMC10 |
NUMC |
| 365 | DB2CXALTTS |
Number of ALTER TABLE SPACE statements executed | DB2NUMC10 |
NUMC |
| 366 | DB2CXALUDF |
Number of ALTER FUNCTION statements | DB2NUMC10 |
NUMC |
| 367 | DB2CXCALL |
Number of SQL CALL statements executed | DB2NUMC10 |
NUMC |
| 368 | DB2CXCASCD |
Maximum level of nested SQL cascading | DB2NUMC10 |
NUMC |
| 369 | DB2CXCAUD |
Number of user-defined functions executed | DB2NUMC10 |
NUMC |
| 370 | DB2CXCAUDB |
Number of times a user-defined function abended | DB2NUMC10 |
NUMC |
| 371 | DB2CXCAUDR |
Number of times a user-defined function was rejected | DB2NUMC10 |
NUMC |
| 372 | DB2CXCAUDT |
No. of times a user-defined funct. timed out before sched. | DB2NUMC10 |
NUMC |
| 373 | DB2CXCDIST |
Number of CREATE DISTINCT TYPE statements | DB2NUMC10 |
NUMC |
| 374 | DB2CXCLOSE |
Number of CLOSE CURSOR statements executed | DB2NUMC10 |
NUMC |
| 375 | DB2CXCMTON |
Number of COMMENT ON statements executed | DB2NUMC10 |
NUMC |
| 376 | DB2CXCON1 |
Number of CONNECT TYPE 1 statements executed | DB2NUMC10 |
NUMC |
| 377 | DB2CXCON2 |
Number of CONNECT TYPE 2 statements executed | DB2NUMC10 |
NUMC |
| 378 | DB2CXCRALS |
Number of CREATE ALIAS statements executed | DB2NUMC10 |
NUMC |
| 379 | DB2CXCRATB |
Number of CREATE AUXILIARY TABLE statements | DB2NUMC10 |
NUMC |
| 380 | DB2CXCRDAB |
Number of CREATE DATABASE statements executed | DB2NUMC10 |
NUMC |
| 381 | DB2CXCRINX |
Number of CREATE INDEX statements executed | DB2NUMC10 |
NUMC |
| 382 | DB2CXCRPRO |
Number of CREATE PROCEDURE statements | DB2NUMC10 |
NUMC |
| 383 | DB2CXCRSTG |
Number of CREATE STORAGE GROUP statements executed | DB2NUMC10 |
NUMC |
| 384 | DB2CXCRSYN |
Number of CREATE SYNONYM statements executed | DB2NUMC10 |
NUMC |
| 385 | DB2CXCRTAB |
Number of CREATE TABLE statements executed | DB2NUMC10 |
NUMC |
| 386 | DB2CXCRUDF |
Number of CREATE FUNCTION statements | DB2NUMC10 |
NUMC |
| 387 | DB2CXCTABS |
Number of CREATE TABLE SPACE statements executed | DB2NUMC10 |
NUMC |
| 388 | DB2CXCTRIG |
Number of SQL CREATE TRIGGER statements | DB2NUMC10 |
NUMC |
| 389 | DB2CXDDIST |
Number of DROP DISTINCT TYPE statements | DB2NUMC10 |
NUMC |
| 390 | DB2CXDEFVU |
Number of CREATE VIEW statements executed | DB2NUMC10 |
NUMC |
| 391 | DB2CXDELET |
Number of DELETE statements executed | DB2NUMC10 |
NUMC |
| 392 | DB2CXDESC |
Number of DESCRIBE statements executed | DB2NUMC10 |
NUMC |
| 393 | DB2CXDRPAL |
Number of DROP ALIAS statements executed | DB2NUMC10 |
NUMC |
| 394 | DB2CXDRPDB |
Number of DROP DATABASE statements executed | DB2NUMC10 |
NUMC |
| 395 | DB2CXDRPFN |
Number of DROP UDF statements | DB2NUMC10 |
NUMC |
| 396 | DB2CXDRPIX |
Number of DROP INDEX statements executed | DB2NUMC10 |
NUMC |
| 397 | DB2CXDRPPK |
Number of DROP PACKAGE statements executed | DB2NUMC10 |
NUMC |
| 398 | DB2CXDRPPR |
Number of DROP PROCEDURE statements | DB2NUMC10 |
NUMC |
| 399 | DB2CXDRPST |
Number of DROP STORAGE GROUP statements executed | DB2NUMC10 |
NUMC |
| 400 | DB2CXDRPSY |
Number of DROP SYNONYM statements executed | DB2NUMC10 |
NUMC |
| 401 | DB2CXDRPTA |
Number of DROP TABLE statements executed | DB2NUMC10 |
NUMC |
| 402 | DB2CXDRPTR |
Number of SQL DROP TRIGGER statements | DB2NUMC10 |
NUMC |
| 403 | DB2CXDRPTS |
Number of DROP TABLE SPACE statements executed | DB2NUMC10 |
NUMC |
| 404 | DB2CXDRPVU |
Number of DROP VIEW statements executed | DB2NUMC10 |
NUMC |
| 405 | DB2CXDSCRT |
Number of DESCRIBE TABLE statements executed | DB2NUMC10 |
NUMC |
| 406 | DB2CXFETCH |
Number of FETCH statements executed | DB2NUMC10 |
NUMC |
| 407 | DB2CXFREEL |
Number of FREE LOCATOR statements | DB2NUMC10 |
NUMC |
| 408 | DB2CXGRANT |
Number of GRANT statements executed | DB2NUMC10 |
NUMC |
| 409 | DB2CXHOLDL |
Number of HOLD LOCATOR statements | DB2NUMC10 |
NUMC |
| 410 | DB2CXINCRB |
Number of INCREMENTAL BINDs executed | DB2NUMC10 |
NUMC |
| 411 | DB2CXINSRT |
Number of INSERT statements executed | DB2NUMC10 |
NUMC |
| 412 | DB2CXLABON |
Number of LABEL ON statements executed | DB2NUMC10 |
NUMC |
| 413 | DB2CXLOCK |
Number of LOCK TABLE statements executed | DB2NUMC10 |
NUMC |
| 414 | DB2CXMIAP |
Number of times RID list processing is used | DB2NUMC10 |
NUMC |
| 415 | DB2CXMRMIA |
RID list processing failed - limit exeeded | DB2NUMC10 |
NUMC |
| 416 | DB2CXNSMIA |
RID list processing failed - no storage | DB2NUMC10 |
NUMC |
| 417 | DB2CXOPEN |
Number of OPEN CURSOR statements executed | DB2NUMC10 |
NUMC |
| 418 | DB2CXPREP |
Number of PREPARE statements executed | DB2NUMC10 |
NUMC |
| 419 | DB2CXREL |
Number of RELEASE statements executed | DB2NUMC10 |
NUMC |
| 420 | DB2CXREOP |
Total Number of Times Reoptimization Occurs | DB2NUMC10 |
NUMC |
| 421 | DB2CXREPO1 |
Parallel groups with reformulated access path (Sysplex conf) | DB2NUMC10 |
NUMC |
| 422 | DB2CXREPO2 |
Parallel groups with reformulated access path (buffer pool) | DB2NUMC10 |
NUMC |
| 423 | DB2CXREVOK |
Number of REVOKE statements executed | DB2NUMC10 |
NUMC |
| 424 | DB2CXROIID |
Direct row access attempted, but reverted to using index | DB2NUMC10 |
NUMC |
| 425 | DB2CXROIMA |
Number of times DB2 used dir. row access to locate a record | DB2NUMC10 |
NUMC |
| 426 | DB2CXROITS |
Direct row access attempted, reverted to tablespace scan | DB2NUMC10 |
NUMC |
| 427 | DB2CXROWTR |
Number of times a row trigger is activated | DB2NUMC10 |
NUMC |
| 428 | DB2CXSELEC |
Number of SELECT statements executed | DB2NUMC10 |
NUMC |
| 429 | DB2CXSETCD |
Number of SET CURRENT DEGREE statements executed | DB2NUMC10 |
NUMC |
| 430 | DB2CXSETCO |
Number of SET CONNECTION statements executed | DB2NUMC10 |
NUMC |
| 431 | DB2CXSETCR |
Number of SET CURRENT RULES statements executed | DB2NUMC10 |
NUMC |
| 432 | DB2CXSETHV |
Number of SET HOST VARIABLE statements executed | DB2NUMC10 |
NUMC |
| 433 | DB2CXSETPT |
Number of SQL SET CURRENT PATH statements | DB2NUMC10 |
NUMC |
| 434 | DB2CXSETSQ |
Number of SET CURRENT SQLID statements executed | DB2NUMC10 |
NUMC |
| 435 | DB2CXSTDEX |
MAXKEEPD parameter exceeded | DB2NUMC10 |
NUMC |
| 436 | DB2CXSTFND |
Number of Times that DB2 Found the Statement in the Cache | DB2NUMC10 |
NUMC |
| 437 | DB2CXSTINV |
Statement invalidated | DB2NUMC10 |
NUMC |
| 438 | DB2CXSTIRP |
Number of implicit prepares | DB2NUMC10 |
NUMC |
| 439 | DB2CXSTLOB |
Maximum storage used for LOB values (MB) | DB2NUMC10 |
NUMC |
| 440 | DB2CXSTNFD |
Number of times statement could not be found in cache | DB2NUMC10 |
NUMC |
| 441 | DB2CXSTNPR |
Number of avoided prepares | DB2NUMC10 |
NUMC |
| 442 | DB2CXSTTRG |
Number of times a statement trigger is activated | DB2NUMC10 |
NUMC |
| 443 | DB2CXTRGER |
No. of times an SQL error occurred during a triggered action | DB2NUMC10 |
NUMC |
| 444 | DB2CXUPDTE |
Number of UPDATE statements executed | DB2NUMC10 |
NUMC |
| 445 | DB2DASD_USAGE |
Actual DASD usage (in KB) of dataset | INT4 | |
| 446 | DB2DASD_USE_SUM |
Actual DASD usage (in KB) of TS (sum of partitions) | FLTP |
FLTP |
| 447 | DB2DATE |
Field type date, YYYYMMDD | DB2DATE |
DATS |
| 448 | DB2DATIDXD |
Date and time of index size analysis (YYYYMMDDhhmm) | CHAR12 |
CHAR |
| 449 | DB2DATSIZD |
Date and time of size analysis (format: YYYYMMDDhhmm) | CHAR12 |
CHAR |
| 450 | DB2DATTIM |
DB2 for OS/390: Short form of timestamp (YYYYMMDDhhmmss) | CHAR14 |
CHAR |
| 451 | DB2DAYS |
Number of days since last invocation | DB2DAYS |
INT4 |
| 452 | DB2DB02CARDF |
cardf | DEC | |
| 453 | DB2DB02DAT |
Date of last refresh of transaction DB02 | DATUM |
DATS |
| 454 | DB2DB02TIM |
Time of the last refresh of transaction DB02 | TIME |
TIMS |
| 455 | DB2DBID |
DBID | INT2 |
INT2 |
| 456 | DB2DBIDC |
DBID | DB2INT4 |
INT4 |
| 457 | DB2DBNAM1 |
Name of database | DB2DBNAME |
CHAR |
| 458 | DB2DBNAME |
Database name | D2DBNAME |
CHAR |
| 459 | DB2DBNAML |
DB2 DB Name | CHAR | |
| 460 | DB2DBOWNER |
The name of the DB2 database | DB2CHAR16 |
CHAR |
| 461 | DB2DBOWNSH |
The name of the DB2 database | DB2CHAR08 |
CHAR |
| 462 | DB2DBPCAST |
CASTOUT attribute | CHAR6 |
CHAR |
| 463 | DB2DBPDWQT |
The deferred write threshold for the virtual buffer pool | DB2INT4 |
INT4 |
| 464 | DB2DBPHPSH |
The sequential steal threshold for the hiperpool | INT4 | |
| 465 | DB2DBPHPSZ |
The size of the hiperpool | INT4 | |
| 466 | DB2DBPNM |
Name of buffer pool | CHAR8 |
CHAR |
| 467 | DB2DBPPGST |
Page stealing algorithm to be used for the virtual BP | DB2CHAR04 |
CHAR |
| 468 | DB2DBPPSQT |
Parallel I/O sequential steal threshold for virtual BP | DB2INT4 |
INT4 |
| 469 | DB2DBPVDQB |
Pool vertical write threshold in number of buffers | DB2INT2V |
INT2 |
| 470 | DB2DBPVDQC |
Pool vertical write threshold in number of buffers | NUMC | |
| 471 | DB2DBPVDQT |
The vertical deferred write threshold for the virtual BP | INT4 | |
| 472 | DB2DBPVPSH |
The sequential steal threshold for the virtual buffer pool | DB2INT4 |
INT4 |
| 473 | DB2DBPVPSZ |
The size of the virtual buffer pool | INT4 | |
| 474 | DB2DBPVPTY |
Type of virtual buffer pool | DB2CHAR01 |
CHAR |
| 475 | DB2DBPVSZ |
The size of the virtual buffer pool | INT4 | |
| 476 | DB2DBPXSQT |
Assisting parallel sequential threshold | DB2INT4 |
INT4 |
| 477 | DB2DBTRCS |
Status IFI DB Trace | DB2INT4 |
INT4 |
| 478 | DB2DBTRCSL |
Length of IFI DB Status Text | DB2SINT |
INT2 |
| 479 | DB2DBTRCST |
Status of IFI DB Trace | DB2CHAR60 |
CHAR |
| 480 | DB2DDFNAME |
Used for Saving content of Special Register Current Server | CHAR | |
| 481 | DB2DDFSRBT |
SRB time for DDF address space | DB2CHAR16 |
CHAR |
| 482 | DB2DDFTCBT |
TCB time for DDF address space | DB2CHAR16 |
CHAR |
| 483 | DB2DDFTOTT |
Total time for DDF address space | DB2CHAR16 |
CHAR |
| 484 | DB2DEC10 |
Field Type DEC, Length 10 | DEC_10 |
DEC |
| 485 | DB2DEC10V |
Field Type DEC, Length 10 | DB2DEC10V |
DEC |
| 486 | DB2DEC19V |
dec 19 with sign | DB2DEC19V |
DEC |
| 487 | DB2DECISION |
decision (including yes/no/no matter what) | DB2DECISION |
CHAR |
| 488 | DB2DELCNT |
DB2 for OS/390: Number of deleted database | DB2NUMC10 |
NUMC |
| 489 | DB2DESCH |
IFI DB Trace: Description | DB2CHAR15 |
CHAR |
| 490 | DB2DESCR |
(field) description | CHAR | |
| 491 | DB2DESCRL |
(field) long description | CHAR | |
| 492 | DB2DESCRS |
(field) description | CHAR | |
| 493 | DB2DIPROGN |
The program name (package ID or DBRM name) | DB2CHAR10 |
CHAR |
| 494 | DB2DISCDSN |
Dataset allocated to the SYSDISC DDNAME | DB2DDN |
CHAR |
| 495 | DB2DISCSPC |
Primary space allocation for the SYSDISC dataset (cyl.) | DB2DDPQTYC |
INT2 |
| 496 | DB2DISDEVT |
Device on which the SYSDISC dataset resides | DB2DEVT |
CHAR |
| 497 | DB2DISRBT |
SRB time for IRLM | DB2CHAR16 |
CHAR |
| 498 | DB2DISTNUC |
Precompiler statement number | DB2NUMC10 |
NUMC |
| 499 | DB2DISTNUM |
Precompiler statement number | DB2SINT |
INT2 |
| 500 | DB2DITCBT |
TCB time for IRLM | DB2CHAR16 |
CHAR |
