SMF 100 fields, IFCID 1
Name | (Filter) | Tag | CEF Name | Description |
|---|---|---|---|---|
QWSAEJST | QWSAEJST | Job step timer value for address space | ||
QWSAASID | (Integer) | QWSAASID | Asid of the address space | |
QWSAASCB | (Integer) | QWSAASCB | Ascb token | |
QWSAPSRB | QWSAPSRB | Preemptable srb timer value for address space not including | ||
QWSAPSRB_zIIP | QWSAPSRB_zIIP | PREEMPTABLE SRB TIMER VALUE CONSUMED ON AN IBM zIIP FOR | ||
QWSAMCPU | QWSAMCPU | No comments available in Macro | ||
QWSAIIPT | QWSAIIPT | CPU time for I/O interrupt processing for the address | ||
QWSAEND | (EGNX) | QWSAEND | No comments available in Macro | |
QWSBNM | (EGNX) | QWSBNM | name of the external or internal destination following are | |
QWSBSTAT | (Integer) | QWSBSTAT | statistic counters | |
QWSBWSEQ | (Integer) | QWSBWSEQ | No comments available in Macro | |
QWSBSRSW | (Integer) | QWSBSRSW | No comments available in Macro | |
QWSBSRNW | (Integer) | QWSBSRNW | No comments available in Macro | |
QWSBSBUF | (Integer) | QWSBSBUF | No comments available in Macro | |
QWSBSACT | (Integer) | QWSBSACT | No comments available in Macro | |
QWSBSRNA | (Integer) | QWSBSRNA | No comments available in Macro | |
QWSBSWF | (Integer) | QWSBSWF | No comments available in Macro | |
QWSBOTH | (Integer) | QWSBOTH | No comments available in Macro | |
QWSBOTH1 | QWSBOTH1 | No comments available in Macro | ||
QWSBOTH2 | QWSBOTH2 | No comments available in Macro | ||
QWSBOTH3 | QWSBOTH3 | No comments available in Macro | ||
QWSBOTH4 | QWSBOTH4 | No comments available in Macro | ||
QWSBEND | (EGNX) | QWSBEND | No comments available in Macro | |
QWSCIID | (Integer) | QWSCIID | Ifcid | |
QWSCSTAT | (Integer) | QWSCSTAT | Statistics | |
QWSCSRND | (Integer) | QWSCSRND | No comments available in Macro | |
QWSCSBNA | (Integer) | QWSCSBNA | No comments available in Macro | |
QWSCSCF | (Integer) | QWSCSCF | No comments available in Macro | |
QWSCOTH1 | QWSCOTH1 | No comments available in Macro | ||
QWSCOTH2 | QWSCOTH2 | No comments available in Macro | ||
QWSCEND | (EGNX) | QWSCEND | No comments available in Macro | |
Q3STIDEN | (Integer) | Q3STIDEN | Successful dsn3iden requests | |
Q3STSIGN | (Integer) | Q3STSIGN | Successful dsn3sign requests | |
Q3STCTHD | (Integer) | Q3STCTHD | Successful dsn3cthd requests | |
Q3STTERM | (Integer) | Q3STTERM | Successful dsn3term requests | |
Q3STRIUR | (Integer) | Q3STRIUR | Successful dsn3riur requests | |
Q3STPREP | (Integer) | Q3STPREP | Successful dsn3prep requests | |
Q3STCOMM | (Integer) | Q3STCOMM | Successful dsn3comm requests | |
Q3STABRT | (Integer) | Q3STABRT | Successful dsn3abrt requests | |
Q3STSYNC | (Integer) | Q3STSYNC | Successful dsn3sync requests | |
Q3STEXIT | (Integer) | Q3STEXIT | Successful dsn3exit requests | |
Q3STINDT | (Integer) | Q3STINDT | Total number of agents having gone in-doubt | |
Q3STMEOT | (Integer) | Q3STMEOT | Ssam eot's | |
Q3STMEOM | (Integer) | Q3STMEOM | Ssam eom's | |
Q3STSSSI | (Integer) | Q3STSSSI | Total number of ssi calls processed No comments available in Macrosss | |
Q3STCTHW | (Integer) | Q3STCTHW | Number of dsn3cthd which waited | |
Q3STRDON | (Integer) | Q3STRDON | Number of read only commits | |
Q3STHWIB | (Integer) | Q3STHWIB | High water mark for IDBACK threads | |
Q3STHWIF | (Integer) | Q3STHWIF | High water mark for IDFORE threads | |
Q9STCTR0 | (Integer) | Q9STCTR0 | Counter cmd=-display database | |
Q9STCTR1 | (Integer) | Q9STCTR1 | Counter cmd=-display thread | |
Q9STCTR2 | (Integer) | Q9STCTR2 | Counter cmd=-display utility | |
Q9STCTR3 | (Integer) | Q9STCTR3 | Counter cmd=-recover bsds | |
Q9STCTR4 | (Integer) | Q9STCTR4 | Counter cmd=-recover indoubt | |
Q9STCTR5 | (Integer) | StartDatabaseCmdCnt | Counter cmd=-start database | |
Q9STCTR6 | (Integer) | Q9STCTR6 | Counter cmd=-start trace | |
Q9STCTR7 | (Integer) | StartDB2SubsysCmdCnt | Counter cmd=-start subsystem | |
Q9STCTR8 | (Integer) | StopDatabaseCmdCnt | Counter cmd=-stop database | |
Q9STCTR9 | (Integer) | Q9STCTR9 | Counter cmd=-stop trace | |
Q9STCTRA | (Integer) | StopDB2SubsysCmdCnt | Counter cmd=-stop subsystem | |
Q9STCTRB | (Integer) | Q9STCTRB | Counter cmd=-term utility | |
Q9STCTRC | (Integer) | Q9STCTRC | Counter cmd=-dis trace | |
Q9STCTRD | (Integer) | Q9STCTRD | Counter cmd=-reset genericlu | |
Q9STEROR | (Integer) | Q9STEROR | Counter unrecognized command | |
Q9STCTRE | (Integer) | Q9STCTRE | Counter cmd=-start rlimit | |
Q9STCTRF | (Integer) | Q9STCTRF | Counter cmd=-stop rlimit | |
Q9STCTRG | (Integer) | Q9STCTRG | Counter cmd=-display rlimit | |
Q9STCTRH | (Integer) | Q9STCTRH | Counter cmd=-modify trace | |
Q9STCTRI | (Integer) | Q9STCTRI | Counter cmd=-start ddf | |
Q9STCTRJ | (Integer) | Q9STCTRJ | Counter cmd=-stop ddf | |
Q9STCTRK | (Integer) | Q9STCTRK | Counter cmd=-cancel(ddf | |
Q9STCTRL | (Integer) | Q9STCTRL | Counter cmd=-display location | |
Q9STCTRM | (Integer) | Q9STCTRM | Counter cmd=-archive log | |
Q9STCTRN | (Integer) | Q9STCTRN | Counter cmd=-alter bufferpool | |
Q9STCTRO | (Integer) | Q9STCTRO | Counter cmd=-display bufferpool | |
Q9STCTRP | (Integer) | Q9STCTRP | Counter cmd=-set archive | |
Q9STCTRQ | (Integer) | Q9STCTRQ | Counter cmd=-display archive | |
Q9STCTRR | (Integer) | Q9STCTRR | Counter cmd=-reset indoubt | |
Q9STCTRS | (Integer) | Q9STCTRS | Counter cmd=-alter gbpool | |
Q9STCTRT | (Integer) | Q9STCTRT | Counter cmd=-display gbpool | |
Q9STCTRU | (Integer) | Q9STCTRU | Counter cmd=-display procedure | |
Q9STCTRV | (Integer) | Q9STCTRV | Counter cmd=-start procedure | |
Q9STCTRW | (Integer) | Q9STCTRW | Counter cmd=-stop procedure | |
Q9STCTRX | (Integer) | Q9STCTRX | Counter cmd=-dis group | |
Q9STCTRY | (Integer) | Q9STCTRY | Counter cmd=-alter utility | |
Q9STCTRZ | (Integer) | Q9STCTRZ | Counter cmd=-display function | |
Q9STCTX0 | (Integer) | Q9STCTX0 | Counter cmd=-start function | |
Q9STCTX1 | (Integer) | Q9STCTX1 | Counter cmd=-stop function | |
Q9STCTX2 | (Integer) | Q9STCTX2 | Counter cmd=-set log | |
Q9STCTX3 | (Integer) | Q9STCTX3 | Counter cmd=-display log | |
Q9STCTX4 | (Integer) | Q9STCTX4 | Counter cmd=-set sysparm | |
Q9STCTX5 | (Integer) | Q9STCTX5 | Counter cmd=-display ddf | |
Q9STCTAD | (Integer) | Q9STCTAD | Counter cmd=-access database | |
Q9STCTSS | (Integer) | Q9STCTSS | Counter cmd=-start profile | |
Q9STCTST | (Integer) | Q9STCTST | Counter cmd=-stop profile | |
Q9STCTSD | (Integer) | Q9STCTSD | Counter cmd=-display profile | |
Q9STCTDA | (Integer) | Q9STCTDA | Counter cmd=-display accel | |
Q9STCTSA | (Integer) | Q9STCTSA | Counter cmd=-start accel | |
Q9STCTXA | (Integer) | Q9STCTXA | Counter cmd=-stop accel | |
Q9STCDMD | (Integer) | Q9STCDMD | Counter cmd=-modify ddf | |
Q9STCTEN | (Integer) | Q9STCTEN | Counter cmd=-activate funct lev | |
Q9STCTDQ | (Integer) | Q9STCTDQ | Counter cmd=-dis dynquerycapture | |
Q9STCTSQ | (Integer) | Q9STCTSQ | Counter cmd=-start dynquerycapture | |
Q9STCTXQ | (Integer) | Q9STCTXQ | Counter cmd=-stop dynquerycapture | |
Q9STCTDM | (Integer) | Q9STCTDM | Counter cmd=-dis ml | |
Q9STCTSM | (Integer) | Q9STCTSM | Counter cmd=-start ml | |
Q9STCTPM | (Integer) | Q9STCTPM | Counter cmd=-stop ml | |
Q9STCTDR | (Integer) | Q9STCTDR | Counter cmd=-display service | |
Q9STCTSR | (Integer) | Q9STCTSR | Counter cmd=-start service | |
Q9STCTPR | (Integer) | Q9STCTPR | Counter cmd=-stop service | |
Q9STCTS1 | (Integer) | Q9STCTS1 | Counter cmd=-start cdds | |
Q9STCTS2 | (Integer) | Q9STCTS2 | Counter cmd=-stop cdds | |
Q9STCTBL | (Integer) | Q9STCTBL | Counter cmd=-display blockers | |
Q9STCTX6 | (Integer) | Q9STCTX6 | Counter cmd=-run mlutil | |
Q9STCTX7 | (Integer) | Q9STCTX7 | Counter cmd=-display stats | |
QWSDRINV | (Integer) | QWSDRINV | reason why statistics was invoked 04 = db2 start up 08 = | |
QWSDSCA | (Integer) | QWSDSCA | count of ifi abends | |
QWSDSCU | (Integer) | QWSDSCU | count of ifi unrecognized functions | |
QWSDSCCO | (Integer) | QWSDSCCO | count of ifi command requests | |
QWSDSCRA | (Integer) | QWSDSCRA | count of ifi reada requests | |
QWSDSCRS | (Integer) | QWSDSCRS | count of ifi reads requests | |
QWSDSCWR | (Integer) | QWSDSCWR | count of ifi write requests | |
QWSDCDCS | (Integer) | QWSDCDCS | ifi data capture statistics | |
QWSDCDLC | (Integer) | QWSDCDLC | number of log records captured for which data | |
QWSDCDLR | (Integer) | QWSDCDLR | number of data capture log reads performed. | |
QWSDCDDR | (Integer) | QWSDCDDR | number of data capture data rows returned. | |
QWSDCDDD | (Integer) | QWSDCDDD | number of data capture data descriptions returned. | |
QWSDCDMB | (Integer) | QWSDCDMB | number of data capture describes performed. | |
QWSDCDTB | (Integer) | QWSDCDTB | number of data capture tables for which data capture | |
QWSDARTH | (Integer) | QWSDARTH | Number of rollup accounting records written due to | |
QWSDARSG | (Integer) | QWSDARSG | Number of rollup accounting records written due to | |
QWSDARST | (Integer) | QWSDARST | Number of rollup accounting records written due to | |
QWSDARIR | (Integer) | QWSDARIR | Number of records failing to qualify for accounting | |
QWSDLRG | QWSDLRG | High used RBA address of log | ||
QWSDVTB | (EGNX) | QWSDVTB | No comments available in Macro | |
QWSDEND | (EGNX) | QWSDEND | High used RBA address of log | |
QVLSLC01 | (Integer) | QVLSLC01 | Infrequently used | |
QVLSLC02 | (Integer) | QVLSLC02 | Global authorization cache | |
QVLSLC03 | (Integer) | QVLSLC03 | DDF disconnect | |
QVLSLC04 | (Integer) | QVLSLC04 | SYSSTRING cache | |
QVLSLC05 | (Integer) | QVLSLC05 | IRLM data sharing exits or RLF | |
QVLSLC06 | (Integer) | QVLSLC06 | Data sharing index split | |
QVLSLC07 | (Integer) | QVLSLC07 | Index lotch and OBD allocation | |
QVLSLC08 | (Integer) | QVLSLC08 | Query parallelism | |
QVLSLC09 | (Integer) | QVLSLC09 | Utilities or stored procedure URIDs | |
QVLSLC10 | (Integer) | QVLSLC10 | Allied agent chain or sequence descriptors | |
QVLSLC11 | (Integer) | QVLSLC11 | DGTT allocation | |
QVLSLC12 | (Integer) | QVLSLC12 | Global transaction ID table | |
QVLSLC13 | (Integer) | QVLSLC13 | Pageset operations | |
QVLSLC14 | (Integer) | QVLSLC14 | Bufferpool LRU | |
QVLSLC15 | (Integer) | QVLSLC15 | archive log mode(quiesce | |
QVLSLC16 | (Integer) | QVLSLC16 | UR chain | |
QVLSLC17 | (Integer) | QVLSLC17 | RURE chain | |
QVLSLC18 | (Integer) | QVLSLC18 | DDF resynch list | |
QVLSLC19 | (Integer) | QVLSLC19 | Log write | |
QVLSLC20 | (Integer) | QVLSLC20 | System checkpoint | |
QVLSLC21 | (Integer) | QVLSLC21 | Accounting rollup | |
QVLSLC22 | (Integer) | QVLSLC22 | Internal checkpoint | |
QVLSLC23 | (Integer) | QVLSLC23 | Buffer manager | |
QVLSLC24 | (Integer) | QVLSLC24 | EDM pool or prefetch | |
QVLSLC25 | (Integer) | QVLSLC25 | Workfile allocation | |
QVLSLC26 | (Integer) | QVLSLC26 | Dynamic statement cache | |
QVLSLC27 | (Integer) | QVLSLC27 | Stored procedures or authorization cache | |
QVLSLC28 | (Integer) | QVLSLC28 | Stored procedures or authorization cache | |
QVLSLC29 | (Integer) | QVLSLC29 | Field procs and DDF transaction manager | |
QVLSLC30 | (Integer) | QVLSLC30 | Agent services | |
QVLSLC31 | (Integer) | QVLSLC31 | Package authorization cache or DPS common | |
QVLSLC32 | (Integer) | QVLSLC32 | TCPACE serialization | |
QVLSLC254 | (Integer) | QVLSLC254 | Index lotch | |
QVLSLC62 | (Integer) | QVLSLC62 | Storage manager | |
QVLSLC63 | (Integer) | QVLSLC63 | Storage manager | |
QVASSUSP | (Integer) | QVASSUSP | No comments available in Macro | |
QVASXSUS | (Integer) | QVASXSUS | No comments available in Macro | |
QVASXSUT | (Integer) | QVASXSUT | No comments available in Macro | |
QVASXAUS | (Integer) | QVASXAUS | No comments available in Macro | |
QVASXAUT | (Integer) | QVASXAUT | No comments available in Macro | |
QVASXSRS | (Integer) | QVASXSRS | No comments available in Macro | |
QVASXSRT | (Integer) | QVASXSRT | No comments available in Macro | |
QVASADUR | (Integer) | QVASADUR | No comments available in Macro | |
QVASADDL | (Integer) | QVASADDL | No comments available in Macro | |
QVASADIR | (Integer) | QVASADIR | No comments available in Macro | |
QVASCBOS | (Integer) | QVASCBOS | No comments available in Macro | |
QVASCBOF | (Integer) | QVASCBOF | No comments available in Macro | |
QVASMBOS | (Integer) | QVASMBOS | No comments available in Macro | |
QVASMBOF | (Integer) | QVASMBOF | No comments available in Macro | |
QVASBRPT | QVASBRPT | No comments available in Macro | ||
QVASBRP | QVASBRP | No comments available in Macro | ||
QVASACEB | QVASACEB | No comments available in Macro | ||
QVASACEF | QVASACEF | No comments available in Macro | ||
QSST | QSST | QSST header | ||
QSSTHEAD | (Integer) | QSSTHEAD | QSST header | |
QSSTID | (EGNX) | QSSTID | id | |
QSSTLEN | (Integer) | QSSTLEN | Length | |
QSSTDESC | (EGNX) | QSSTDESC | Eye-catchers | |
QSSTDATA | (Integer) | QSSTDATA | Serviceability counters | |
QSSTGPLF | (Integer) | QSSTGPLF | No comments available in Macro | |
QSSTFPLF | (Integer) | QSSTFPLF | No comments available in Macro | |
QSSTFREF | (Integer) | QSSTFREF | No comments available in Macro | |
QSSTEXPF | (Integer) | QSSTEXPF | No comments available in Macro | |
QSSTCONF | (Integer) | QSSTCONF | No comments available in Macro | |
QSSTGPLV | (Integer) | QSSTGPLV | No comments available in Macro | |
QSSTFPLV | (Integer) | QSSTFPLV | No comments available in Macro | |
QSSTFREV | (Integer) | QSSTFREV | No comments available in Macro | |
QSSTEXPV | (Integer) | QSSTEXPV | No comments available in Macro | |
QSSTCONV | (Integer) | QSSTCONV | No comments available in Macro | |
QSSTGETM | (Integer) | QSSTGETM | No comments available in Macro | |
QSSTFREM | (Integer) | QSSTFREM | No comments available in Macro | |
QSSTRCNZ | (Integer) | QSSTRCNZ | No comments available in Macro | |
QSSTCONT | (Integer) | QSSTCONT | No comments available in Macro | |
QSSTCRIT | (Integer) | QSSTCRIT | No comments available in Macro | |
QSSTABND | (Integer) | QSSTABND | No comments available in Macro | |
QSST_SGETM | QSST_SGETM | No comments available in Macro | ||
QSST_SGETR | QSST_SGETR | No comments available in Macro | ||
QSST_SGETEXT | QSST_SGETEXT | No comments available in Macro | ||
QSST_SFREEM | QSST_SFREEM | No comments available in Macro | ||
QSST_SFREER | QSST_SFREER | No comments available in Macro | ||
QSST_D64POST | QSST_D64POST | No comments available in Macro | ||
QSST_A64POST | QSST_A64POST | No comments available in Macro | ||
QSST_A64WAIT | QSST_A64WAIT | No comments available in Macro | ||
QSST_M64DISNUM | QSST_M64DISNUM | No comments available in Macro | ||
QSST_M64DISPGS | QSST_M64DISPGS | No comments available in Macro | ||
QSST_SGETR64 | QSST_SGETR64 | No comments available in Macro | ||
QSST_SGETEXT64 | QSST_SGETEXT64 | No comments available in Macro | ||
QSST_SGETDEXT64 | QSST_SGETDEXT64 | No comments available in Macro | ||
QSST_SFREER64 | QSST_SFREER64 | No comments available in Macro | ||
QSST_SFREEDEXT64 | QSST_SFREEDEXT64 | No comments available in Macro | ||
QSST_DISCARDMODE64 | QSST_DISCARDMODE64 | No comments available in Macro | ||
QSST_RSMAX_WARN | QSST_RSMAX_WARN | No comments available in Macro | ||
QSST_P64PCTRCT | QSST_P64PCTRCT | No comments available in Macro | ||
QSST_P64DISNO | QSST_P64DISNO | No comments available in Macro | ||
QSST_P64DISPGS | QSST_P64DISPGS | No comments available in Macro | ||
QSST_CNTRCT_NUM | QSST_CNTRCT_NUM | Number of 31-bit agent local pools ! contracted | ||
QSST_P64DISYES | QSST_P64DISYES | No comments available in Macro | ||
QSSTEND | (Mapped Integer) | QSSTEND | QSST end | |
QLSTVRSN | (EGNX) | QLSTVRSN | When set greater than or equal to: '000001' | |
QLSTLOCN | (EGNX) | QLSTLOCN | Location name of the 'remote' site with which the information is associated | |
QLSTCNVS | QLSTCNVS | Number of connections that were initiated from this site to | ||
QLSTCNVT | QLSTCNVT | Number of connections that were deallocated from this site to | ||
QLSTMSGS | QLSTMSGS | Number of messages sent to the remote site. | ||
QLSTMSGR | QLSTMSGR | Number of messages received from the remote site. | ||
QLSTSQLS | QLSTSQLS | Number of sql statements sent to the remote site. | ||
QLSTROWS | QLSTROWS | Number of rows of data sent to the remote site (includes the | ||
QLSTROWR | QLSTROWR | Number of rows of data retrieved from the remote site (this | ||
QLSTBTBF | QLSTBTBF | Number of blocks transmitted using block fetch No comments available in Macroerver site | ||
QLSTBRBF | QLSTBRBF | Number of blocks received using block fetch (requester site | ||
QLSTCOMS | QLSTCOMS | Number of commit requests sent to the server No comments available in Macroingle-phase | ||
QLSTABRS | QLSTABRS | Number of abort requests sent to the server No comments available in Macroingle-phase | ||
QLSTINDT | QLSTINDT | Number of threads that became indoubt with the remote | ||
QLSTPRLV | (EGNX) | QLSTPRLV | Product Level if known. FIELDS QLSTNREST TO QLSTNTHDC | |
QLSTNREST | QLSTNREST | Rest service requests | ||
QLSTNSSR | QLSTNSSR | Sets of special registers via profile | ||
QLSTNSGV | QLSTNSGV | Sets of global variables via profile | ||
QLSTNWLB | QLSTNWLB | Sysplex workload balancing used | ||
QLSTNTLS | QLSTNTLS | Tls/ssl used | ||
QLSTNTRS | QLSTNTRS | Trusted context used | ||
QLSTNAES | QLSTNAES | Aes encryption used | ||
QLSTNXA | QLSTNXA | Xa global transaction used | ||
QLSTNENC | QLSTNENC | Drda encryption used | ||
QLSTNPWD | QLSTNPWD | Uid/pwd used | ||
QLSTNKER | QLSTNKER | Kerberos used | ||
QLSTNMFA | QLSTNMFA | Mfa used | ||
QLSTNCCA | QLSTNCCA | Client certificates used | ||
QLSTFSEC | QLSTFSEC | Failed security authentications fields qlstncrsr to qlstspcmt | ||
QLSTHCRSR | QLSTHCRSR | With hold cursor not closed | ||
QLSTDGTT | QLSTDGTT | Dgtt not dropped | ||
QLSTKPDYN | QLSTKPDYN | Keepdynamic packages used | ||
QLSTHLOBLOC | QLSTHLOBLOC | Held lob locatorNo comments available in Macro | ||
QLSTSPCMT | QLSTSPCMT | Stored proc commit performed fields qlstcnvtc to qlstcnvtqw | ||
QLSTCNVTC | QLSTCNVTC | Condbat reached | ||
QLSTCNVTP | QLSTCNVTP | Profile exception | ||
QLSTCNVTQN | QLSTCNVTQN | Maxconqn reached | ||
QLSTCNVTQW | QLSTCNVTQW | Maxconqw reached fields qlstnthdpq to qlstnthdc contain | ||
QLSTNTHDPQ | QLSTNTHDPQ | Queued - profile exception | ||
QLSTNTHDPT | QLSTNTHDPT | Terminated - profile exception | ||
QLSTNTHDA | QLSTNTHDA | Abended | ||
QLSTNTHDC | QLSTNTHDC | Canceled qlstncnv to qlsththd inclusive are meaningful at | ||
QLSTCONV | QLSTCONV | Connections from location | ||
QLSTNCNV | (Integer) | QLSTNCNV | Current number of connections | |
QLSTTHRD | QLSTTHRD | Active threads (dbats | ||
QLSTNTHD | (Integer) | QLSTNTHD | Current num of active threads | |
QLSTNTPLH | QLSTNTPLH | Terminated - high performance dbat remained in pool longer | ||
QLSTNTILS | QLSTNTILS | Terminated - tcp socket closed due to connection loss | ||
QJSTID | (EGNX) | QJSTID | No comments available in Macro | |
QJSTLL | (Integer) | QJSTLL | Length of block | |
QJSTEID | (EGNX) | QJSTEID | Ebcdic eyecatcher | |
QJSTWRW | (Integer) | QJSTWRW | Write request count wait | |
QJSTWRNW | (Integer) | QJSTWRNW | Write request count nowait | |
QJSTWRF | (Integer) | QJSTWRF | Write request count force | |
QJSTWTB | (Integer) | QJSTWTB | Wait count due to unavailable active buffer | |
QJSTRBUF | (Integer) | QJSTRBUF | Log reads satisfied from output buffers | |
QJSTRACT | (Integer) | QJSTRACT | Reads satisfied from active log data set | |
QJSTRARH | (Integer) | QJSTRARH | Reads satisfied from archive log data set | |
QJSTTVC | (Integer) | QJSTTVC | Number of read accesses delayed due to tape volume | |
QJSTBSDS | (Integer) | QJSTBSDS | Total bsds access requests | |
QJSTBFFL | (Integer) | QJSTBFFL | Active log output control intervals created | |
QJSTBFWR | (Integer) | QJSTBFWR | Count of calls to write active log buffers | |
QJSTALR | (Integer) | QJSTALR | Archive log read allocations | |
QJSTALW | (Integer) | QJSTALW | Archive log write allocations | |
QJSTCIOF | (Integer) | QJSTCIOF | Count of control intervals offloaded | |
QJSTWUR | (Integer) | QJSTWUR | Number of read accesses delayed due to unavailable | |
QJSTLAMA | (Integer) | QJSTLAMA | Number of look-ahead tape volume mounts attempted. this field | |
QJSTLAMS | (Integer) | QJSTLAMS | Number of look-ahead tape volume mounts performed. | |
QJSTLSUS | (Integer) | QJSTLSUS | No comments available in Macro | |
QJSTCIWR | (Integer) | QJSTCIWR | Total number of log ci-s written. | |
QJSTSERW | (Integer) | QJSTSERW | Number of serial log write requests for ci re-writes when | |
QJSTTHRW | (Integer) | QJSTTHRW | Number of times a log write request was scheduled because the | |
QJSTBPAG | (Integer) | QJSTBPAG | Number of times a log-write buffer had to be paged-in before | |
QJSTSPNN | (Integer) | QJSTSPNN | No comments available in Macro | |
QJSTSPNI | QJSTSPNI | No comments available in Macro | ||
QJSTCL16 | (EGNX) | QJSTCL16 | No comments available in Macro | |
QJSTCLID | (Integer) | QJSTCLID | No comments available in Macro | |
QJSTCL2 | (EGNX) | QJSTCL2 | No comments available in Macro | |
QJSTCLSN | (EGNX) | QJSTCLSN | No comments available in Macro | |
QJSTDPXT | QJSTDPXT | Total time (in microseconds | ||
QJSTDPXN | (Integer) | QJSTDPXN | Total number of suspends xes suspended the log writer to | |
QJSTCDDS | (Integer) | QJSTCDDS | Total CDDS access requests | |
QJSTSYCW | (Integer) | QJSTSYCW | Total number of zhyperlinklog write I/O requests. | |
QJSTSYCF | (Integer) | QJSTSYCF | Total number of zhyperlinklog write I/O requests which failed | |
QJSTAVAL | (EGNX) | QJSTAVAL | No comments available in Macro | |
QJSTEND | (Integer) | QJSTEND | No comments available in Macro | |
QDSTQDBT | (Integer) | QDSTQDBT | number of times that a dbat or connection was queued | |
QDSTCSTR | (Integer) | QDSTCSTR | number of cold start connections with all remote | |
QDSTWSTR | (Integer) | QDSTWSTR | number of warm start connections with all remote | |
QDSTRSAT | (Integer) | QDSTRSAT | number of resynchronization connections attempted | |
QDSTRSSU | (Integer) | QDSTRSSU | number of resynchronization connections that | |
QDSTQCRT | (Integer) | QDSTQCRT | number of connections that were rejected due to | |
QDSTQCIT | (Integer) | QDSTQCIT | THE CURRENT NUMBER OF TYPE 1 INACTIVE DBATs | |
QDSTQMIT | (Integer) | QDSTQMIT | THE MAXIMUM NUMBER OF TYPE 1 INACTIVE DBATs THAT | |
QDSTCNAT | (Integer) | QDSTCNAT | CURRENT NUMBER OF ACTIVE AND DISCONNECTED (POOLED | |
QDSTHWAT | (Integer) | QDSTHWAT | QDSTCNAT HIGH WATER MARK. MAXIMUM NUMBER OF ACTIVE | |
QDSTHWDT | (Integer) | QDSTHWDT | the maximum number of remote connections | |
QDSTNITC | (Integer) | QDSTNITC | number of threads/ connections | |
QDSTCIN2 | (Integer) | QDSTCIN2 | current number of (type 2 | |
QDSTMIN2 | (Integer) | QDSTMIN2 | qdstcin2 high water mark. maximum number of | |
QDSTQIN2 | (Integer) | QDSTQIN2 | number of receive requests on (type 2 | |
QDSTNQR2 | (Integer) | QDSTNQR2 | current number of (type 2 | |
QDSTMQR2 | (Integer) | QDSTMQR2 | qdstnqr2 high water mark. maximum number of (type 2 | |
QDSTNADS | (Integer) | QDSTNADS | current number of disconnected (pooled | |
QDSTMADS | (Integer) | QDSTMADS | qdstnads high water mark. maximum number of | |
QDSTNDBA | (Integer) | QDSTNDBA | The number of DBATs created since DDF was started. | |
QDSTPOOL | (Integer) | QDSTPOOL | number of requests that were satisfied by | |
QDSTNCQC | (Integer) | QDSTNCQC | Number of queued client connections which have had | |
QDSTNARD | (Integer) | QDSTNARD | current number of active dbats due to packages | |
QDSTMARD | (Integer) | QDSTMARD | maximum number of active dbats due to packages | |
QDSTNQMN | QDSTNQMN | Relative to QDSTNQR2 the minimum queued duration | ||
QDSTNQMX | QDSTNQMX | Relative to QDSTNQR2 the maximum queued duration | ||
QDSTNQAV | QDSTNQAV | Relative to QDSTNQR2 the average queued duration | ||
QDSTNCCW | (Integer) | QDSTNCCW | Number of queued client connections which have had | |
QDSTNLSC | (Integer) | QDSTNLSC | Number of ILOS cancels declined due to CPU | |
QDSTNAKD | (Integer) | QDSTNAKD | The current number of DBATS that are active due to | |
QDSTMAKD | (Integer) | QDSTMAKD | The maximum number of DBATS that are active due to | |
QDSTNDBT | (Integer) | QDSTNDBT | The number of DBATs terminated since DDF was | |
QDSTNTPL | (Integer) | QDSTNTPL | The number of DBATs terminated after remaining | |
QDSTNTRU | (Integer) | QDSTNTRU | The number of DBATs terminated after being | |
QDSTDBPQ | (Integer) | QDSTDBPQ | Current number of DBATs suspended due to profile | |
QDSTMDPQ | (Integer) | QDSTMDPQ | Maximum number of DBATs suspended due to profile | |
QDSTEND | (EGNX) | QDSTEND | Current number of DBATs suspended due to profile | |
QWOSLNCP | (Integer) | QWOSLNCP | No of cps on lpar | |
QWOSLPRU | (Integer) | QWOSLPRU | Cpu utilization lpar | |
QWOSDB2U | (Integer) | QWOSDB2U | Cpu utilization db2 subsys | |
QWOSMSTU | (Integer) | QWOSMSTU | Cpu utilization db2 mstr | |
QWOSDBMU | (Integer) | QWOSDBMU | Cpu utilization db2 dbm1 | |
QWOSLPIR | (Integer) | QWOSLPIR | Page-in rate lpar | |
QWOSDPIR | (Integer) | QWOSDPIR | Page-in rate db2 subsys | |
QWOSLRST | (Integer) | QWOSLRST | Real storage on lpar in mb | |
QWOSLRSF | (Integer) | QWOSLRSF | Free real storage lpar in mb | |
QWOSDRSU | (Integer) | QWOSDRSU | Used real storage db2 subsys in mb | |
QWOSLVST | (Integer) | QWOSLVST | Virtual storage lpar in mb | |
QWOSLVSF | (Integer) | QWOSLVSF | Free virtual storage lpar in mb | |
QWOSDVSU | (Integer) | QWOSDVSU | Used virtual storage db2 subsys in mb | |
QWOSLUIC | (Integer) | QWOSLUIC | Unreferenced interval count | |
QWOSFLG | (EGNX) | QWOSFLG | No comments available in Macro | |
QWOSFLG1 | (EGNX) | QWOSFLG1 | Flag if qwosreal valid | |
QWOSRCDE | (Integer) | QWOSRCDE | No comments available in Macro | |
QWOSRSNC | (Integer) | QWOSRSNC | No comments available in Macro | |
QWOSREAL | (Integer) | QWOSREAL | REAL STORAGE ON LPAR IN MB For z/OS v21 and above | |
QWOSEND | (EGNX) | QWOSEND | Flag if qwosreal valid |
Many of these descriptions are taken from one of the following sources:
DB2 Version 9.1 for z/OS Performance Monitoring and Tuning Guide © Copyright 1982, 2009 IBM Corporation; DB2 10 for z/OS SQL Reference © Copyright 1982, 2011 IBM Corporation; the IBM macro DSNA10.ADSNMACS(DSNDQWSP) © Copyright 1982, 2010 IBM Corporation; or z/OS Security Server RACF Data Areas © Copyright 1994, 2008 IBM Corporation.