DB2QWP3 SAP (DB2/OS390 Installation Parameter (Archive)) Structure details

Dictionary Type: Structure
Description: DB2/OS390 Installation Parameter (Archive)




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




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

DB2QWP3 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/OS390 Installation Parameter (Archive)" 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_DB2QWP3 TYPE DB2QWP3.

The DB2QWP3 table consists of various fields, each holding specific information or linking keys about DB2/OS390 Installation Parameter (Archive) data available in SAP. These include QWP3RISP (Primary space allocation), QWP3SECS (Secondary space allocation), QWP3UNT1 (The type of device for COPY1 archive logs), QWP3RE1N (DSN prefix character string for copy-1 archive log dataset).. 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 DB2QWP3 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
QWP3BKSZThe block size of the archive log data sets DB2WP3BKSZINT410DB2INT4
QWP3RISPPrimary space allocation DB2WP3RISPINT410DB2INT4
QWP3SECSSecondary space allocation DB2WP3SECSINT410DB2INT4
QWP3UNT1The type of device for COPY1 archive logs DB2WP3UNT1CHAR10CHAR10
QWP3RE1NDSN prefix character string for copy-1 archive log dataset DB2WP3RE1NCHAR20CHAR20
QWP3UNT2The type of device for COPY2 archive logs DB2WP3UNT2CHAR10CHAR10
QWP3RE2NDSN prefix character string for copy-2 archive log dataset DB2WP3RE2NCHAR20CHAR20
QWP3CTLGWhether the archive datasets are cataloged in the IFC DB2WP3CTLGCHAR4
QWP3UNITDevice type to which the archive log sets are written DB2WP3UNITCHAR10CHAR10
QWP3MSV1Mass storage system volume group 1 name DB2WP3MSV1CHAR10DB2CHAR10L
SPACEALLOCThe unit used in allocating archive datasets DB2SPACEUNCHAR10CHAR10
QWP3MSV2Mass storage system volume group 2 name DB2WP3MSV2CHAR10DB2CHAR10L
QWP3RETNNumber of days the archive log data sets are to be retained DB2WP3RETNINT25DB2SINT
QWP3DTIMIndicates whether a timestamp is inserted in log datasets DB2WP3DTIMCHAR3DB2CHAR03L
QWP3MQPMaximum time for DB2 to attempt a full system quiesce DB2WP3MQPINT25DB2SINT
QWP3ALCUThe unit used in allocating archive datasets DB2WP3ALCUCHAR10DB2CHAR10L
QWP3WTORIssue WTOR before archive mounts DB2WP3WTORCHAR3DB2CHAR03L
QWP3COMPForce data compaction DB2WP3COMPCHAR3DB2CHAR03L
QWP3RTCTArchive logs RACF protection DB2WP3RTCTCHAR3DB2CHAR03L

Key field Non-key field



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

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

How to access SAP table DB2QWP3

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