DB2QWPT1 SAP (DB2 installation parameters (sec. part: DB2QWPT2)) Structure details
Description: DB2 installation parameters (sec. part: DB2QWPT2)
Structure field list including key, data, relationships and ABAP select examples
DB2QWPT1 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 (sec. part: DB2QWPT2)" 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_DB2QWPT1 TYPE DB2QWPT1.
The DB2QWPT1 table consists of various fields, each holding specific information or linking keys about DB2 installation parameters (sec. part: DB2QWPT2) data available in SAP. These include QWP1SMRC (The individual write-to-operator routing codes started), QWP1RLF (Resource limit facility automatic start), QWP1TRSZ (Size of resident trace table (multiple of 4K)), QWP1LOGL (Number of log records written between checkpoints).. 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 (Deep)
SAP DB2QWPT1 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 | ||||
QWP1SMRC | The individual write-to-operator routing codes started | DB2WP1SMRC | CHAR | 38 | |||||
QWP1RLF | Resource limit facility automatic start | DB2WP1RLF | CHAR | 3 | DB2CHAR03L | ||||
QWP1TRSZ | Size of resident trace table (multiple of 4K) | DB2WP1TRSZ | INT2 | 5 | DB2SINT | ||||
QWP1LOGL | Number of log records written between checkpoints | DB2WP1LOGL | INT4 | 10 | DB2INT4 | ||||
QWP1IDB | Maximum number of concurrent connections from batch job | DB2WP1IDB | INT2 | 5 | DB2SINT | ||||
QWP1IDF | Maximum number of concurrent TSO foreground connections | DB2WP1IDF | INT2 | 5 | DB2SINT | ||||
QWP1CT | The maximum number of concurrent allied threads | DB2WP1CT | INT2 | 5 | DB2SINT | ||||
QWP1RMT | Maximum number of database access threads | DB2WP1RMT | INT2 | 5 | DB2SINT | ||||
QWP1LVL | Used to detect parameters and code that are out of sync | DB2WP1LVL | INT2 | 5 | DB2SINT | ||||
QWP1DTIM | Time Interval Before DB2 Resets Data Set Statistics (Min.) | DB2WP1DTIM | INT2 | 5 | DB2SINT | ||||
QWP1DB1M | Amount of space reserved for MVS functions | DB2WP1DB1M | INT4 | 10 | DB2INT4 | ||||
QWP1CRIT | Amount of space reserved for critical work | DB2WP1CRIT | INT4 | 10 | DB2INT4 | ||||
QWP1SOS | Amount of space above MVS and critical space | DB2QWP1SOS | INT4 | 10 | DB2INT4 | ||||
QWP1STIM | Time interval (in minutes) between statistics collection | DB2WP1STIM | INT2 | 5 | DB2SINT | ||||
QWP1DBPR | Database protocol for 3-part names | DB2WP1DBPR | CHAR | 8 | DB2CHAR08 | ||||
QWP1TRST | The GLOBAL TRACE Classes Started | DB2WP1TRST | CHAR | 3 | DB2CHAR03L | ||||
QWP1SMFS | The SMF STATISTICS TRACE Classes Started | DB2WP1SMFS | CHAR | 3 | DB2CHAR03L | ||||
QWP1SMFA | The SMF ACCOUNTING TRACE Classes Started | DB2WP1SMFA | CHAR | 3 | DB2CHAR03L | ||||
QWP1AUDT | The AUDIT TRACE classes started | DB2WP1AUDT | CHAR | 8 | CHAR8 | ||||
QWP1RLFA | Authorization ID of the resource limit specification table | DB2WP1RLFA | CHAR | 128 | CHAR128 | ||||
QWP1RLFT | Resource limit specification table ID | DB2WP1RLFT | CHAR | 4 | DB2CHAR04 | ||||
QWP1RLFR | FLAGS (ONE BYTE, USED AS BITS 1-8) | DB2WP1RLFR | RAW | 1 | DB2RAW01 | ||||
QWP1RLFN | Resource limit specification table error action | DB2WP1RLFN | CHAR | 10 | |||||
QWP1MON | Monitor tracing start options | DB2WP1MON | CHAR | 3 | DB2CHAR03L | ||||
QWP1MONS | Monitor Buffer Size (KB) | DB2WP1MONS | INT4 | 10 | DB2INT4 | ||||
QWP1FREQ | Pseudo-close frequency | DB2WP1FREQ | INT2 | 5 | DB2SINT | ||||
QWP1TMR | Pseudo-close time | DB2WP1TMR | INT2 | 5 | DB2SINT | ||||
QWP1DFRQ | Number of checkpoints | DB2WP1DFRQ | CHAR | 10 | |||||
QWP1SPPN | Name of JCL procedure used to start DB2 address space | DB2WP1SPPN | CHAR | 10 | DB2CHAR10 | ||||
QWP1SPAB | Number of abends allowed for a stored procedure | DB2WP1SPAB | INT2 | 5 | DB2SINT | ||||
QWP1SPTO | Stored procedure timeout value | DB2WP1SPTO | INT2 | 5 | DB2SINT | ||||
QWP1SCER | Extended security | DB2WP1SCER | CHAR | 4 | DB2CHAR04 | ||||
QWP1URCK | UR Checkpoint Frequency | DB2WP1URCK | INT2 | 5 | DB2SINT | ||||
QWP1FLBZ | Maximum DSN1DBM1 Storage for Fast Log Apply (MB) | DB2WP1FLBZ | INT2 | 5 | DB2SINT | ||||
QWP1TBPL | Default buffer pool for 4 KB tablespaces | DB2WP1TBPL | CHAR | 8 | DB2BPNAME | ||||
QWP1IXPL | Default buffer pool for user indexspaces | DB2WP1IXPL | CHAR | 8 | DB2BPNAME | ||||
QWP1WLME | Default WLM environment for user-defined functions/stoprocs | DB2WP1WLME | CHAR | 18 | DB2CHAR18 | ||||
QWP1LMBO | Whether DB2 postpones backward log processing during restart | DB2WP1LMBO | CHAR | 4 | DB2CHAR04L | ||||
QWP1BDUR | Restart backout limit | DB2WP1BDUR | INT2 | 5 | DB2SINT | ||||
QWP1EXBR | Maximum number of extra DRDA query blocks for DB2 requester | DB2WP1EXBR | INT2 | 5 | DB2SINT | ||||
QWP1EXBS | Maximum number of extra DRDA query blocks for DB2 server | DB2WP1EXBS | INT2 | 5 | DB2SINT | ||||
QWP1LVA | Max. number of KB that a user can use to store lob values | DB2WP1LVA | INT4 | 10 | DB2INT4 | ||||
QWP1LVS | Max. number of MB a subsystem can use to store lob values | DB2WP1LVS | INT4 | 10 | DB2INT4 | ||||
QWP1CDB | Maximum number of connected remote threads | DB2WP1CDB | INT4 | 10 | DB2INT4 | ||||
QWP1PROL | Whether accounting records should be rolled up | DB2WP1PROL | CHAR | 3 | DB2CHAR03L | ||||
QWP1TLSZ | Size of the Local Trace Tables in Multiples of 4 KB | DB2WP1TLSZ | INT2 | 5 | DB2SINT | ||||
QWP1SYNO | Statistics synchronization | DB2WP1SYNO | CHAR | 8 | CHAR8 | ||||
QWP1SYNV | 0 | ||||||||
QWP1LWCK | Long URs detection (UR based) | DB2WP1LWCK | INT4 | 10 | DB2INT4U | ||||
QWP1TP8 | Default 8KB buffer pool for implicit tablespaces | 0 | |||||||
QWP1TP16 | Default 16KB buffer pool for implicit tablespaces | 0 | |||||||
QWP1TP32 | Default 32KB buffer pool for implicit tablespaces | 0 | |||||||
QWP1TPLB | Default buffer pool for LOB tablespaces | 0 | |||||||
QWP1TPXM | Default buffer pool for XML tablespaces | 0 | |||||||
QWP1EIDB | Enable implicit database creation | 0 | |||||||
QWP1SITS | Create SEGMENTED or PBG implicit tablespaces | 0 | |||||||
QWP1DIDS | Define data sets when creating implicit tablespaces | 0 | |||||||
QWP1CITS | Use data compression for implicit tablespaces | 0 | |||||||
QWP1ACID | Accounting aggregation fields (ZPARM ACCUMUID) | 0 | |||||||
QWP1IXQT | Default space (KB) for index spaces (ZPARM IXQTY) | 0 | |||||||
QWP1MESZ | Optimize extent sizing (ZPARM MGEXTSZ) | 0 | |||||||
QWP2IBPS | Log input buffer pool size (in kilobytes) | DB2WP2IBPS | INT4 | 10 | DB2INT4 | ||||
QWP1TSQT | Default space (KB) for table spaces (ZPARM TSQTY) | 0 | |||||||
QWP1UNIC | Trace IFC fields in Unicode (ZPARM UIFCIDS) | 0 | |||||||
QWP1VVCI | Use VSAM variable control intervals (ZPARM DSVCI) | 0 | |||||||
QWP1DSSZ | IMPDSSIZE | 0 | |||||||
QWP1TKMD | IMPTKMOD | 0 | |||||||
QWP1LBIL | LOB_INLINE_LENGTH | 0 | |||||||
QWP1DCFS | DEL_CFSTRUCT | 0 | |||||||
QWP2OBPS | Log Output Buffer Pool Size (MB) | DB2WP2OBPS | INT4 | 10 | DB2INT4 | ||||
QWP2IBPS | Log input buffer pool size (in kilobytes) | DB2WP2IBPS | INT4 | 10 | DB2INT4 | ||||
QWP2ARCL | Maximum number of archive log datasets | DB2WP2ARCL | INT4 | 10 | DB2INT4 | ||||
QWP2MRTU | Maximum number of tape units for archive read | DB2WP2MRTU | INT2 | 5 | DB2SINT | ||||
QWP2WRTH | Write threshold on filled buffers | DB2WP2WRTH | INT2 | 5 | DB2SINT | ||||
QWP2DUAL | Number of active log copies | DB2WP2DUAL | CHAR | 10 | CHAR10 | ||||
QWP2ADL | The number of archive log copies | DB2WP2ADL | CHAR | 10 | CHAR10 | ||||
QWP2TWOBSDS | Dual bootstrap data set | DB2BSDSCPY | CHAR | 10 | DB2CHAR10 | ||||
QWP2ARC2FRST | Whether copy2 archive logs are read first | DB2RC2FRST | CHAR | 3 | DB2CHAR03L | ||||
QWP2DMIN | Tape volume deallocation period | DB2WP2DMS | CHAR | 11 | |||||
QWP2OFFLOAD | Whether offload is switched on | DB2OFFLOAD | CHAR | 3 | DB2CHAR03L | ||||
QWP4ID | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4LEN | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4EYE | Field type char, length 4 | DB2CHAR04 | CHAR | 4 | DB2CHAR04 | ||||
QWP4LVL | Field type char, length 8 | DB2CHAR08 | CHAR | 8 | DB2CHAR08 | ||||
QWP4MMRB | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4WREN | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4BPOF | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4MVS | Field type char, length 3 | DB2CHAR03 | CHAR | 3 | DB2CHAR03 | ||||
QWP4RES1 | Field type char, length 2, reserved | DB2RES02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4CNTL | Field type char, length 2, bit field | DB2BIT02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4EDPL | Maximum Size of the EDM Pool (MB) | DB2WP4EDPL | INT4 | 10 | DB2INT4 | ||||
QWP4IDCK | Field type char, length 1, bit field | DB2BIT01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4VCOF | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4DBOF | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4MISC | Field type char, length 1, bit field | DB2BIT01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4DFID | The authorization ID of the system default user | DB2WP4DFID | CHAR | 128 | CHAR128 | ||||
QWP4MISZ | Field type char, length 1, bit field | DB2BIT01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4AUTH | DB2 authorization | DB2WP4AUTH | CHAR | 8 | DB2CHAR08L | ||||
QWP4IPRC | Name of IRLM procedure which DB2 uses to start IRLM | DB2WP4IPRC | CHAR | 8 | CHAR8 | ||||
QWP4ISID | Name of the IRLM subsystem by which IRLM is known to MVS | DB2WP4ISID | CHAR | 4 | CHAR4 | ||||
QWP4SADM | The authorization ID of the system administrator 1 | DB2WP4SADM | CHAR | 128 | CHAR128 | ||||
QWP4RRU | UPDATE lock for repeatable read or read stability | DB2WP4RRU | CHAR | 3 | DB2CHAR03L | ||||
QWP4TOUT | Maximum time DB2 waits for the release of a locked resource | DB2WP4TOUT | INT4 | 10 | DB2INT4 | ||||
QWP4ISWT | Seconds DB2 will wait for IRLM start | DB2WP4ISWT | INT4 | 10 | DB2INT4 | ||||
QWP4MIS2 | Field type char, length 1, bit field | DB2BIT01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4ISWI | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4MSTG | Thread Storage Algorithm | DB2WPMSTG | CHAR | 9 | DB2CHAR09 | ||||
QWP4IAU | Indicates whether IRLM is started automatically by DB2 | DB2WP4IAU | CHAR | 4 | CHAR4 | ||||
QWP4RES1 | Field type char, length 2, reserved | DB2RES02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4DBC | Autostart of IRLM | DB2WP4IAUT | CHAR | 4 | CHAR4 | ||||
QWP4EDPL | Maximum Size of the EDM Pool (MB) | DB2WP4EDPL | INT4 | 10 | DB2INT4 | ||||
QWP4SWFN | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4VCOF | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4DBOF | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4SPOL | Maximum Size of the Sort Pool (MB) | DB2WP4SPOL | INT4 | 10 | DB2INT4 | ||||
QWP4DFID | The authorization ID of the system default user | DB2WP4DFID | CHAR | 128 | CHAR128 | ||||
QWP4SMXN | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4BMC1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4IPRC | Name of IRLM procedure which DB2 uses to start IRLM | DB2WP4IPRC | CHAR | 8 | CHAR8 | ||||
QWP4BMC2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4ISID | Name of the IRLM subsystem by which IRLM is known to MVS | DB2WP4ISID | CHAR | 4 | CHAR4 | ||||
QWP4SWT1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4TOUT | Maximum time DB2 waits for the release of a locked resource | DB2WP4TOUT | INT4 | 10 | DB2INT4 | ||||
QWP4ISWT | Seconds DB2 will wait for IRLM start | DB2WP4ISWT | INT4 | 10 | DB2INT4 | ||||
QWP4SWT2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DWF1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4ISWI | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4IAU | Indicates whether IRLM is started automatically by DB2 | DB2WP4IAU | CHAR | 4 | CHAR4 | ||||
QWP4DWF2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DBC | Autostart of IRLM | DB2WP4IAUT | CHAR | 4 | CHAR4 | ||||
QWP4DWU1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DWU2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SWFN | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SPOL | Maximum Size of the Sort Pool (MB) | DB2WP4SPOL | INT4 | 10 | DB2INT4 | ||||
QWP4VDWT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RES2 | Field type char, length 2, reserved | DB2RES02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4SMXN | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4BMC1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4KDSA | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4BMC2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4KDSB | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4RDEU | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SWT1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4LRUT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SWT2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DWF1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PF32 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DWF2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PFT1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DWU1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PFT2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4BBTR | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DWU2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RES3 | Field type char, length 2, reserved | DB2RES02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4VDWT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PSID | Field type char, length 4, bit field | DB2BIT04 | CHAR | 4 | DB2CHAR04 | ||||
QWP4RES2 | Field type char, length 2, reserved | DB2RES02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4DSPM | Maximum locks per table(space) before escalation | DB2WP4DSPM | INT2 | 5 | DB2SINT | ||||
QWP4KDSA | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4KDSB | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4LKTS | Maximum number of locks per tablespace | DB2WP4LKTS | INT4 | 10 | DB2INT4 | ||||
QWP4LKUS | Maximum number of locks per user | DB2WP4LKUS | INT4 | 10 | DB2INT4 | ||||
QWP4RDEU | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4ADM2 | The authorization ID of the system administrator 2 | DB2WP4ADM2 | CHAR | 128 | CHAR128 | ||||
QWP4LRUT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4OPR1 | The authorization ID of the system operator 1 | DB2WP4OPR1 | CHAR | 128 | CHAR128 | ||||
QWP4PF32 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4OPR2 | The authorization ID of the system operator 2 | DB2WP4OPR2 | CHAR | 128 | CHAR128 | ||||
QWP4PFT1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4CHKL | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PFT2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PDQ | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4BBTR | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PCBS | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RES3 | Field type char, length 2, reserved | DB2RES02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4PS4 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PSID | Field type char, length 4, bit field | DB2BIT04 | CHAR | 4 | DB2CHAR04 | ||||
QWP4DSPM | Maximum locks per table(space) before escalation | DB2WP4DSPM | INT2 | 5 | DB2SINT | ||||
QWP4PS32 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4LKTS | Maximum number of locks per tablespace | DB2WP4LKTS | INT4 | 10 | DB2INT4 | ||||
QWP4NCPU | Field type numc, length 3, 1 byte | DB2NUMC03 | NUMC | 3 | DB2NUMC03 | ||||
QWP4HRC | Field type char, length 1, reserved | DB2RES01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4LKUS | Maximum number of locks per user | DB2WP4LKUS | INT4 | 10 | DB2INT4 | ||||
QWP4ADM2 | The authorization ID of the system administrator 2 | DB2WP4ADM2 | CHAR | 128 | CHAR128 | ||||
QWP4PCWH | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4OPR1 | The authorization ID of the system operator 1 | DB2WP4OPR1 | CHAR | 128 | CHAR128 | ||||
QWP4PCRB | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4MXRB | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4OPR2 | The authorization ID of the system operator 2 | DB2WP4OPR2 | CHAR | 128 | CHAR128 | ||||
QWP4CHKL | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4HRCD | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PDQ | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RCST | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PCBS | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4TRWT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PS4 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4WPFQ | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PS32 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4WPFS | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4NCPU | Field type numc, length 3, 1 byte | DB2NUMC03 | NUMC | 3 | DB2NUMC03 | ||||
QWP4SQTM | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4HRC | Field type char, length 1, reserved | DB2RES01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4SQTD | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PCWH | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4VDTM | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PCRB | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4VDTD | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4MPFQ | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4MXRB | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4HRCD | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SWFU | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RCST | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4TISP | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4DRBS | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4TRWT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RMIN | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4WPFQ | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RMAX | Maximum size of RID pool in the DB2 subsystem | DB2WP4RMAX | NUMC | 10 | NUMC10 | ||||
QWP4WPFS | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RNLP | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SQTM | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4AUCA | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SQTD | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4INTV | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4VDTM | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4QCTM | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4VDTD | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4MPFQ | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4TDDN | Asynchronous drain start | DB2WP4DDN | INT2 | 5 | DB2SINT | ||||
QWP4MDDN | Asynchronous drain stop | DB2WP4MDDN | INT2 | 5 | DB2SINT | ||||
QWP4SWFU | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4TXS | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4TISP | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4DRBS | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4SRBT | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4AND | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4RMIN | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4OR | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4RMAX | Maximum size of RID pool in the DB2 subsystem | DB2WP4RMAX | NUMC | 10 | NUMC10 | ||||
QWP4CPUM | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4RNLP | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4FDP | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4AUCA | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4INTV | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4KNFC | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4UTO | Utility timeout factor | DB2WP4UTO | INT2 | 5 | DB2SINT | ||||
QWP4QCTM | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4EST | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4TDDN | Asynchronous drain start | DB2WP4DDN | INT2 | 5 | DB2SINT | ||||
QWP4CUT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4MDDN | Asynchronous drain stop | DB2WP4MDDN | INT2 | 5 | DB2SINT | ||||
QWP4SPC | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4TXS | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4SPS | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4SRBT | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4AND | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4AST | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4OR | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4WBMP | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4CPUM | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4WDLI | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4FDP | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4XCTH | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4BNVA | Indicates the authorities required to add a new package | DB2WP4BNVA | CHAR | 10 | CHAR10 | ||||
QWP4KNFC | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4UTO | Utility timeout factor | DB2WP4UTO | INT2 | 5 | DB2SINT | ||||
QWP4SCTM | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4EST | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4MDEG | Upper limit on the degree of parallelism | DB2WP4MDEG | INT4 | 10 | DB2INT4 | ||||
QWP4CUT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PAC | Package authorization cache | DB2WP4PAC | INT4 | 10 | DB2INT4 | ||||
QWP4SPC | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4UBS | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SPS | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4REGF | Field type char, length 1, bit field | DB2BIT01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4AST | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4REGC | Owner of the application registration table | DB2WP4REGC | CHAR | 128 | CHAR128 | ||||
QWP4REGA | Name of the application registration table | DB2WP4REGA | CHAR | 128 | CHAR128 | ||||
QWP4WBMP | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4REGO | The name of the object registration table | DB2WP4REGO | CHAR | 17 | CHAR17 | ||||
QWP4WDLI | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SIT | Indicates whether the site is local or remote | DB2WP4SIT | CHAR | 10 | DB2CHAR10L | ||||
QWP4XCTH | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4EBF | Always use EDM Best Fit Algorithm | DB2WP4EBF | CHAR | 9 | DB2CHAR09 | ||||
QWP4BNVA | Indicates the authorities required to add a new package | DB2WP4BNVA | CHAR | 10 | CHAR10 | ||||
QWP4REGN | Name of the database containing the registration tables | DB2WP4REGN | CHAR | 8 | CHAR8 | ||||
QWP4SCTM | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4KSIZ | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4MDEG | Upper limit on the degree of parallelism | DB2WP4MDEG | INT4 | 10 | DB2INT4 | ||||
QWP4IFS | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4PAC | Package authorization cache | DB2WP4PAC | INT4 | 10 | DB2INT4 | ||||
QWP4ABN | Indicates whether autobind operations are allowed | DB2WP4ABN | CHAR | 3 | DB2CHAR03L | ||||
QWP4UBS | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DXTP | Default index type | DB2WP4DXTP | NUMC | 1 | DB2NUMC1 | ||||
QWP4REGF | Field type char, length 1, bit field | DB2BIT01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4REGC | Owner of the application registration table | DB2WP4REGC | CHAR | 128 | CHAR128 | ||||
QWP4RMTI | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4ZTN | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4REGA | Name of the application registration table | DB2WP4REGA | CHAR | 128 | CHAR128 | ||||
QWP4ZUT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4REGO | The name of the object registration table | DB2WP4REGX | CHAR | 128 | CHAR128 | ||||
QWP4MDE | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4SIT | Indicates whether the site is local or remote | DB2WP4SIT | CHAR | 10 | DB2CHAR10L | ||||
QWP4EBF | Always use EDM Best Fit Algorithm | DB2WP4EBF | CHAR | 9 | DB2CHAR09 | ||||
QWP4ESC | The data definition escape character for ART and ORT search | DB2WP4ESC | CHAR | 4 | CHAR4 | ||||
QWP4CDEG | Default parallelism degree | DB2WP4CDEG | CHAR | 3 | DB2CHAR03 | ||||
QWP4REGN | Name of the database containing the registration tables | DB2WP4REGN | CHAR | 8 | CHAR8 | ||||
QWP4CDE1 | Field type char, length 1 | DB2CHAR01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4KSIZ | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4IFS | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4RES4 | Field type char, length 3, reserved | DB2RES03 | CHAR | 3 | DB2CHAR03 | ||||
QWP4ABN | Indicates whether autobind operations are allowed | DB2WP4ABN | CHAR | 3 | DB2CHAR03L | ||||
QWP4ULBZ | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4DXTP | Default index type | DB2WP4DXTP | NUMC | 1 | DB2NUMC1 | ||||
QWP4ULFR | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4RHTI | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RMTI | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4UMD | Maximum degree of utility parallelism | DB2WP4UMD | INT2 | 5 | DB2SINT | ||||
QWP4ZTN | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4ZUT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4MXKD | Maximum number of prepared dynamic statements | DB2WP4MXKD | INT4 | 10 | DB2INT4 | ||||
QWP4MDE | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4SREC | Field type char, length 2 | DB2CHAR02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4ESC | The data definition escape character for ART and ORT search | DB2WP4ESC | CHAR | 4 | CHAR4 | ||||
QWP4RES5 | Field type char, length 5 (reserved) | DB2RES05 | CHAR | 5 | DB2CHAR05 | ||||
QWP4CDEG | Default parallelism degree | DB2WP4CDEG | CHAR | 3 | DB2CHAR03 | ||||
QWP4DSFL | Field type char, length 1, reserved | DB2RES01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4CDE1 | Field type char, length 1 | DB2CHAR01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4COC1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4COC2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RES4 | Field type char, length 3, reserved | DB2RES03 | CHAR | 3 | DB2CHAR03 | ||||
QWP4DATE | Field type char, length 8 | DB2CHAR08 | CHAR | 8 | DB2CHAR08 | ||||
QWP4ULBZ | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4CDYN | Cache prepared dynamic SQL statements | DB2WP4CDYN | CHAR | 3 | DB2CHAR03L | ||||
QWP4ULFR | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4RHTI | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SCAC | Sequential mode to read cached data from a 3990 controller | DB2WP4SCAC | CHAR | 10 | |||||
QWP4UMD | Maximum degree of utility parallelism | DB2WP4UMD | INT2 | 5 | DB2SINT | ||||
QWP4WAIT | Multiplier for Determining Retained Lock Timeout | DB2WP4WAIT | INT2 | 5 | DB2SINT | ||||
QWP4RAC | Routine authorization cache size | DB2WP4RAC | INT4 | 10 | DB2INT4 | ||||
QWP4MXKD | Maximum number of prepared dynamic statements | DB2WP4MXKD | INT4 | 10 | DB2INT4 | ||||
QWP4EDDS | EDM Pool Data Space Size (MB) | DB2WP4EDDS | INT4 | 10 | DB2INT4 | ||||
QWP4SREC | Field type char, length 2 | DB2CHAR02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4DSMX | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4RES5 | Field type char, length 5 (reserved) | DB2RES05 | CHAR | 5 | DB2CHAR05 | ||||
QWP4LEM | Max. no. of language environment tokens active at any time | DB2WP4LEM | INT2 | 5 | DB2SINT | ||||
QWP4DSFL | Field type char, length 1, reserved | DB2RES01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4COC1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4CONT | Storage contraction | DB2WP4CONT | CHAR | 3 | DB2CHAR03L | ||||
QWP4COC2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4CTHR | Storage Contraction Threshold (Commits) | DB2WP4CTHR | INT2 | 5 | DB2SINT | ||||
QWP4DATE | Field type char, length 8 | DB2CHAR08 | CHAR | 8 | DB2CHAR08 | ||||
QWP4STHR | Storage Contraction Threshold (MB) | DB2WP4STHR | INT4 | 10 | DB2INT4 | ||||
QWP4CDYN | Cache prepared dynamic SQL statements | DB2WP4CDYN | CHAR | 3 | DB2CHAR03L | ||||
QWP4XLUC | Flag if X lock is used for searched update or delete | DB2WP4XLUC | CHAR | 3 | DB2CHAR03L | ||||
QWP4RCHL | If page or row locks for held cursors are released at commit | DB2WP4RCHL | CHAR | 3 | DB2CHAR03L | ||||
QWP4SCAC | Sequential mode to read cached data from a 3990 controller | DB2WP4SCAC | CHAR | 10 | |||||
QWP4DIV3 | Minimum divide scale | DB2WP4DIV3 | CHAR | 3 | DB2CHAR03L | ||||
QWP4WAIT | Multiplier for Determining Retained Lock Timeout | DB2WP4WAIT | INT2 | 5 | DB2SINT | ||||
QWP4RAC | Routine authorization cache size | DB2WP4RAC | INT4 | 10 | DB2INT4 | ||||
QWP4OJEH | Outer join performance enhancement | DB2WP4OJEH | CHAR | 3 | DB2CHAR03L | ||||
QWP4EDDS | EDM Pool Data Space Size (MB) | DB2WP4EDDS | INT4 | 10 | DB2INT4 | ||||
QWP4VCFK | VARCHAR from index | DB2WP4VCFK | CHAR | 3 | DB2CHAR03L | ||||
QWP4DSMX | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4XLUD | Whether X lock is used for searched update or delete | DB2WP4XLUD | CHAR | 6 | DB2CHAR06L | ||||
QWP4LEM | Max. no. of language environment tokens active at any time | DB2WP4LEM | INT2 | 5 | DB2SINT | ||||
QWP4PST | Utility cache option | DB2WP4PST | CHAR | 3 | DB2CHAR03L | ||||
QWP4CONT | Storage contraction | DB2WP4CONT | CHAR | 3 | DB2CHAR03L | ||||
QWP4HINT | Whether access path hints are allowed | DB2WP4HINT | CHAR | 3 | DB2CHAR03L | ||||
QWP4CDC | Whether change data capture is enabled | DB2WP4CDC | CHAR | 3 | DB2CHAR03L | ||||
QWP4CTHR | Storage Contraction Threshold (Commits) | DB2WP4CTHR | INT2 | 5 | DB2SINT | ||||
QWP4ENF | Whether DPROP is supported | DB2WP4ENF | CHAR | 3 | DB2CHAR03L | ||||
QWP4STHR | Storage Contraction Threshold (MB) | DB2WP4STHR | INT4 | 10 | DB2INT4 | ||||
QWP4ABX | Whether explain is allowed during autobind | DB2WP4ABX | CHAR | 3 | DB2CHAR03L | ||||
QWP4XLUC | Flag if X lock is used for searched update or delete | DB2WP4XLUC | CHAR | 3 | DB2CHAR03L | ||||
QWP4DSST | If an SQLDA for describe is built during bind for static SQL | DB2WP4DSST | CHAR | 3 | DB2CHAR03L | ||||
QWP4RCHL | If page or row locks for held cursors are released at commit | DB2WP4RCHL | CHAR | 3 | DB2CHAR03L | ||||
QWP4DIV3 | Minimum divide scale | DB2WP4DIV3 | CHAR | 3 | DB2CHAR03L | ||||
QWP4REGI | Whether data definition control support is to be used | DB2WP4REGI | CHAR | 3 | DB2CHAR03L | ||||
QWP4OJEH | Outer join performance enhancement | DB2WP4OJEH | CHAR | 3 | DB2CHAR03L | ||||
QWP4REGD | Whether only registered packages or plans can use DDL | DB2WP4REGD | CHAR | 3 | DB2CHAR03L | ||||
QWP4REGQ | Whether two-part names are required for objects reg. in ORT | DB2WP4REGQ | CHAR | 3 | DB2CHAR03L | ||||
QWP4VCFK | VARCHAR from index | DB2WP4VCFK | CHAR | 3 | DB2CHAR03L | ||||
QWP4REGU | Unregistered DDL default | DB2WP4REGU | CHAR | 10 | DB2CHAR10L | ||||
QWP4XLUD | Whether X lock is used for searched update or delete | DB2WP4XLUD | CHAR | 6 | DB2CHAR06L | ||||
QWP4PST | Utility cache option | DB2WP4PST | CHAR | 3 | DB2CHAR03L | ||||
QWP4SJRT | DB2 for OS/390: Star Join controls | DB2WP4SJRT | CHAR | 10 | |||||
QWP4HINT | Whether access path hints are allowed | DB2WP4HINT | CHAR | 3 | DB2CHAR03L | ||||
QWP4OPTP | Optimizer index prefetch enhancement | DB2WP4OPTP | CHAR | 8 | CHAR8 | ||||
QWP4CDC | Whether change data capture is enabled | DB2WP4CDC | CHAR | 3 | DB2CHAR03L | ||||
QWP4NPAG | NPAGES threshold for index scan | DB2WP4NPAG | INT4 | 10 | DB2INT4U | ||||
QWP4ENF | Whether DPROP is supported | DB2WP4ENF | CHAR | 3 | DB2CHAR03L | ||||
QWP4VUN | Evaluate uncommitted | DB2WP4VUN | CHAR | 8 | CHAR8 | ||||
QWP4ABX | Whether explain is allowed during autobind | DB2WP4ABX | CHAR | 3 | DB2CHAR03L | ||||
QWP4URNM | REORG FASTSWITCH | DB2WP4URNM | CHAR | 8 | CHAR8 | ||||
QWP4DSST | If an SQLDA for describe is built during bind for static SQL | DB2WP4DSST | CHAR | 3 | DB2CHAR03L | ||||
QWP4INTE | Real-time statistics interval | DB2WP4INTE | INT4 | 10 | DB2INT4U | ||||
QWP4REGI | Whether data definition control support is to be used | DB2WP4REGI | CHAR | 3 | DB2CHAR03L | ||||
QWP4SJTB | Minimum star join tables | DB2WP4SJTB | INT4 | 10 | DB2INT4U | ||||
QWP4REGD | Whether only registered packages or plans can use DDL | DB2WP4REGD | CHAR | 3 | DB2CHAR03L | ||||
QWP4STHT | Statistics history default | DB2WP4STHT | CHAR | 20 | CHAR20 | ||||
QWP4REGQ | Whether two-part names are required for objects reg. in ORT | DB2WP4REGQ | CHAR | 3 | DB2CHAR03L | ||||
QWP4STRL | Statistics rollup default | DB2WP4STRL | CHAR | 8 | CHAR8 | ||||
QWP4MXTB | Maximum joined tables | DB2WP4MXTB | INT4 | 10 | DB2INT4U | ||||
QWP4REGU | Unregistered DDL default | DB2WP4REGU | CHAR | 10 | DB2CHAR10L | ||||
QWP4EDMX | Max EDM Pool data space size (MB) | DB2WP4EDMX | INT4 | 10 | DB2INT4U | ||||
QWP4SJRT | DB2 for OS/390: Star Join controls | DB2WP4SJRT | CHAR | 10 | |||||
QWP4NLG | Active log disabled | DB2WP4NLG | CHAR | 8 | DB2CHAR8 | ||||
QWP4OPTP | Optimizer index prefetch enhancement | DB2WP4OPTP | CHAR | 8 | CHAR8 | ||||
QWP4NPAG | NPAGES threshold for index scan | DB2WP4NPAG | INT4 | 10 | DB2INT4U | ||||
QWP4PKYU | Allow partitioning key update | DB2WP4PKYU | CHAR | 8 | DB2CHAR8 | ||||
QWP4VUN | Evaluate uncommitted | DB2WP4VUN | CHAR | 8 | CHAR8 | ||||
QWP4MXCE | ZPARM SPRMMXCE: The amount of resources the Optimizer uses | 0 | |||||||
QWP4TJTH | ZPARM TABLES_JOINED_THRESHOLD | 0 | |||||||
QWP4URNM | REORG FASTSWITCH | DB2WP4URNM | CHAR | 8 | CHAR8 | ||||
QWP4INTE | Real-time statistics interval | DB2WP4INTE | INT4 | 10 | DB2INT4U | ||||
QWP4REOT | Automatically reoptimize dynamic SQL | 0 | |||||||
QWP4RRFD | ZPARM RESTORE_RECOVER_FROMDUMP | 0 | |||||||
QWP4SJTB | Minimum star join tables | DB2WP4SJTB | INT4 | 10 | DB2INT4U | ||||
QWP4SLBU | Enable system level backups as recovery base | 0 | |||||||
QWP4STHT | Statistics history default | DB2WP4STHT | CHAR | 20 | CHAR20 | ||||
QWP4RSDC | RESTORE SYSTEM dump class name | 0 | |||||||
QWP4STRL | Statistics rollup default | DB2WP4STRL | CHAR | 8 | CHAR8 | ||||
QWP4MXTB | Maximum joined tables | DB2WP4MXTB | INT4 | 10 | DB2INT4U | ||||
QWP4RSMT | RESTORE SYSTEM maximum tape units (RESTORE_TAPE_UNITS) | 0 | |||||||
QWP4EDMX | Max EDM Pool data space size (MB) | DB2WP4EDMX | INT4 | 10 | DB2INT4U | ||||
QWP4RPTC | Recover to point in time with consistency | 0 | |||||||
QWP4NLG | Active log disabled | DB2WP4NLG | CHAR | 8 | DB2CHAR8 | ||||
QWP4WFAL | Max. temp storage per agent (ZPARM MAXTEMPS) | 0 | |||||||
QWP4PKYU | Allow partitioning key update | DB2WP4PKYU | CHAR | 8 | DB2CHAR8 | ||||
QWP4STCL | Statistics clustering (ZPARM STATCLUS in DSN6SPRM) | 0 | |||||||
QWP4FRLC | ZPARM CACHEDYN_FREELOCAL | 0 | |||||||
QWP4MXCE | ZPARM SPRMMXCE: The amount of resources the Optimizer uses | 0 | |||||||
QWP4MXDC | Virtual Memory for Data Caching (ZPARM MXDTCACH) | 0 | |||||||
QWP4TJTH | ZPARM TABLES_JOINED_THRESHOLD | 0 | |||||||
QWP4REOT | Automatically reoptimize dynamic SQL | 0 | |||||||
QWP4SJMK | ZPARM SJMISSKY (PK06964) | 0 | |||||||
QWP4COS4 | ZPARM OPTCCOS4 (PK26760) | 0 | |||||||
QWP4RRFD | ZPARM RESTORE_RECOVER_FROMDUMP | 0 | |||||||
QWP4SLBU | Enable system level backups as recovery base | 0 | |||||||
QWP4RSDC | RESTORE SYSTEM dump class name | 0 | |||||||
QWP4RSMT | RESTORE SYSTEM maximum tape units (RESTORE_TAPE_UNITS) | 0 | |||||||
QWP4RPTC | Recover to point in time with consistency | 0 | |||||||
QWP4WFAL | Max. temp storage per agent (ZPARM MAXTEMPS) | 0 | |||||||
QWP4STCL | Statistics clustering (ZPARM STATCLUS in DSN6SPRM) | 0 | |||||||
QWP4FRLC | ZPARM CACHEDYN_FREELOCAL | 0 | |||||||
QWP4MXDC | Virtual Memory for Data Caching (ZPARM MXDTCACH) | 0 | |||||||
QWP4SJMK | ZPARM SJMISSKY (PK06964) | 0 | |||||||
QWP4COS4 | ZPARM OPTCCOS4 (PK26760) | 0 | |||||||
QWP4RVDPR | REVOKE dependent privileges | DB2WP4RVDPR | CHAR | 10 | |||||
QWP4SECA1_TYPE | Security Administrator 1 Type | DB2WP4SECA1_TYPE | CHAR | 10 | |||||
QWP4SECA2_TYPE | Security Administrator 2 Type | DB2WP4SECA2_TYPE | CHAR | 10 | |||||
QWP4SECA1_E | Security Admin 1 | DB2WP4SECA1 | CHAR | 128 | |||||
QWP4SECA2_E | Security Admin 2 | DB2WP4SECA2 | CHAR | 128 | |||||
QWP4SEPSD | Separate security duties | DB2WP4SEPSD | CHAR | 10 | |||||
QWP4EDBC | EDM pool: DBD cache size (ZPARM EDMDBDC) | 0 | |||||||
QWP4ESTC | EDM pool: DSC size (ZPARM EDMSTMTC) | 0 | |||||||
QWP4LRTH | Duration for long-running reader alert (ZPARM LRDRTHLD) | 0 | |||||||
QWP4MXNC | Max. number of cursors (ZPARM MAX_NUMB_CUR) | 0 | |||||||
QWP4MXOC | Max. optimizer CPU time (ZPARM MAX_OPT_CPU) | 0 | |||||||
QWP4MXOE | Max. optimizer elapsed time (ZPARM MAX_OPT_ELAP) | 0 | |||||||
QWP4MXOS | Max. optimizer storage (ZPARM MAX_OPT_STOR) | 0 | |||||||
QWP4MXSP | Max. number of stored proc. (ZPARM MAX_ST_PROC) | 0 | |||||||
QWP4PDIX | Pad indexes by default (ZPARM PADIX) | 0 | |||||||
QWP4PJSJ | Enable pair-wise join (ZPARM EN_PJSJ) | 0 | |||||||
QWP4SJXP | Star join pool (ZPARM SJMXPOOL) | 0 | |||||||
QWP4ACCU | # records for rollup of accounting records (ZPARM ACCUMACC) | 0 | |||||||
QWP4DCIX | SMS Dataclass for indexspaces | DB2CWP4DCI | CHAR | 8 | DB2CHAR08 | ||||
QWP4DCFS | SMS Dataclass for tablespaces | DB2CWP4DCF | CHAR | 8 | DB2CHAR08 | ||||
QWP4RRF | reordered row format | 0 | |||||||
QWP4CFRP | check_fastreplication | 0 | |||||||
QWP4RFRP | rec_fastreplication | 0 | |||||||
QWP4FCPPRC | flashcopy_pprc | 0 | |||||||
QWP4CCP | flashcopy_copy | 0 | |||||||
QWP4CLD | flashcopy_load | 0 | |||||||
QWP4CROT | flashcopy_reorg_ts | 0 | |||||||
QWP4RBI | flashcopy_rebuild_index | 0 | |||||||
QWP4ROI | flashcopy_reorg-index | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure DB2QWPT1 using ABAP code?
As DB2QWPT1 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 DB2QWPT1 as there is no data to select.How to access SAP table DB2QWPT1
Within an ECC or HANA version of SAP you can also view further information about DB2QWPT1 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