DB2QWP4 SAP (Instrumentation Mapping for System Initialization Parameter) Structure details
Description: Instrumentation Mapping for System Initialization Parameter
Structure field list including key, data, relationships and ABAP select examples
DB2QWP4 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 "Instrumentation Mapping for System Initialization Parameter" 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_DB2QWP4 TYPE DB2QWP4.
The DB2QWP4 table consists of various fields, each holding specific information or linking keys about Instrumentation Mapping for System Initialization Parameter data available in SAP. These include QWP4LEN (Small integer), QWP4EYE (Field type char, length 4), QWP4LVL (Field type char, length 8), QWP4MMRB (Small integer).. 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 DB2QWP4 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 |
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 | ||||
QWP4CNTL | Field type char, length 2, bit field | DB2BIT02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4IDCK | Field type char, length 1, bit field | DB2BIT01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4MISC | Field type char, length 1, bit field | DB2BIT01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4MISZ | Field type char, length 1, bit field | DB2BIT01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4AUTH | DB2 authorization | DB2WP4AUTH | CHAR | 8 | DB2CHAR08L | ||||
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 | ||||
QWP4MIS2 | Field type char, length 1, bit field | DB2BIT01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4MSTG | Thread Storage Algorithm | DB2WPMSTG | CHAR | 9 | DB2CHAR09 | ||||
QWP4RES1 | Field type char, length 2, reserved | DB2RES02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4EDPL | Maximum Size of the EDM Pool (MB) | DB2WP4EDPL | INT4 | 10 | DB2INT4 | ||||
QWP4VCOF | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4DBOF | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4DFID | The authorization ID of the system default user | DB2WP4DFID | CHAR | 128 | CHAR128 | ||||
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 | ||||
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 | ||||
QWP4ISWI | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4IAU | Indicates whether IRLM is started automatically by DB2 | DB2WP4IAU | CHAR | 4 | CHAR4 | ||||
QWP4DBC | Autostart of IRLM | DB2WP4IAUT | CHAR | 4 | CHAR4 | ||||
QWP4SWFN | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SPOL | Maximum Size of the Sort Pool (MB) | DB2WP4SPOL | INT4 | 10 | DB2INT4 | ||||
QWP4SMXN | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4BMC1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4BMC2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SWT1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SWT2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DWF1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DWF2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DWU1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DWU2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4VDWT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RES2 | Field type char, length 2, reserved | DB2RES02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4KDSA | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4KDSB | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4RDEU | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4LRUT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PF32 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PFT1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PFT2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4BBTR | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RES3 | Field type char, length 2, reserved | DB2RES02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4PSID | Field type char, length 4, bit field | DB2BIT04 | CHAR | 4 | DB2CHAR04 | ||||
QWP4DSPM | Maximum locks per table(space) before escalation | DB2WP4DSPM | INT2 | 5 | DB2SINT | ||||
QWP4LKTS | Maximum number of locks per tablespace | DB2WP4LKTS | INT4 | 10 | DB2INT4 | ||||
QWP4LKUS | Maximum number of locks per user | DB2WP4LKUS | INT4 | 10 | DB2INT4 | ||||
QWP4ADM2 | The authorization ID of the system administrator 2 | DB2WP4ADM2 | CHAR | 128 | CHAR128 | ||||
QWP4OPR1 | The authorization ID of the system operator 1 | DB2WP4OPR1 | CHAR | 128 | CHAR128 | ||||
QWP4OPR2 | The authorization ID of the system operator 2 | DB2WP4OPR2 | CHAR | 128 | CHAR128 | ||||
QWP4CHKL | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PDQ | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PCBS | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PS4 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PS32 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4NCPU | Field type numc, length 3, 1 byte | DB2NUMC03 | NUMC | 3 | DB2NUMC03 | ||||
QWP4HRC | Field type char, length 1, reserved | DB2RES01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4PCWH | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4PCRB | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4MXRB | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4HRCD | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4RCST | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4TRWT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4WPFQ | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4WPFS | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SQTM | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SQTD | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4VDTM | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4VDTD | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4MPFQ | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SWFU | 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 | ||||
QWP4RMIN | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4RMAX | Maximum size of RID pool in the DB2 subsystem | DB2WP4RMAX | NUMC | 10 | NUMC10 | ||||
QWP4RNLP | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4AUCA | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4INTV | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4QCTM | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4TDDN | Asynchronous drain start | DB2WP4DDN | INT2 | 5 | DB2SINT | ||||
QWP4MDDN | Asynchronous drain stop | DB2WP4MDDN | INT2 | 5 | DB2SINT | ||||
QWP4TXS | 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 | ||||
QWP4OR | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4CPUM | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4FDP | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4KNFC | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4UTO | Utility timeout factor | DB2WP4UTO | INT2 | 5 | DB2SINT | ||||
QWP4EST | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4CUT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4SPC | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4SPS | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4AST | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4WBMP | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4WDLI | 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 | ||||
QWP4SCTM | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4MDEG | Upper limit on the degree of parallelism | DB2WP4MDEG | INT4 | 10 | DB2INT4 | ||||
QWP4PAC | Package authorization cache | DB2WP4PAC | INT4 | 10 | DB2INT4 | ||||
QWP4UBS | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4REGF | Field type char, length 1, bit field | DB2BIT01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4REGC | Owner of the application registration table | DB2WP4REGC | CHAR | 128 | CHAR128 | ||||
QWP4REGA | Name of the application registration table | DB2WP4REGA | CHAR | 128 | CHAR128 | ||||
QWP4REGO | The name of the object registration table | DB2WP4REGX | CHAR | 128 | CHAR128 | ||||
QWP4SIT | Indicates whether the site is local or remote | DB2WP4SIT | CHAR | 10 | DB2CHAR10L | ||||
QWP4EBF | Always use EDM Best Fit Algorithm | DB2WP4EBF | CHAR | 9 | DB2CHAR09 | ||||
QWP4REGN | Name of the database containing the registration tables | DB2WP4REGN | CHAR | 8 | CHAR8 | ||||
QWP4KSIZ | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4IFS | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4ABN | Indicates whether autobind operations are allowed | DB2WP4ABN | CHAR | 3 | DB2CHAR03L | ||||
QWP4DXTP | Default index type | DB2WP4DXTP | NUMC | 1 | DB2NUMC1 | ||||
QWP4RMTI | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4ZTN | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4ZUT | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4MDE | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4ESC | The data definition escape character for ART and ORT search | DB2WP4ESC | CHAR | 4 | CHAR4 | ||||
QWP4CDEG | Default parallelism degree | DB2WP4CDEG | CHAR | 3 | DB2CHAR03 | ||||
QWP4CDE1 | Field type char, length 1 | DB2CHAR01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4RES4 | Field type char, length 3, reserved | DB2RES03 | CHAR | 3 | DB2CHAR03 | ||||
QWP4ULBZ | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4ULFR | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4RHTI | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4UMD | Maximum degree of utility parallelism | DB2WP4UMD | INT2 | 5 | DB2SINT | ||||
QWP4MXKD | Maximum number of prepared dynamic statements | DB2WP4MXKD | INT4 | 10 | DB2INT4 | ||||
QWP4SREC | Field type char, length 2 | DB2CHAR02 | CHAR | 2 | DB2CHAR02 | ||||
QWP4RES5 | Field type char, length 5 (reserved) | DB2RES05 | CHAR | 5 | DB2CHAR05 | ||||
QWP4DSFL | Field type char, length 1, reserved | DB2RES01 | CHAR | 1 | DB2CHAR01 | ||||
QWP4COC1 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4COC2 | Small integer | DB2INT2AA | INT2 | 5 | DB2SINT | ||||
QWP4DATE | Field type char, length 8 | DB2CHAR08 | CHAR | 8 | DB2CHAR08 | ||||
QWP4CDYN | Cache prepared dynamic SQL statements | DB2WP4CDYN | CHAR | 3 | DB2CHAR03L | ||||
QWP4SCAC | Sequential mode to read cached data from a 3990 controller | DB2WP4SCAC | CHAR | 10 | |||||
QWP4WAIT | Multiplier for Determining Retained Lock Timeout | DB2WP4WAIT | INT2 | 5 | DB2SINT | ||||
QWP4RAC | Routine authorization cache size | DB2WP4RAC | INT4 | 10 | DB2INT4 | ||||
QWP4EDDS | EDM Pool Data Space Size (MB) | DB2WP4EDDS | INT4 | 10 | DB2INT4 | ||||
QWP4DSMX | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QWP4LEM | Max. no. of language environment tokens active at any time | DB2WP4LEM | INT2 | 5 | DB2SINT | ||||
QWP4CONT | Storage contraction | DB2WP4CONT | CHAR | 3 | DB2CHAR03L | ||||
QWP4CTHR | Storage Contraction Threshold (Commits) | DB2WP4CTHR | INT2 | 5 | DB2SINT | ||||
QWP4STHR | Storage Contraction Threshold (MB) | DB2WP4STHR | INT4 | 10 | DB2INT4 | ||||
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 | ||||
QWP4DIV3 | Minimum divide scale | DB2WP4DIV3 | CHAR | 3 | DB2CHAR03L | ||||
QWP4OJEH | Outer join performance enhancement | DB2WP4OJEH | CHAR | 3 | DB2CHAR03L | ||||
QWP4VCFK | VARCHAR from index | DB2WP4VCFK | CHAR | 3 | DB2CHAR03L | ||||
QWP4XLUD | Whether X lock is used for searched update or delete | DB2WP4XLUD | CHAR | 6 | DB2CHAR06L | ||||
QWP4PST | Utility cache option | DB2WP4PST | 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 | ||||
QWP4ENF | Whether DPROP is supported | DB2WP4ENF | CHAR | 3 | DB2CHAR03L | ||||
QWP4ABX | Whether explain is allowed during autobind | DB2WP4ABX | CHAR | 3 | DB2CHAR03L | ||||
QWP4DSST | If an SQLDA for describe is built during bind for static SQL | DB2WP4DSST | CHAR | 3 | DB2CHAR03L | ||||
QWP4REGI | Whether data definition control support is to be used | DB2WP4REGI | 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 | ||||
QWP4REGU | Unregistered DDL default | DB2WP4REGU | CHAR | 10 | DB2CHAR10L | ||||
QWP4SJRT | DB2 for OS/390: Star Join controls | DB2WP4SJRT | CHAR | 10 | |||||
QWP4OPTP | Optimizer index prefetch enhancement | DB2WP4OPTP | CHAR | 8 | CHAR8 | ||||
QWP4NPAG | NPAGES threshold for index scan | DB2WP4NPAG | INT4 | 10 | DB2INT4U | ||||
QWP4VUN | Evaluate uncommitted | DB2WP4VUN | CHAR | 8 | CHAR8 | ||||
QWP4URNM | REORG FASTSWITCH | DB2WP4URNM | CHAR | 8 | CHAR8 | ||||
QWP4INTE | Real-time statistics interval | DB2WP4INTE | INT4 | 10 | DB2INT4U | ||||
QWP4SJTB | Minimum star join tables | DB2WP4SJTB | INT4 | 10 | DB2INT4U | ||||
QWP4STHT | Statistics history default | DB2WP4STHT | CHAR | 20 | CHAR20 | ||||
QWP4STRL | Statistics rollup default | DB2WP4STRL | CHAR | 8 | CHAR8 | ||||
QWP4MXTB | Maximum joined tables | DB2WP4MXTB | INT4 | 10 | DB2INT4U | ||||
QWP4EDMX | Max EDM Pool data space size (MB) | DB2WP4EDMX | INT4 | 10 | DB2INT4U | ||||
QWP4NLG | Active log disabled | DB2WP4NLG | CHAR | 8 | DB2CHAR8 | ||||
QWP4PKYU | Allow partitioning key update | DB2WP4PKYU | CHAR | 8 | DB2CHAR8 | ||||
QWP4MXCE | ZPARM SPRMMXCE: The amount of resources the Optimizer uses | 0 | |||||||
QWP4TJTH | ZPARM TABLES_JOINED_THRESHOLD | 0 | |||||||
QWP4REOT | Automatically reoptimize dynamic SQL | 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 DB2QWP4 using ABAP code?
As DB2QWP4 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 DB2QWP4 as there is no data to select.How to access SAP table DB2QWP4
Within an ECC or HANA version of SAP you can also view further information about DB2QWP4 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