DB2QWP2C SAP (Installation Parameter (LOG)) Structure details

Dictionary Type: Structure
Description: Installation Parameter (LOG)




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




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

DB2QWP2C 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 Parameter (LOG)" 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_DB2QWP2C TYPE DB2QWP2C.

The DB2QWP2C table consists of various fields, each holding specific information or linking keys about Installation Parameter (LOG) data available in SAP. These include QWP2OBPS (Log Output Buffer Pool Size (MB)), QWP2IBPS (Log input buffer pool size (in kilobytes)), QWP2ARCL (Maximum number of archive log datasets), QWP2MRTU (Maximum number of tape units for archive read).. 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 DB2QWP2C 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
QWP2OPT1Active log and BSDS initialization options DB2WP2COPTCHAR20CHAR20
QWP2OBPSLog Output Buffer Pool Size (MB) DB2WP2COBPNUMC10DB2NUMC10
QWP2IBPSLog input buffer pool size (in kilobytes) DB2WP2CIBPNUMC10DB2NUMC10
QWP2ARCLMaximum number of archive log datasets DB2WP2CARCNUMC10DB2NUMC10
QWP2MRTUMaximum number of tape units for archive read DB2WP2CMRTNUMC10DB2NUMC10
QWP2WRTHWrite threshold on filled buffers DB2WP2CWRTNUMC10DB2NUMC10
QWP2DUALNumber of active log copies DB2WP2DUALCHAR10CHAR10
QWP2ADLThe number of archive log copies DB2WP2ADLCHAR10CHAR10
QWP2TWOBSDSDual bootstrap data set DB2BSDSCPYCHAR10DB2CHAR10
QWP2ARC2FRSTWhether copy2 archive logs are read first DB2RC2FRSTCHAR3DB2CHAR03L
QWP2DMINTape volume deallocation period DB2WP2DMSCHAR11
QWP2OFFLOADWhether offload is switched on DB2OFFLOADCHAR3DB2CHAR03L

Key field Non-key field



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

As DB2QWP2C 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 DB2QWP2C as there is no data to select.

How to access SAP table DB2QWP2C

Within an ECC or HANA version of SAP you can also view further information about DB2QWP2C 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!