Menu

SAP Table DB2QSYSW1

Table holding different DB2 IFI statistics values

The table DB2QSYSW1 (Table holding different DB2 IFI statistics values) is a standard table in SAP ERP. It belongs to the package STU3.

Technical Information

Table DB2QSYSW1
Short Text Table holding different DB2 IFI statistics values
Package STU3
Table Type Transparent Table

Fields for Table DB2QSYSW1

Field Name Key Description Data Element Type Length Check Table
MEMBNM DB2 member name in data sharing environment DB2MEMN CHAR 8
QWHSLEN Small integer DB2INT2AA INT2 5
QWHSTYP Field type raw, length 2, 1 byte DB2RAW01 RAW 1
QWHSRMID Field type raw, length 2, 1 byte DB2RAW01 RAW 1
QWHSIID Field Type INT, Length 4 DB2INT4 INT4 10
QWHSNSDA Field type raw, length 2, 1 byte DB2RAW01 RAW 1
QWHSRN Field type raw, length 2, 1 byte DB2RAW01 RAW 1
QWHSACE Field Type INT, Length 4 DB2INT4 INT4 10
QWHSSSID Field type char, length 4 DB2CHAR04 CHAR 4
QWHSSC1 Field Type INT, Length 4 DB2INT4 INT4 10
QWHSSC2 Field Type INT, Length 4 DB2INT4 INT4 10
QWHSISEQ Field Type INT, Length 4 DB2INT4 INT4 10
QWHSWSEQ Field Type INT, Length 4 DB2INT4 INT4 10
QWHSMTN Field type char, length 4, bit field DB2BIT04 CHAR 4
QWHSLOCN LOCAL LOCATION NAME CHAR 128
QWHSNID Field type char, length 8 DB2CHAR08 CHAR 8
QWHSLUNM Field type char, length 8 DB2CHAR08 CHAR 8
QWHSLUUV Field type char, length 6, bit field DB2BIT06 CHAR 6
QWHSLUCC Small integer DB2INT2AA INT2 5
Q3STIDEN Successful connections to DB2 from an allied address space DB23STIDEN INT4 10
Q3STSIGN Successful signon requests to identify a new user for CICS DB23STSIGN INT4 10
Q3STCTHD Number of successful create thread requests DB23STCTHD INT4 10
Q3STTERM Number of times threads were terminated successfully DB23STTERM INT4 10
Q3STRIUR Number of indoubts unit of recovery successfully resolved DB23STRIUR INT4 10
Q3STPREP Commit phase 1 requests in a two-phase environment DB23STPREP INT4 10
Q3STCOMM Commit phase 2 requests in a two-phase commit environment DB23STCOMM INT4 10
Q3STABRT Units of recovery were backed out successfully DB23STABRT INT4 10
Q3STSYNC Number of commits in a single-phase environment DB23STSYNC INT4 10
Q3STEXIT Field Type INT, Length 4 DB2INT4U INT4 10
Q3STINDT Number of indoubts units of recovery DB23STINDT INT4 10
Q3STMEOT Number of times non-DB2 tasks abended while connected to DB2 DB23STMEOT INT4 10
Q3STMEOM Non-DB2 address space deleted by MVS while connected to DB2 DB23STMEOM INT4 10
Q3STSSSI Field Type INT, Length 4 DB2INT4U INT4 10
Q3STCTHW Number of create thread requests queued DB23STCTHW INT4 10
Q3STRDON Number of read-only commits DB23STRDON INT4 10
Q9STCTR0 Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTR1 Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTR2 Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTR3 Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTR4 Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTR5 Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTR6 Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTR7 Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTR8 Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTR9 Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRA Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRB Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRC Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRD Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STEROR Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRE Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRF Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRG Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRH Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRI Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRJ Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRK Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRL Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRM Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRN Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRO Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRP Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRQ Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRR Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRS Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRT Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRU Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRV Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRW Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRX Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRY Field Type DEC, Length 10 DB2DEC10 DEC 10
Q9STCTRZ Number of -DISPLAY FUNCTION commands DB29STCTRZ DEC 10
Q9STCTX0 Number of -START FUNCTION commands DB29STCTX0 DEC 10
Q9STCTX1 Number of -STOP FUNCTION commands DB29STCTX1 DEC 10
Q9STCTX2 Number of -SET LOG commands DB29STCTX2 DEC 10
Q9STCTX3 Number of -DISPLAY LOG commands DB29STCTX3 DEC 10
Q9STIX01 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX02 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX03 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX04 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX05 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX06 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX07 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX08 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX09 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX10 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX11 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX12 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX13 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX14 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX15 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX16 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX17 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX18 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX19 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX20 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX21 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX22 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX23 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX24 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX25 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX26 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX27 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX28 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX29 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX30 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX31 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX32 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX33 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX34 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX35 Field type char, length 1 DB2CHAR01 CHAR 1
Q9STIX36 Field type char, length 1 DB2CHAR01 CHAR 1
QWSDCKPT Number of checkpoints DB2 has taken since startup DB2WSDCKPT INT4 10
QWSDRINV Field Type INT, Length 4 DB2INT4 INT4 10
QWSDLR Field type char, length 8 DB2CHAR08 CHAR 8
QWSDSCA Field Type INT, Length 4 DB2INT4 INT4 10
QWSDSCU Field Type INT, Length 4 DB2INT4 INT4 10
QWSDSCCO Field Type INT, Length 4 DB2INT4 INT4 10
QWSDSCRA Field Type INT, Length 4 DB2INT4 INT4 10
QWSDSCRS Field Type INT, Length 4 DB2INT4 INT4 10
QWSDSCWR Field Type INT, Length 4 DB2INT4 INT4 10
QWSDCDLC Field Type INT, Length 4 DB2INT4 INT4 10
QWSDCDLR Field Type INT, Length 4 DB2INT4 INT4 10
QWSDCDRR Field Type INT, Length 4 DB2INT4 INT4 10
QWSDCDDR Field Type INT, Length 4 DB2INT4 INT4 10
QWSDCDDD Field Type INT, Length 4 DB2INT4 INT4 10
QWSDCDMB Field Type INT, Length 4 DB2INT4 INT4 10
QWSDCDTB Field Type INT, Length 4 DB2INT4 INT4 10
QWSDARTH Rollup acc. records written due to rollup threshold exceeded DEC 16
QWSDARSG Rollup acc. records written due to rollup storage threshold DEC 16
QWSDARST Rollup acc. records written due to staleness threshold DEC 16
QWSDARIR Acc. records not qualifying for rollup due to NULL values DEC 16
QJSTID Field type char, length 2 DB2CHAR02 CHAR 2
QJSTLL Small integer (2 bytes) DB2SINT INT2 5
QJSTEID Field type char, length 4 DB2CHAR04 CHAR 4
QJSTWRW Field Type INT, Length 4 DB2INT4 INT4 10
QJSTWRNW Number of Write-No-Wait Requests DB2JSTWRNW INT4 10
QJSTWRNWD Number of Write-No-Wait Requests DB2JSTWRNWD DEC 10
QJSTWRF Field Type INT, Length 4 DB2INT4 INT4 10
QJSTWTB Unavailable output log buffers DB2JSTWTB INT4 10
QJSTRBUF Number of Log Reads Satisfied from Output Buffer DB2JSTRBUF INT4 10
QJSTRACT Number of Log Reads Satisfied from Active Log Data Set DB2JSTRACT INT4 10
QJSTRARH Number of Log Reads Satisfied from Archive Log Data Set DB2JSTRARH INT4 10
QJSTTVC Read accesses delayed due to tape volume contention DB2JSTTVC INT4 10
QJSTBSDS Number of BSDS Access Requests DB2JSTBSDS INT4 10
QJSTBFFL Number of Active Log Output Control Intervals Created DB2JSTBFFL INT4 10
QJSTBFWR Number of calls to the log write routine DB2JSTBFWR INT4 10
QJSTALR Number of archive log read allocations DB2JSTALR INT4 10
QJSTALW Number of archive log write allocations DB2JSTALW INT4 10
QJSTCIOF Count of Control Intervals Offloaded DB2JSTCIOF INT4 10
QJSTWUR Read accesses delayed due to unavailable resource DB2JSTWUR INT4 10
QJSTLAMA Check Tape Mounts Attempted DB2JSTLAMA INT4 10
QJSTLAMS Successful "look ahead" (tape volume) mounts attempted DB2JSTLAMS INT4 10
QTGSLPLK Number of lock requests for P-locks DB2TGSLPLK INT4 10
QTGSUPLK Number of unlock requests for P-locks DB2TGSUPLK INT4 10
QTGSCPLK Number of Change Requests for P-Locks DB2TGSCPLK INT4 10
QTGSLSLM Number of lock requests propagated to MVS XES synchronously DB2TGSLSLM INT4 10
QTGSUSLM Number of IRLM unlock requests propagated to MVS XES synch. DB2TGSUSLM INT4 10
QTGSIGLO Number of suspends caused by IRLM global resource contention DB2TGSIGLO INT4 10
QTGSSGLO Suspends caused by MVS XES global resource contention DB2TGSSGLO INT4 10
QTGSFLSE Number of suspends because of false contentions DB2TGSFLSE INT4 10
QTGSDRTA Incompatible retained lock DB2TGSDRTA INT4 10
QTGSNTFY Number of Notification Messages Sent to Other Members DB2TGSNTFY INT4 10
QTGSNTFR Number of Notification Messages Received from Other Members DB2TGSNTFR DEC 10
QTGSKIDS Number of resources propagated by IRLM to MVS XES async. DB2TGSKIDS DEC 10
QTGSPPPE Page Set/Partition P-Lock Negotiation DB2TGSPPPE DEC 10
QTGSPGPE Page P-Lock Negotiation DB2TGSPGPE DEC 10
QTGSOTPE Other P-Lock Negotiation DB2TGSOTPE DEC 10
QTGSCHNP P-Lock Change Request During P-Lock Negotiation DB2TGSCHNP DEC 10
QTGSPEMX Maximum Engines for P-Lock/Notify Exits DB2TGSPEMX DEC 10
QTGSPEQW Engines Unavailable for P-Lock/Notify Exits DB2TGSPEQW DEC 10
QTGSCSLM No. of Change Requests Propagated to MVS XES Synchronously DB2TGSCSLM INT4 10
QTGSFLMG False contention on z/OS image INT4 10