DB2QWPT2 SAP (DB2 installation parameters (first part: DB2QWPT1)) Structure details
Description: DB2 installation parameters (first part: DB2QWPT1)
Structure field list including key, data, relationships and ABAP select examples
DB2QWPT2 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 installation parameters (first part: DB2QWPT1)" 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_DB2QWPT2 TYPE DB2QWPT2.
The DB2QWPT2 table consists of various fields, each holding specific information or linking keys about DB2 installation parameters (first part: DB2QWPT1) data available in SAP. These include QWP5PCY (IRLM cross memory enabled), QWP5DLOK (Deadlock time (seconds)), QWP5DCYC (Deadlock cycle), QWP5TVAL (Actual resource timeout).. 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: Cannot Be Enhanced
SAP DB2QWPT2 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 | ||||
QWP5PCY | IRLM cross memory enabled | DB2WP5PCY | CHAR | 3 | DB2CHAR03L | ||||
QWP5DLOK | Deadlock time (seconds) | DB2WP5DLOK | INT2 | 5 | DB2SINT | ||||
QWP5DCYC | Deadlock cycle | DB2WP5DCYC | INT2 | 5 | DB2SINT | ||||
QWP5TVAL | Actual resource timeout | DB2WP5TVAL | INT4 | 10 | DB2INT4 | ||||
QWP5MCSA | DB2WP5MCSA | INT4 | 10 | DB2INT4 | |||||
QWP5FLG | 0 | ||||||||
QWP5HASH | 0 | ||||||||
QWP5PHSH | 0 | ||||||||
QWP5RLE | 0 | ||||||||
QWPAGRPN | Name of a DB2 data sharing group | DB2WPAGRPN | CHAR | 10 | CHAR10 | ||||
QWPAMBRN | Name of a new or existing DB2 data sharing member | DB2WPAMBRN | CHAR | 10 | CHAR10 | ||||
QWPAIOPT | Whether data sharing function is used or not | DB2WPAIOPT | CHAR | 6 | CHAR6 | ||||
QWPACOOR | Whether a DB2 subsystem can be a parallelism coordinator | DB2WPACOOR | CHAR | 8 | DB2CHAR08 | ||||
QWPAASST | Indicates whether this DB2 can assist parallel processing | DB2WPAASST | CHAR | 8 | DB2CHAR08 | ||||
QWPASUCV | CPU Service Unit Conversion Factor | DB2WPASUCV | INT4 | 10 | DB2INT4 | ||||
QWPAMAXM | Maximum Number of Members | DB2WPAMAXM | INT4 | 10 | DB2INT4 | ||||
QWPAIMMW | Immediate writes for GBPs | DB2WPAIMMW | CHAR | 8 | DB2CHAR8 | ||||
QWPBSID | The EBCDIC single-byte coded character set ID | DB2WPBSID | INT4 | 10 | |||||
QWPBMID | The EBCDIC mixed coded character set ID | DB2WPBMID | INT4 | 10 | |||||
QWPBGID | The EBCDIC graphic coded character set ID | DB2WPBGID | INT4 | 10 | |||||
QWPBASID | The ASCII single-byte coded character set ID | DB2WPBASID | INT4 | 10 | |||||
QWPBAMID | The ASCII mixed coded character set ID | DB2WPBAMID | INT4 | 10 | |||||
QWPBAR | Indicates the rules of precision for a decimal field | DB2WPBAR | CHAR | 10 | DB2CHAR10L | ||||
QWPBDRUL | Whether DSNHDECP values are used for dynamic SQL statements | DB2WPBDRUL | CHAR | 3 | DB2CHAR03L | ||||
QWPBDE | Whether the decimal contains a comma (,) or a period (.) | DB2WPBDE | CHAR | 8 | DB2CHAR08L | ||||
QWPBCHAR | The default character set, which can be ALPHANUM or KATAKANA | DB2WPBCHAR | CHAR | 8 | CHAR8 | ||||
QWPBENS | The default encoding scheme, which can be ASCII or EBCDIC. | DB2WPBENS | CHAR | 8 | CHAR8 | ||||
QWPBLANG | The default programming language for your site | DB2WPBLANG | CHAR | 8 | CHAR8 | ||||
QWPBGRA | Default mixed graphic | DB2WPBGRA | CHAR | 3 | DB2CHAR03L | ||||
QWPBSDL | The string delimiter for SQL | DB2WPBSDL | CHAR | 10 | DB2CHAR10L | ||||
QWPBDSD | Distributed SQL string delimiter | DB2WPBDSD | CHAR | 10 | DB2CHAR10L | ||||
QWPBDATE | The default output format for dates | DB2WPBDATE | CHAR | 10 | CHAR10 | ||||
QWPBTIME | The default output format for times | DB2WPBTIME | CHAR | 10 | CHAR10 | ||||
QWPBDLEN | Local date length | DB2WPBDLEN | INT2 | 5 | DB2SINT | ||||
QWPBTLEN | Local time length | DB2WPBTLEN | INT2 | 5 | DB2SINT | ||||
QWPBSQL | SQL language support level | DB2WPBSQL | CHAR | 3 | DB2CHAR03L | ||||
QWPBAGID | ASCII GBCS CCSID | DB2WPBAGID | INT4 | 10 | DB2INT4 | ||||
QWPBDEL | Default delimiter | DB2WPBDEL | CHAR | 10 | DB2CHAR10L | ||||
QWPBLCTP | Default locale LC_CTYPE | DB2WPBLCTP | CHAR | 50 | DB2CHAR50L | ||||
QWPBUSID | 0 | ||||||||
QWPBUMID | 0 | ||||||||
QWPBUGID | 0 | ||||||||
QWPBAPSC | Application encoding scheme | DB2WPAPSC | CHAR | 30 | CHAR30 | ||||
QWP3BKSZ | The block size of the archive log data sets | DB2WP3BKSZ | INT4 | 10 | DB2INT4 | ||||
QWP3RISP | Primary space allocation | DB2WP3RISP | INT4 | 10 | DB2INT4 | ||||
QWP3SECS | Secondary space allocation | DB2WP3SECS | INT4 | 10 | DB2INT4 | ||||
QWP3UNT1 | The type of device for COPY1 archive logs | DB2WP3UNT1 | CHAR | 10 | CHAR10 | ||||
QWP3RE1N | DSN prefix character string for copy-1 archive log dataset | DB2WP3RE1N | CHAR | 20 | CHAR20 | ||||
QWP3UNT2 | The type of device for COPY2 archive logs | DB2WP3UNT2 | CHAR | 10 | CHAR10 | ||||
QWP3RE2N | DSN prefix character string for copy-2 archive log dataset | DB2WP3RE2N | CHAR | 20 | CHAR20 | ||||
QWP3CTLG | Whether the archive datasets are cataloged in the IFC | DB2WP3CTLG | CHAR | 4 | |||||
QWP3UNIT | Device type to which the archive log sets are written | DB2WP3UNIT | CHAR | 10 | CHAR10 | ||||
QWP3MSV1 | Mass storage system volume group 1 name | DB2WP3MSV1 | CHAR | 10 | DB2CHAR10L | ||||
SPACEALLOC | The unit used in allocating archive datasets | DB2SPACEUN | CHAR | 10 | CHAR10 | ||||
QWP3MSV2 | Mass storage system volume group 2 name | DB2WP3MSV2 | CHAR | 10 | DB2CHAR10L | ||||
QWP3RETN | Number of days the archive log data sets are to be retained | DB2WP3RETN | INT2 | 5 | DB2SINT | ||||
QWP3DTIM | Indicates whether a timestamp is inserted in log datasets | DB2WP3DTIM | CHAR | 3 | DB2CHAR03L | ||||
QWP3MQP | Maximum time for DB2 to attempt a full system quiesce | DB2WP3MQP | INT2 | 5 | DB2SINT | ||||
QWP3ALCU | The unit used in allocating archive datasets | DB2WP3ALCU | CHAR | 10 | DB2CHAR10L | ||||
QWP3WTOR | Issue WTOR before archive mounts | DB2WP3WTOR | CHAR | 3 | DB2CHAR03L | ||||
QWP3COMP | Force data compaction | DB2WP3COMP | CHAR | 3 | DB2CHAR03L | ||||
QWP3RTCT | Archive logs RACF protection | DB2WP3RTCT | CHAR | 3 | DB2CHAR03L | ||||
QWP6CATN | High qualifier name for all DB2 system datasets | DB2WP6CATN | CHAR | 8 | CHAR8 | ||||
QWP8DBNM | Name of database to be automatically started | DB2WP8DBNM | CHAR | 10 | CHAR10 | ||||
QWP8SPNM | Tablespace name or indexspace name | DB2WP8SPNM | CHAR | 10 | CHAR10 | ||||
QWP9TTO | Idle thread timeout | DB2WP9TTO | INT2 | 5 | DB2SINT | ||||
QWP9STRT | The startup option for the distributed data facility (DDF) | DB2WP9STRT | CHAR | 14 | CHAR14 | ||||
QWP9RYC | Number of minutes between two resynchronization intervals | DB2WP9RYC | INT2 | 5 | DB2SINT | ||||
QWP9CMST | Status of a DBAT | DB2WP9CMST | CHAR | 10 | CHAR10 | ||||
QWP9MAX1 | Maximum type 1 inactive threads allowed by DB2 | DB2WP9MAX1 | INT4 | 10 | DB2INT4 | ||||
QWP9RLER | Resource limit facility error parameter | DB2WP9RLER | CHAR | 10 | DB2CHAR10L | ||||
QWP9RLFN | Specifies the Limit in CPU Time Service Units | DB2WP9RLFN | INT4 | 10 | DB2INT4 | ||||
QWP9TCPA | Whether verified conn. are accepted from TCP/IP clients | DB2WP9TCPA | CHAR | 3 | DB2CHAR03L | ||||
QWP9TCPK | TCP/IP keepalive (ZPARM: TCPKPALV) | 0 | |||||||
QWP9INAC | Pool thread timeout (ZPARM: POOLINAC) | 0 | |||||||
QWP9PRSTD | Disable Progressive Streaming (ZPARM PRGSTRIN) | 0 | |||||||
QWP4REGO | The name of the object registration table | DB2WP4REGX | CHAR | 128 | CHAR128 | ||||
QWP4EDBC | EDM pool: DBD cache size (ZPARM EDMDBDC) | 0 | |||||||
QWP4ESTC | EDM pool: DSC size (ZPARM EDMSTMTC) | 0 | |||||||
QWP4MXNC | Max. number of cursors (ZPARM MAX_NUMB_CUR) | 0 | |||||||
QWP4MXSP | Max. number of stored proc. (ZPARM MAX_ST_PROC) | 0 | |||||||
QWP4LRTH | Duration for long-running reader alert (ZPARM LRDRTHLD) | 0 | |||||||
QWP4PDIX | Pad indexes by default (ZPARM PADIX) | 0 | |||||||
QWP4ACCU | # records for rollup of accounting records (ZPARM ACCUMACC) | 0 | |||||||
QWP4MXOS | Max. optimizer storage (ZPARM MAX_OPT_STOR) | 0 | |||||||
QWP4MXOC | Max. optimizer CPU time (ZPARM MAX_OPT_CPU) | 0 | |||||||
QWP4MXOE | Max. optimizer elapsed time (ZPARM MAX_OPT_ELAP) | 0 | |||||||
QWP4SJXP | Star join pool (ZPARM SJMXPOOL) | 0 | |||||||
QWP4DCIX | SMS Dataclass for indexspaces | DB2CWP4DCI | CHAR | 8 | DB2CHAR08 | ||||
QWP4DCFS | SMS Dataclass for tablespaces | DB2CWP4DCF | CHAR | 8 | DB2CHAR08 | ||||
QWP1ACID | Accounting aggregation fields (ZPARM ACCUMUID) | 0 | |||||||
QWP1MESZ | Optimize extent sizing (ZPARM MGEXTSZ) | 0 | |||||||
QWP1TSQT | Default space (KB) for table spaces (ZPARM TSQTY) | 0 | |||||||
QWP1IXQT | Default space (KB) for index spaces (ZPARM IXQTY) | 0 | |||||||
QWP1VVCI | Use VSAM variable control intervals (ZPARM DSVCI) | 0 | |||||||
QWP1UNIC | Trace IFC fields in Unicode (ZPARM UIFCIDS) | 0 | |||||||
QWP4PJSJ | Enable pair-wise join (ZPARM EN_PJSJ) | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure DB2QWPT2 using ABAP code?
As DB2QWPT2 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 DB2QWPT2 as there is no data to select.How to access SAP table DB2QWPT2
Within an ECC or HANA version of SAP you can also view further information about DB2QWPT2 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects