Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

DB2QSYSW2 SAP (DB2 statistics (part 2)) Structure details

Dictionary Type: Structure
Description: DB2 statistics (part 2)

ABAP Code to SELECT data from DB2QSYSW2
Related tables to DB2QSYSW2
Access table DB2QSYSW2

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Structure field list including key, data, relationships and ABAP select examples

DB2QSYSW2 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DB2 statistics (part 2)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DB2QSYSW2 TYPE DB2QSYSW2.

The DB2QSYSW2 table consists of various fields, each holding specific information or linking keys about DB2 statistics (part 2) data available in SAP. These include QXSELECT (Number of SELECT statements executed), QXINSRT (Number of INSERT statements executed), QXUPDTE (Number of UPDATE statements executed), QXDELET (Number of DELETE statements executed).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP DB2QSYSW2 structure fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MEMBNM	DB2 member name in data sharing environment	DB2MEMN	CHAR	8			DB2CHAR08
QXSELECT	Number of SELECT statements executed	DB2XSELECT	DEC	19			DB2DEC19V
QXINSRT	Number of INSERT statements executed	DB2XINSRT	DEC	19			DB2DEC19V
QXUPDTE	Number of UPDATE statements executed	DB2XUPDTE	DEC	19			DB2DEC19V
QXDELET	Number of DELETE statements executed	DB2XDELET	DEC	19			DB2DEC19V
QXDESC	Number of DESCRIBE statements executed	DB2XDESC	DEC	19			DB2DEC19V
QXPREP	Number of PREPARE statements executed	DB2XPREP	DEC	19			DB2DEC19V
QXOPEN	Number of OPEN CURSOR statements executed	DB2XOPEN	DEC	19			DB2DEC19V
QXCLOSE	Number of CLOSE CURSOR statements executed	DB2XCLOSE	DEC	19			DB2DEC19V
QXCRTAB	Number of CREATE TABLE statements executed	DB2XCRTAB	DEC	19			DB2DEC19V
QXCRINX	Number of CREATE INDEX statements executed	DB2XCRINX	DEC	19			DB2DEC19V
QXCTABS	Number of CREATE TABLE SPACE statements executed	DB2XCTABS	DEC	19			DB2DEC19V
QXCRSYN	Number of CREATE SYNONYM statements executed	DB2XCRSYN	DEC	19			DB2DEC19V
QXCRDAB	Number of CREATE DATABASE statements executed	DB2XCRDAB	DEC	19			DB2DEC19V
QXCRSTG	Number of CREATE STORAGE GROUP statements executed	DB2XCRSTG	DEC	19			DB2DEC19V
QXDEFVU	Number of CREATE VIEW statements executed	DB2XDEFVU	DEC	19			DB2DEC19V
QXDRPIX	Number of DROP INDEX statements executed	DB2XDRPIX	DEC	19			DB2DEC19V
QXDRPTA	Number of DROP TABLE statements executed	DB2XDRPTA	DEC	19			DB2DEC19V
QXDRPTS	Number of DROP TABLE SPACE statements executed	DB2XDRPTS	DEC	19			DB2DEC19V
QXDRPDB	Number of DROP DATABASE statements executed	DB2XDRPDB	DEC	19			DB2DEC19V
QXDRPSY	Number of DROP SYNONYM statements executed	DB2XDRPSY	DEC	19			DB2DEC19V
QXDRPST	Number of DROP STORAGE GROUP statements executed	DB2XDRPST	DEC	19			DB2DEC19V
QXDRPVU	Number of DROP VIEW statements executed	DB2XDRPVU	DEC	19			DB2DEC19V
QXALTST	Number of ALTER STORAGE GROUP statements executed	DB2XALTST	DEC	19			DB2DEC19V
QXFETCH	Number of FETCH statements executed	DB2XFETCH	DEC	19			DB2DEC19V
QXALTTS	Number of ALTER TABLE SPACE statements executed	DB2XALTTS	DEC	19			DB2DEC19V
QXALTTA	Number of ALTER TABLE statements executed	DB2XALTTA	DEC	19			DB2DEC19V
QXALTIX	Number of ALTER INDEX statements executed	DB2XALTIX	DEC	19			DB2DEC19V
QXCMTON	Number of COMMENT ON statements executed	DB2XCMTON	DEC	19			DB2DEC19V
QXLOCK	Number of LOCK TABLE statements executed	DB2XLOCK	DEC	19			DB2DEC19V
QXGRANT	Number of GRANT statements executed	DB2XGRANT	DEC	19			DB2DEC19V
QXREVOK	Number of REVOKE statements executed	DB2XREVOK	DEC	19			DB2DEC19V
QXINCRB	Number of INCREMENTAL BINDs executed	DB2XINCRB	DEC	19			DB2DEC19V
QXLABON	Number of LABEL ON statements executed	DB2XLABON	DEC	19			DB2DEC19V
QXSETSQL	Number of SET CURRENT SQLID statements executed	DB2XSETSQL	DEC	19			DB2DEC19V
QXCRALS	Number of CREATE ALIAS statements executed	DB2XCRALS	DEC	19			DB2DEC19V
QXDRPAL	Number of DROP ALIAS statements executed	DB2XDRPAL	DEC	19			DB2DEC19V
QXMIAP	Number of times RID list processing is used	DB2XMIAP	DEC	19			DB2DEC19V
QXNSMIAP	RID list processing failed - no storage	DB2XNSMIAP	DEC	19			DB2DEC19V
QXMRMIAP	RID list processing failed - limit exeeded	DB2XMRMIAP	DEC	19			DB2DEC19V
QXSETHV	Number of SET HOST VARIABLE statements executed	DB2XSETHV	DEC	19			DB2DEC19V
QXALDAB	Number of ALTER DATABASE statements executed	DB2XALDAB	DEC	19			DB2DEC19V
QXDRPPKG	Number of DROP PACKAGE statements executed	DB2XDRPPKG	DEC	19			DB2DEC19V
QXDSCRTB	Number of DESCRIBE TABLE statements executed	DB2XDSCRTB	DEC	19			DB2DEC19V
QXMAXDEG	Maximum parallelism degree	DB2XMAXDEG	DEC	19			DB2DEC19V
QXTOTGRP	Parallel groups: total executed	DB2XTOTGRP	DEC	19			DB2DEC19V
QXDEGCUR	Parallel groups fell to sequential due to updatable cursor	DB2XDEGCUR	DEC	19			DB2DEC19V
QXDEGESA	Par. groups fell to sequ. due to lack of ESA sort support	DB2XDEGESA	DEC	19			DB2DEC19V
QXDEGBUF	Parallel groups fell to sequential due to storage shortage	DB2XDEGBUF	DEC	19			DB2DEC19V
QXREDGRP	Parallel groups: executed with reduced degree	DB2XREDGRP	DEC	19			DB2DEC19V
QXNORGRP	Parallel groups: executed as planned	DB2XNORGRP	DEC	19			DB2DEC19V
QXCON1	Number of CONNECT TYPE 1 statements executed	DB2XCON1	DEC	19			DB2DEC19V
QXCON2	Number of CONNECT TYPE 2 statements executed	DB2XCON2	DEC	19			DB2DEC19V
QXREL	Number of RELEASE statements executed	DB2XREL	DEC	19			DB2DEC19V
QXSETCON	Number of SET CONNECTION statements executed	DB2XSETCON	DEC	19			DB2DEC19V
QXSETCDG	Number of SET CURRENT DEGREE statements executed	DB2XSETCDG	DEC	19			DB2DEC19V
QXSETCRL	Number of SET CURRENT RULES statements executed	DB2XSETCRL	DEC	19			DB2DEC19V
QXCALL	Number of SQL CALL statements executed	DB2XCALL	DEC	19			DB2DEC19V
QXCALLAB	# of times a stored procedure ABENDed	DB2XCALLAB	DEC	19			DB2DEC19V
QXCALLTO	# of times an SQL CALL stmt timedout waiting to be scheduled	DB2XCALLTO	DEC	19			DB2DEC19V
QXCALLRJ	# of times an SQL CALL statement was rejected	DB2XCALLRJ	DEC	19			DB2DEC19V
QXDEGENC	Par.groups fell to sequ. due to unavailable enclave services	DB2XDEGENC	DEC	19			DB2DEC19V
QXRLFDPA				0
QXSTRES1	Field type char, length 3, reserved	DB2RES03	CHAR	3			DB2CHAR03
QXCOORNO	COORDINATOR setting mismatch	DB2XCOORNO	DEC	19			DB2DEC19V
QXISORR	Isolation level RR or RS	DB2XISORR	DEC	19			DB2DEC19V
QXCRGTT	# OF CREATE GLBL TEMP TABLE	DB2XCRGTT	DEC	19			DB2DEC19V
QXSTREOP	Total Number of Times Reoptimization Occurs	DB2XREOP	DEC	19			DB2DEC19V
QXXCBPNX	Parallel groups: intended to run across data sharing group	DB2XXCBPNX	DEC	19			DB2DEC19V
QXXCSKIP	Member bypasses due to storage shortage	DB2XXCSKIP	DEC	19			DB2DEC19V
QXALOCL	# of ASSOCIATE LOCATOR statements executed	DB2XALOCL	DEC	19			DB2DEC19V
QXXCSKIP	Field Type INT, Length 4	DB2INT4U	INT4	10			DB2INT4U
QXALOCC	# of ALLOCATE CURSOR statements executed	DB2XALOCC	DEC	19			DB2DEC19V
QXALOCL	Field Type INT, Length 4	DB2INT4U	INT4	10			DB2INT4U
QXALOCC	Field Type INT, Length 4	DB2INT4U	INT4	10			DB2INT4U
QXSTFND	Number of Times that DB2 Found the Statement in the Cache	DB2XSTFND	DEC	19			DB2DEC19V
QXSTFND	Number of Times that DB2 Found the Statement in the Cache	DB2XSTFND	DEC	19			DB2DEC19V
QXSTNFND	Number of times statement could not be found in cache	DB2XSTNFND	DEC	19			DB2DEC19V
QXSTIPRP	Number of implicit prepares	DB2XSTIRP	DEC	19			DB2DEC19V
QXSTNFND	Number of times statement could not be found in cache	DB2XSTNFND	DEC	19			DB2DEC19V
QXSTIPRP	Number of implicit prepares	DB2XSTIRP	DEC	19			DB2DEC19V
QXSTNPRP	Number of avoided prepares	DB2XSTNPRP	DEC	19			DB2DEC19V
QXSTDEXP	MAXKEEPD parameter exceeded	DB2XSTDEXP	DEC	19			DB2DEC19V
QXSTNPRP	Number of avoided prepares	DB2XSTNPRP	DEC	19			DB2DEC19V
QXSTDEXP	MAXKEEPD parameter exceeded	DB2XSTDEXP	DEC	19			DB2DEC19V
QXSTDINV	Statement invalidated	DB2XSTINV	DEC	19			DB2DEC19V
QXRNTAB	RENAME TABLE	DB2XRNTAB	DEC	19			DB2DEC19V
QXSTDINV	Statement invalidated	DB2XSTINV	DEC	19			DB2DEC19V
QXFULLP	Total number of prepares: full prepares + short prepares	DB2FULLP	DEC	19			DB2DEC19V
QXRNTAB	Field Type INT, Length 4	DB2INT4U	INT4	10			DB2INT4U
QXCTRIG	Number of SQL CREATE TRIGGER statements	DB2XCTRIG	DEC	19			DB2DEC19V
QXFULLP	Total number of prepares: full prepares + short prepares	DB2FULLP	DEC	19			DB2DEC19V
QXCTRIG	Number of SQL CREATE TRIGGER statements	DB2XCTRIG	DEC	19			DB2DEC19V
QXDRPTR	Number of SQL DROP TRIGGER statements	DB2XDRPTR	DEC	19			DB2DEC19V
QXDRPTR	Number of SQL DROP TRIGGER statements	DB2XDRPTR	DEC	19			DB2DEC19V
QXSETPTH	Number of SQL SET CURRENT PATH statements	DB2XSETPTH	DEC	19			DB2DEC19V
QXDRPFN	Number of DROP UDF statements	DB2XDRPFN	DEC	19			DB2DEC19V
QXSETPTH	Number of SQL SET CURRENT PATH statements	DB2XSETPTH	DEC	19			DB2DEC19V
QXDRPFN	Number of DROP UDF statements	DB2XDRPFN	DEC	19			DB2DEC19V
QXDRPPR	Number of DROP PROCEDURE statements	DB2XDRPPR	DEC	19			DB2DEC19V
QXCDIST	Number of CREATE DISTINCT TYPE statements	DB2XCDIST	DEC	19			DB2DEC19V
QXDRPPR	Number of DROP PROCEDURE statements	DB2XDRPPR	DEC	19			DB2DEC19V
QXCDIST	Number of CREATE DISTINCT TYPE statements	DB2XCDIST	DEC	19			DB2DEC19V
QXDDIST	Number of DROP DISTINCT TYPE statements	DB2XDDIST	DEC	19			DB2DEC19V
QXCRUDF	Number of CREATE FUNCTION statements	DB2XCRUDF	DEC	19			DB2DEC19V
QXDDIST	Number of DROP DISTINCT TYPE statements	DB2XDDIST	DEC	19			DB2DEC19V
QXCRPRO	Number of CREATE PROCEDURE statements	DB2XCRPRO	DEC	19			DB2DEC19V
QXCRUDF	Number of CREATE FUNCTION statements	DB2XCRUDF	DEC	19			DB2DEC19V
QXCRPRO	Number of CREATE PROCEDURE statements	DB2XCRPRO	DEC	19			DB2DEC19V
QXHOLDL	Number of HOLD LOCATOR statements	DB2XHOLDL	DEC	19			DB2DEC19V
QXFREEL	Number of FREE LOCATOR statements	DB2XFREEL	DEC	19			DB2DEC19V
QXHOLDL	Number of HOLD LOCATOR statements	DB2XHOLDL	DEC	19			DB2DEC19V
QXFREEL	Number of FREE LOCATOR statements	DB2XFREEL	DEC	19			DB2DEC19V
QXREPOP1	Parallel groups with reformulated access path (Sysplex conf)	DB2XREPOP1	DEC	19			DB2DEC19V
QXREPOP1	Parallel groups with reformulated access path (Sysplex conf)	DB2XREPOP1	DEC	19			DB2DEC19V
QXREPOP2	Parallel groups with reformulated access path (buffer pool)	DB2XREPOP2	DEC	19			DB2DEC19V
QXCRATB	Number of CREATE AUXILIARY TABLE statements	DB2XCRATB	DEC	19			DB2DEC19V
QXREPOP2	Parallel groups with reformulated access path (buffer pool)	DB2XREPOP2	DEC	19			DB2DEC19V
QXCRATB	Number of CREATE AUXILIARY TABLE statements	DB2XCRATB	DEC	19			DB2DEC19V
QXSTLOBV	Maximum storage used for LOB values (MB)	DB2XSTLOBV	DEC	19			DB2DEC19V
QXALUDF	Number of ALTER FUNCTION statements	DB2XALUDF	DEC	19			DB2DEC19V
QXSTLOBV	Maximum storage used for LOB values (MB)	DB2XSTLOBV	DEC	19			DB2DEC19V
QXALPRO	Number of ALTER PROCEDURE statements	DB2XALPRO	DEC	19			DB2DEC19V
QXALUDF	Number of ALTER FUNCTION statements	DB2XALUDF	DEC	19			DB2DEC19V
QXALPRO	Number of ALTER PROCEDURE statements	DB2XALPRO	DEC	19			DB2DEC19V
QXROIMAT	Number of times DB2 used dir. row access to locate a record	DB2XROIMAT	DEC	19			DB2DEC19V
QXROIIDX	Direct row access attempted, but reverted to using index	DB2XROIIDX	DEC	19			DB2DEC19V
QXROIMAT	Number of times DB2 used dir. row access to locate a record	DB2XROIMAT	DEC	19			DB2DEC19V
QXROITS	Direct row access attempted, reverted to tablespace scan	DB2XROITS	DEC	19			DB2DEC19V
QXROIIDX	Direct row access attempted, but reverted to using index	DB2XROIIDX	DEC	19			DB2DEC19V
QXROITS	Direct row access attempted, reverted to tablespace scan	DB2XROITS	DEC	19			DB2DEC19V
QXSTTRG	Number of times a statement trigger is activated	DB2XSTTRG	DEC	19			DB2DEC19V
QXSTTRG	Number of times a statement trigger is activated	DB2XSTTRG	DEC	19			DB2DEC19V
QXROWTRG	Number of times a row trigger is activated	DB2XROWTRG	DEC	19			DB2DEC19V
QXROWTRG	Number of times a row trigger is activated	DB2XROWTRG	DEC	19			DB2DEC19V
QXTRGERR	No. of times an SQL error occurred during a triggered action	DB2XTRGERR	DEC	19			DB2DEC19V
QXCASCDP	Maximum level of nested SQL cascading	DB2XCASCDP	DEC	19			DB2DEC19V
QXTRGERR	No. of times an SQL error occurred during a triggered action	DB2XTRGERR	DEC	19			DB2DEC19V
QXCAUD	Number of user-defined functions executed	DB2XCAUD	DEC	19			DB2DEC19V
QXCASCDP	Maximum level of nested SQL cascading	DB2XCASCDP	DEC	19			DB2DEC19V
QXCAUD	Number of user-defined functions executed	DB2XCAUD	DEC	19			DB2DEC19V
QXCAUDAB	Number of times a user-defined function abended	DB2XCAUDAB	DEC	19			DB2DEC19V
QXCAUDAB	Number of times a user-defined function abended	DB2XCAUDAB	DEC	19			DB2DEC19V
QXCAUDTO	No. of times a user-defined funct. timed out before sched.	DB2XCAUDTO	DEC	19			DB2DEC19V
QXCAUDRJ	Number of times a user-defined function was rejected	DB2XCAUDRJ	DEC	19			DB2DEC19V
QXCAUDTO	No. of times a user-defined funct. timed out before sched.	DB2XCAUDTO	DEC	19			DB2DEC19V
QXCAUDRJ	Number of times a user-defined function was rejected	DB2XCAUDRJ	DEC	19			DB2DEC19V
GHITRATIO	Dynamic Statement Cache Global Hit Ratio	DB2GHITRAT	CHAR	7
GHITRATIO	Dynamic Statement Cache Global Hit Ratio	DB2GHITRAT	CHAR	7
LHITRATIO	Dynamic Statement Cache Local Hit Ratio	DB2LHITRAT	CHAR	7
LHITRATIO	Dynamic Statement Cache Local Hit Ratio	DB2LHITRAT	CHAR	7
REPREPRAT	Reprepare Ratio	DB2RPRERAT	CHAR	7
PREPREQ	Number of Prepare Requests	DB2PREPR	DEC	19			DB2DEC19V
REPREPRAT	Reprepare Ratio	DB2RPRERAT	CHAR	7
PREPREQ	Number of Prepare Requests	DB2PREPR	DEC	19			DB2DEC19V
SHORTPREP	Number of Short Prepares	DB2SHPREP	DEC	19			DB2DEC19V
QXALTJR	alter jar Number of ALTER JAR statements	DB2XALTJR	DEC	19			DB2DEC19V
SHORTPREP	Number of Short Prepares	DB2SHPREP	DEC	19			DB2DEC19V
QXALTJR	Number of ALTER JAR statements			0
QXMERGE	# of times merge sql statement was executed Number of MERGE statements	DB2XMERGE	DEC	19			DB2DEC19V
QXMERGE	Number of MERGE statements			0
QXTRTBL	# of times truncate table stmt was exec. Number of TRUNCATE TABLE statements	DB2XTRTBL	DEC	19			DB2DEC19V
QXCRROL	create role Number of CREATE ROLE statements	DB2XCRROL	DEC	19			DB2DEC19V
QXTRTBL	Number of TRUNCATE TABLE statements			0
QXCRROL	Number of CREATE ROLE statements			0
QXDRPROL	drop role Number of DROP ROLE statements	DB2XDRPROL	DEC	19			DB2DEC19V
QXCRCTX	create trusted context Number of CREATE TRUSTED CONTEXT statements	DB2XCRCTX	DEC	19			DB2DEC19V
QXDRPROL	Number of DROP ROLE statements			0
QXCRCTX	Number of CREATE TRUSTED CONTEXT statements			0
QXALTCTX	alter trusted context Number of ALTER TRUSTED CONTEXT statements	DB2XALTCTX	DEC	19			DB2DEC19V
QXALTCTX	Number of ALTER TRUSTED CONTEXT statements			0
QXDRPCTX	drop trusted context Number of DROP TRUSTED CONTEXT statements	DB2XDRPCTX	DEC	19			DB2DEC19V
QXRNIX	rename index Number of RENAME INDEX statements	DB2XRNIX	DEC	19			DB2DEC19V
QXDRPCTX	Number of DROP TRUSTED CONTEXT statements			0
QXRNIX	Number of RENAME INDEX statements			0
QTID	Small integer	DB2INT2AA	INT2	5			DB2SINT
QTID	Small integer	DB2INT2AA	INT2	5			DB2SINT
QTLEN	Small integer	DB2INT2AA	INT2	5			DB2SINT
QTEYE	Field type char, length 4	DB2CHAR04	CHAR	4			DB2CHAR04
QTLEN	Small integer	DB2INT2AA	INT2	5			DB2SINT
QTEYE	Field type char, length 4	DB2CHAR04	CHAR	4			DB2CHAR04
QTALLOCA	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTALLOC	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTALLOCA	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTALLOC	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTABINDA	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTABIND	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTABINDA	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTABIND	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTINVRID	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTBINDA	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTINVRID	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTBINDA	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTBINDR	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTBINDR	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTTESTB	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTPLNBD	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTTESTB	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTREBIND	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTRBINDA	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTPLNRBD	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTFREE	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTFREEA	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTPLNFRD	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTAUCHK	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTAUSUC	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTDSOPN	Number of datasets open concurrently	DB2TDSOPN	INT4	10			DB2INT4U
QTMAXDS	Max. no. of datasets open concurrently	DB2TMAXDS	INT4	10			DB2INT4U
QTAUCCH	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTAUPUB	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTMAXPB	Page sets available to drain since last statistics interval	DB2TMAXPB	INT4	10			DB2INT4U
QTPACAUT	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTPACPUB	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTPACNOT	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTREOPN	Number of times a previously unused dataset was used	DB2TREOPN	INT4	10			DB2INT4
QTPACOW1	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTPACOW2	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTSTRES1	Field type char, length 4, reserved	DB2RES04	CHAR	4			DB2CHAR04
QTDSDRN	Number of datasets that were closed via the DRAIN process	DB2TDSDRN	INT4	10			DB2INT4U
QTSTRES1	Field type char, length 4, reserved	DB2RES04	CHAR	4			DB2CHAR04
QTPCCT	No. of infrequently updated datasets conv. from R/W to R/O	DB2TPCCT	INT4	10			DB2INT4U
QTSLWDD	Datasets not used, but not closed due to deferred close	DB2TSLWDD	INT4	10			DB2INT4U
QTBINDPA	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTBINDPR	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTPKGBD	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTRBINDP	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTRBNDPA	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTPKGRBD	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTFREEP	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTFREEAP	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTPKGFRD	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTAUTOBA	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTPKABND	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTPKALLA	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTPKALL	Field Type INT, Length 4	DB2INT4	INT4	10			DB2INT4
QTRACAUT	Number of successful authorization checks	DB2TRACAUT	INT4	10			DB2INT4
QTRACPUB	Number of successful public authorization checks	DB2RACPUB	INT4	10			DB2INT4
QTRACNOT	Number of authorization checks without authorization cache	DB2RANOT	INT4	10			DB2INT4
QTRACOW1	Number of authorization ID overrides in authorization cache	DB2RACOW1	INT4	10			DB2INT4
QTRACOW2	Number of routine entry overrides in authorization cache	DB2RACOW2	INT4	10			DB2INT4
QTRACNAC	Number of failures in adding an entry to authorization cache	DB2RACNAC	INT4	10			DB2INT4
QISTRLLM	RDS limit exceeded	DB2ISTRLLM	DEC	10			DEC_10
QISTRPLM	Physical limit reached	DB2ISTRPLM	DEC	10			DEC_10
QISTRHIG	RID blocks allocated - maximum	DB2ISTRHIG	DEC	10			DEC_10
QISTRCUR	RID block allocated - current	DB2ISTRCUR	DEC	10			DEC_10
QISTRSTG	RID list processing exhausted virtual storage	DB2ISTRSTG	DEC	10			DEC_10
QISTRMAX	Process limit exceeded	DB2ISTRMAX	DEC	10			DEC_10
QISTCOLS	Field type numc, length 10, integer	DB2NUMC10	INT4	10			DB2INT4
QTXADEA	Number of deadlocks	DB2TXADEA	INT4	10			DB2INT4
QTXASLOC	Number of lock suspensions	DB2TXASLOC	INT4	10			DB2INT4
QTXATIM	Number of timeouts	DB2TXATIM	INT4	10			DB2INT4
QTXALES	Number of lock escalations (shared)	DB2TXALES	INT4	10			DB2INT4
QTXALEX	Number of lock escalations (exclusive)	DB2TXALEX	INT4	10			DB2INT4
QTXANPL	Maximum page or row locks held	DB2TXANLP	INT4	10			DB2INT4
QTXAFLG1	Field type char, length 1, bit field	DB2BIT01	CHAR	1			DB2CHAR01
QTXARES1	Field type char, length 1, reserved	DB2RES01	CHAR	1			DB2CHAR01
QTXARLID	Field type char, length 2	DB2CHAR02	CHAR	2			DB2CHAR02
QTXAPREC	Precedence How Limit determined	DB2TXAPREC	INT4	10			DB2INT4
QTXASLMT	Limit in SU's - ASUTIME Column	DB2TXASLMT	INT4	10			DB2INT4
QTXACLMT	Limit in CPU 16 microseconds	DB2TXACLMT	INT4	10			DB2INT4
QTXACHUS	Highest amt CPU 16 microsec used in successful DB2 call	DB2TXACHUS	INT4	10			DB2INT4
QTXASLAT	Number of latch suspensions	DB2TXASLAT	INT4	10			DB2INT4
QTXASOTH	Number of other suspensions	DB2TXASOTH	INT4	10			DB2INT4
QTXALOCK	Number of lock requests	DB2TXALOCK	INT4	10			DB2INT4
QTXALOCKD	Number of lock requests	DB2TXALOCKD	DEC	10			DB2DEC10V
QTXAUNLK	Number of unlock requests	DB2TXAUNLK	INT4	10			DB2INT4
QTXAUNLKD	Number of unlock requests	DB2TXAUNLKD	DEC	10			DB2DEC10V
QTXAQRY	Number of query requests	DB2TXAQRY	INT4	10			DB2INT4
QTXACHG	Number of change requests	DB2TXACHG	INT4	10			DB2INT4
QTXAIRLM	Number of other requests	DB2TXAIRLM	INT4	10			DB2INT4
QTXACLNO	Number of claim requests	DB2TXACLNO	INT4	10			DB2INT4
QTXACLUN	Number of claim requests that were unsuccessful	DB2TXACLUN	INT4	10			DB2INT4
QTXADRNO	Number of drain requests	DB2TXADRNO	INT4	10			DB2INT4
QTXADRUN	Number of drain requests that were unsuccessful	DB2TXADRUN	INT4	10			DB2INT4
QISEFAIL	Field type numc, length 10, integer	DB2NUMC10	INT4	10			DB2INT4
QISEPAGE	Current number of pages in the EDM pool	DB2ISEPAGE	DEC	10			DB2DEC10V
QISECTG	Number of requests for cursor table sections	DB2ISECTG	DEC	10			DB2DEC10V
QISECT	Current number of pages in EDM pool used for cursor tables	DB2ISECT	DEC	10			DB2DEC10V
QISECTL	Number of CT sections not found in EDM pool	DB2ISECTL	DEC	10			DB2DEC10V
QISECT	Current number of pages in EDM pool used for cursor tables	DB2ISECT	DEC	10			DB2DEC10V
QISEFREE	Current number of free pages in the free chain	DB2ISEFREE	DEC	10			DB2DEC10V
QISEDBD	Current number of pages in EDM pool used for DB descriptor	DB2ISEDBD	DEC	10			DB2DEC10V
QISEFREE	Current number of free pages in the free chain	DB2ISEFREE	DEC	10			DB2DEC10V
QISEDBD	Current number of pages in EDM pool used for DB descriptor	DB2ISEDBD	DEC	10			DB2DEC10V
QISESKCT	Current number of pages in EDM pool used for skeleton CT	DB2ISESKCT	DEC	10			DB2DEC10V
QISEDBDG	Number of requests for database descriptor	DB2ISEDBDG	DEC	10			DB2DEC10V
QISESKCT	Current number of pages in EDM pool used for skeleton CT	DB2ISESKCT	DEC	10			DB2DEC10V
QISEDBDG	Number of requests for database descriptor	DB2ISEDBDG	DEC	10			DB2DEC10V
QISEDBDL	Number of DB descriptors not found in EDM pool	DB2ISEDBDL	DEC	10			DB2DEC10V
QISEKTG	Number of requests for package table sections	DB2ISEKTG	DEC	10			DB2DEC10V
QISEDBDL	Number of DB descriptors not found in EDM pool	DB2ISEDBDL	DEC	10			DB2DEC10V
QISEKTG	Number of requests for package table sections	DB2ISEKTG	DEC	10			DB2DEC10V
QISEKTL	Number of times a PT section was not found in EDM pool	DB2ISEKTL	DEC	10			DB2DEC10V
QISEKT	Current number of pages in EDM pool used for package tables	DB2ISEKT	DEC	10			DB2DEC10V
QISEKTL	Number of times a PT section was not found in EDM pool	DB2ISEKTL	DEC	10			DB2DEC10V
QISEKT	Current number of pages in EDM pool used for package tables	DB2ISEKT	DEC	10			DB2DEC10V
QISESKPT	Current number of pages in EDM pool used for skeleton PT	DB2ISESKPT	DEC	10			DB2DEC10V
QISEDSI	Number of inserts into EDM pool for dynamic statement cache	DB2ISEDSI	DEC	10			DB2DEC10V
QISESKPT	Current number of pages in EDM pool used for skeleton PT	DB2ISESKPT	DEC	10			DB2DEC10V
QISEDSG	Number of requests for DSC sections	DB2ISEDSG	DEC	10			DB2DEC10V
QISEDSI	Number of inserts into EDM pool for dynamic statement cache	DB2ISEDSI	DEC	10			DB2DEC10V
QISEDSC	Number of pages used for DSC	DB2ISEDSC	DEC	10			DB2DEC10V
QISEDSG	Number of requests for DSC sections	DB2ISEDSG	DEC	10			DB2DEC10V
QISEDSC	Number of pages used for DSC	DB2ISEDSC	DEC	10			DB2DEC10V
QISEDFAL	Number of failures because the data space is full	DB2ISEDFAL	DEC	10			DB2DEC10V
QISEDFAL	Number of failures because the data space is full	DB2ISEDFAL	DEC	10			DB2DEC10V
QISEDPGE	Number of pages in the data space used by the EDM pool	DB2ISEDPGE	DEC	10			DB2DEC10V
QISEDFRE	Number of free pages in the data space free chain	DB2ISEDFRE	DEC	10			DB2DEC10V
QISEDPGE	Number of pages in the data space used by the EDM pool	DB2ISEDPGE	DEC	10			DB2DEC10V
QISECPGE	Number of pages in EDM statement pool			0
QISEDFRE	Number of free pages in the data space free chain	DB2ISEDFRE	DEC	10			DB2DEC10V
QISECFRE	Number of free pages in EDM statement pool			0
QISECPGE	Number of pages in EDM statement pool Number of pages in EDM statement pool	DB2ISECPGE	INT4	10			DB2INT4
QISECFRE	Number of free pages in EDM statement pool Number of free pages in EDM statement pool	DB2ISECFRE	INT4	10			DB2INT4
QISESTMT	Number of statements in EDM pool for dynamic statement cache			0
QISESTMT	Number of statements in EDM pool for dynamic statement cache Number of statements in EDM pool for dynamic statement cache	DB2ISESTMT	DEC	10			DB2DEC10V
QISJTRY	Field Type DEC, Length 10	DB2DEC10	DEC	10			DEC_10
QISJTRY	Field Type DEC, Length 10	DB2DEC10	DEC	10			DEC_10
QISJFAIL	Field Type DEC, Length 10	DB2DEC10	DEC	10			DEC_10
QISJFAIL	Field Type DEC, Length 10	DB2DEC10	DEC	10			DEC_10
QISJSIZE	Field Type DEC, Length 10	DB2DEC10	DEC	10			DEC_10
QISJMAX	Field Type DEC, Length 10	DB2DEC10	DEC	10			DEC_10
QISJSIZE	Field Type DEC, Length 10	DB2DEC10	DEC	10			DEC_10
QISJMAX	Field Type DEC, Length 10	DB2DEC10	DEC	10			DEC_10

Key field

Non-key field

How do I retrieve data from SAP structure DB2QSYSW2 using ABAP code?

As DB2QSYSW2 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DB2QSYSW2 as there is no data to select.

How to access SAP table DB2QSYSW2

Within an ECC or HANA version of SAP you can also view further information about DB2QSYSW2 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!