DB2QWP1C SAP (Installation Parameters (DSN6SYSP)) Structure details
Description: Installation Parameters (DSN6SYSP)
Structure field list including key, data, relationships and ABAP select examples
DB2QWP1C 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 "Installation Parameters (DSN6SYSP)" 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_DB2QWP1C TYPE DB2QWP1C.
The DB2QWP1C table consists of various fields, each holding specific information or linking keys about Installation Parameters (DSN6SYSP) data available in SAP. These include QWP1RLF (Resource limit facility automatic start), QWP1TRSZ (Size of resident trace table (multiple of 4K)), QWP1LOGL (Number of log records written between checkpoints), QWP1IDB (Maximum number of concurrent connections from batch job).. 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: Not classified
SAP DB2QWP1C 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 |
QWP1SMRC | The individual write-to-operator routing codes started | DB2WP1CSMR | CHAR | 38 | |||||
QWP1RLF | Resource limit facility automatic start | DB2WP1CRLF | CHAR | 3 | DB2CHAR03L | ||||
QWP1TRSZ | Size of resident trace table (multiple of 4K) | DB2WP1CTRS | NUMC | 10 | DB2NUMC10 | ||||
QWP1LOGL | Number of log records written between checkpoints | DB2WP1CLOG | NUMC | 10 | DB2NUMC10 | ||||
QWP1IDB | Maximum number of concurrent connections from batch job | DB2WP1CIDB | NUMC | 10 | DB2NUMC10 | ||||
QWP1IDF | Maximum number of concurrent TSO foreground connections | DB2WP1CIDF | NUMC | 10 | DB2NUMC10 | ||||
QWP1CT | The maximum number of concurrent allied threads | DB2WP1CCT | NUMC | 10 | DB2NUMC10 | ||||
QWP1RMT | Maximum number of database access threads | DB2WP1CRMT | NUMC | 10 | DB2NUMC10 | ||||
QWP1LVL | Used to detect parameters and code that are out of sync | DB2WP1CLVL | NUMC | 10 | DB2NUMC10 | ||||
QWP1DTIM | Time Interval Before DB2 Resets Data Set Statistics (Min.) | DB2WP1CDTI | NUMC | 5 | DB2NUMC05 | ||||
QWP1DB1M | Amount of space reserved for MVS functions | DB2WP1CDB1 | NUMC | 10 | DB2NUMC10 | ||||
QWP1CRIT | Amount of space reserved for critical work | DB2WP1CCRI | NUMC | 10 | DB2NUMC10 | ||||
QWP1SOS | Amount of space above MVS and critical space | DB2QWP1CSO | NUMC | 10 | DB2NUMC10 | ||||
QWP1STIM | Time interval (in minutes) between statistics collection | DB2WP1CSTI | NUMC | 10 | DB2NUMC10 | ||||
QWP1DBPR | Database protocol for 3-part names | DB2WP1CDBP | CHAR | 8 | DB2CHAR08 | ||||
QWP1TRST | The GLOBAL TRACE Classes Started | DB2WP1CTRT | CHAR | 90 | DB2CHAR90 | ||||
QWP1SMFS | The SMF STATISTICS TRACE Classes Started | DB2WP1CSMF | CHAR | 90 | DB2CHAR90 | ||||
QWP1SMFA | The SMF ACCOUNTING TRACE Classes Started | DB2WP1CSMA | CHAR | 90 | DB2CHAR90 | ||||
QWP1AUDT | The AUDIT TRACE classes started | DB2WP1CAUD | CHAR | 90 | DB2CHAR90 | ||||
QWP1RLFA | Authorization ID of the resource limit specification table | DB2WP1CRLA | CHAR | 8 | DB2CHAR08 | ||||
QWP1RLFT | Resource limit specification table ID | DB2WP1CRLT | CHAR | 4 | DB2CHAR04 | ||||
QWP1RLFR | FLAGS (ONE BYTE, USED AS BITS 1-8) | DB2WP1CRLR | RAW | 1 | DB2RAW01 | ||||
QWP1RLFN | Resource limit specification table error action | DB2WP1CRLN | NUMC | 10 | DB2NUMC10 | ||||
QWP1MON | Monitor tracing start options | DB2WP1CMON | CHAR | 9 | DB2CHAR09 | ||||
QWP1MONS | Monitor Buffer Size (KB) | DB2WP1CMOS | NUMC | 10 | DB2NUMC10 | ||||
QWP1FREQ | Pseudo-close frequency | DB2WP1CFRE | NUMC | 10 | DB2NUMC10 | ||||
QWP1TMR | Pseudo-close time | DB2WP1CTMR | NUMC | 10 | DB2NUMC10 | ||||
QWP1DFRQ | Number of checkpoints | DB2WP1CDFR | CHAR | 10 | |||||
QWP1SPPN | Name of JCL procedure used to start DB2 address space | DB2WP1CSPP | CHAR | 10 | DB2CHAR10 | ||||
QWP1SPAB | Number of abends allowed for a stored procedure | DB2WP1CSPA | NUMC | 10 | DB2NUMC10 | ||||
QWP1SPTO | Stored procedure timeout value | DB2WP1CSPT | NUMC | 10 | DB2NUMC10 | ||||
QWP1SCER | Extended security | DB2WP1CSCE | CHAR | 4 | DB2CHAR04 | ||||
QWP1URCK | UR Checkpoint Frequency | DB2WP1CURC | NUMC | 10 | DB2NUMC10 | ||||
QWP1FLBZ | Maximum DSN1DBM1 Storage for Fast Log Apply (MB) | DB2WP1CFLB | NUMC | 10 | DB2NUMC10 | ||||
QWP1TBPL | Default buffer pool for user tablespaces | DB2WP1CTBP | CHAR | 8 | DB2BPNAME | ||||
QWP1IXPL | Default buffer pool for user indexspaces | DB2WP1CIXP | CHAR | 8 | DB2BPNAME | ||||
QWP1WLME | Default WLM environment for user-defined functions/stoprocs | DB2WP1CWLM | CHAR | 18 | DB2CHAR18 | ||||
QWP1LMBO | Whether DB2 Postpones Backward Log Processing During Restart | DB2WP1CLMB | CHAR | 4 | DB2CHAR04L | ||||
QWP1BDUR | Restart backout limit | DB2WP1CBDU | NUMC | 5 | DB2NUMC05 | ||||
QWP1EXBR | Maximum number of extra DRDA query blocks for DB2 requester | DB2WP1CEXB | NUMC | 5 | DB2NUMC05 | ||||
QWP1EXBS | Maximum number of extra DRDA query blocks for DB2 server | DB2WP1CEXS | NUMC | 5 | DB2NUMC05 | ||||
QWP1LVA | Max. number of KB that a user can use to store lob values | DB2WP1CLVA | NUMC | 10 | DB2NUMC10 | ||||
QWP1LVS | Max. number of MB a subsystem can use to store lob values | DB2WP1CLVS | NUMC | 10 | DB2NUMC10 | ||||
QWP1CDB | Maximum number of connected remote threads | DB2WP1CCDB | NUMC | 10 | DB2NUMC10 | ||||
QWP1PROL | Indicates Whether Accounting Records Should Be Rolled Up | DB2WP1CPRO | CHAR | 3 | DB2CHAR03L | ||||
QWP1TLSZ | Size of the Local Trace Tables in Multiples of 4 KB | DB2WP1CTLS | NUMC | 5 | DB2NUMC05 |
Key field | Non-key field |
How do I retrieve data from SAP structure DB2QWP1C using ABAP code?
As DB2QWP1C 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 DB2QWP1C as there is no data to select.How to access SAP table DB2QWP1C
Within an ECC or HANA version of SAP you can also view further information about DB2QWP1C 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