DB2QWP4C SAP (Instrumentation Mapping for System Initialization Parameter) Structure details

Dictionary Type: Structure
Description: Instrumentation Mapping for System Initialization Parameter




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




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

DB2QWP4C 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_DB2QWP4C TYPE DB2QWP4C.

The DB2QWP4C 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 (Field type numc, length 5, short integer), QWP4EYE (Field type char, length 4), QWP4LVL (Field type char, length 8), QWP4MMRB (Field type numc, length 5, short 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: Not classified


SAP DB2QWP4C 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
QWP4IDField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4LENField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4EYEField type char, length 4 DB2CCHAR04CHAR4DB2CHAR04
QWP4LVLField type char, length 8 DB2CCHAR08CHAR8DB2CHAR08
QWP4MMRBField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4WRENField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4BPOFField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4MVSField type char, length 3 DB2CCHAR03CHAR3DB2CHAR03
QWP4CNTLField type char, length 2, bit field DB2CBIT02CHAR2DB2CHAR02
QWP4IDCKField type char, length 1, bit field DB2CBIT01CHAR1DB2CHAR01
QWP4MISCField type char, length 1, bit field DB2CBIT01CHAR1DB2CHAR01
QWP4MISZField type char, length 1, bit field DB2CBIT01CHAR1DB2CHAR01
QWP4AUTHDB2 authorization DB2CWP4AUTCHAR8DB2CHAR08L
QWP4SADMThe authorization ID of the system administrator 1 DB2CWP4SADCHAR8CHAR8
QWP4RRUUPDATE lock for repeatable read or read stability DB2CWP4RRUCHAR3DB2CHAR03L
QWP4MIS2Field type char, length 1, bit field DB2CBIT01CHAR1DB2CHAR01
QWP4RES1Field type char, length 2, reserved DB2CRES02CHAR2DB2CHAR02
QWP4EDPLMaximum Size of the EDM Pool (MB) DB2CWP4EDPNUMC10DB2NUMC10
QWP4VCOFField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4DBOFField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4DFIDThe authorization ID of the system default user DB2CWP4DFICHAR8CHAR8
QWP4IPRCName of IRLM procedure which DB2 uses to start IRLM DB2CWP4IPRCHAR8CHAR8
QWP4ISIDName of the IRLM subsystem by which IRLM is known to MVS DB2CWP4ISICHAR4CHAR4
QWP4TOUTMaximum time DB2 waits for the release of a locked resource DB2CWP4TOUNUMC10DB2NUMC10
QWP4ISWTSeconds DB2 will wait for IRLM start DB2CWP4ISWNUMC10DB2NUMC10
QWP4ISWIField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4IAUIndicates whether IRLM is started automatically by DB2 DB2CWP4IAUCHAR4CHAR4
QWP4DBCAutostart of IRLM DB2CWP4IATCHAR4CHAR4
QWP4SWFNField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4SPOLMaximum Size of the Sort Pool (MB) DB2CWP4SPOINT410DB2INT4U
QWP4SMXNField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4BMC1Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4BMC2Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4SWT1Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4SWT2Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4DWF1Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4DWF2Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4DWU1Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4DWU2Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4VDWTField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4RES2Field type char, length 2, reserved DB2CRES02CHAR2DB2CHAR02
QWP4KDSAField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4KDSBField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4RDEUField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4LRUTField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4PF32Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4PFT1Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4PFT2Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4BBTRField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4RES3Field type char, length 2, reserved DB2CRES02CHAR2DB2CHAR02
QWP4PSIDField type char, length 4, bit field DB2CBIT04CHAR4DB2CHAR04
QWP4DSPMMaximum locks per table(space) before escalation DB2CWP4DSPNUMC10DB2NUMC10
QWP4LKTSMaximum number of locks per tablespace DB2CWP4LKTNUMC10DB2NUMC10
QWP4LKUSMaximum number of locks per user DB2CWP4LKUNUMC10DB2NUMC10
QWP4ADM2The authorization ID of the system administrator 2 DB2CWP4AD2CHAR8CHAR8
QWP4OPR1The authorization ID of the system operator 1 DB2CWP4OP1CHAR8CHAR8
QWP4OPR2The authorization ID of the system operator 2 DB2CWP4OP2CHAR8CHAR8
QWP4CHKLField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4PDQField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4PCBSField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4PS4Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4PS32Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4NCPUField type numc, length 3, 1 byte DB2CNUMC03NUMC3DB2NUMC03
QWP4HRCField type char, length 1, reserved DB2CRES01CHAR1DB2CHAR01
QWP4PCWHField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4PCRBField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4MXRBField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4HRCDField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4RCSTField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4TRWTField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4WPFQField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4WPFSField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4SQTMField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4SQTDField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4VDTMField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4VDTDField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4MPFQField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4SWFUField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4TISPField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4DRBSField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4RMINField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4RMAXMaximum Size of RID Pool in the DB2 Subsystem (MB) DB2CWP4RMANUMC10NUMC10
QWP4RNLPField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4AUCAIndicates the size of the authorization cache DB2CWP4AUCNUMC10DB2NUMC10
QWP4INTVField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4QCTMField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4TDDNAsynchronous drain start DB2CWP4DDNNUMC10DB2NUMC10
QWP4MDDNAsynchronous drain stop DB2CWP4MDDNUMC10DB2NUMC10
QWP4TXSAgent local pool extension size (bytes) DB2WP4TXSNUMC10DB2NUMC10
QWP4SRBTField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4ANDField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4ORField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4CPUMField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4FDPField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4KNFCField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4UTOUtility timeout factor DB2CWP4UTONUMC6NUMC6
QWP4ESTField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4CUTField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4SPCField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4SPSField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4ASTField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4WBMPField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4WDLIField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4XCTHField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4BNVAIndicates the authorities required to add a new package DB2CWP4BNVCHAR10CHAR10
QWP4SCTMField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4MDEGField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4PACPackage authorization cache DB2CWP4PACNUMC10DB2NUMC10
QWP4UBSField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4REGFField type char, length 1, bit field DB2CBIT01CHAR1DB2CHAR01
QWP4REGCOwner of the application registration table DB2CWP4REGCHAR8CHAR8
QWP4REGAName of the application registration table DB2CWP4REACHAR17CHAR17
QWP4REGOThe name of the object registration table DB2CWP4REOCHAR17CHAR17
QWP4SITIndicates Whether the Site is Local or Remote DB2CWP4SITCHAR10DB2CHAR10L
QWP4REGNName of the database containing the registration tables DB2CWP4RENCHAR8CHAR8
QWP4KSIZField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4IFSField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4ABNIndicates whether autobind operations are allowed DB2CWP4ABNCHAR3DB2CHAR03L
QWP4DXTPDefault index type DB2CWP4DXTNUMC10DB2NUMC10
QWP4RMTIField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4ZTNField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4ZUTField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4MDEField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4ESCThe data definition escape character for ART and ORT search DB2CWP4ESCCHAR4CHAR4
QWP4CDEGDefault Parallelism Degree DB2CWP4CDECHAR3DB2CHAR03
QWP4CDE1Field type char, length 1 DB2CCHAR01CHAR1DB2CHAR01
QWP4RES4Field type char, length 3, reserved DB2CRES03CHAR3DB2CHAR03
QWP4ULBZField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4ULFRField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4RHTIField type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4UMDMaximum degree of utility parallelism DB2CWP4UMDNUMC10DB2NUMC10
QWP4MXKDMaximum number of prepared dynamic statements DB2CWP4MXKNUMC10DB2NUMC10
QWP4SRECField type char, length 2 DB2CCHAR02CHAR2DB2CHAR02
QWP4RES5Character field of length 5 (reserved) DB2CRES05CHAR5DB2CHAR05
QWP4DSFLField type char, length 1, reserved DB2CRES01CHAR1DB2CHAR01
QWP4COC1Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4COC2Field type numc, length 5, short integer DB2CNUMC05NUMC5DB2NUMC05
QWP4DATEField type char, length 8 DB2CCHAR08CHAR8DB2CHAR08
QWP4CDYNCache prepared dynamic SQL statements DB2CWP4CDYCHAR3DB2CHAR03L
QWP4SCACSequential Mode to Read Cached Data from a 3990 Controller DB2CWP4SCACHAR10
QWP4WAITMultiplier for Determining Retained Lock Timeout DB2CWP4WAINUMC5DB2NUMC05
QWP4RACRoutine authorization cache size DB2CWP4RACNUMC10DB2NUMC10
QWP4EDDSEDM Pool Data Space Size (MB) DB2CWP4EDDNUMC10DB2NUMC10
QWP4DSMXField type numc, length 10, integer DB2CNUMC10NUMC10DB2NUMC10
QWP4LEMMax. no. of language environment tokens active at any time DB2CWP4LEMNUMC5DB2NUMC05
QWP4CONTStorage Contraction DB2CWP4CONCHAR3DB2CHAR03L
QWP4CTHRStorage Contraction Threshold (Commits) DB2CWP4CTHNUMC5DB2NUMC05
QWP4STHRStorage Contraction Threshold (MB) DB2CWP4STHNUMC10DB2NUMC10
QWP4XLUCFlag if X lock is Used for Searched Update or Delete DB2CWP4XLUCHAR3DB2CHAR03L
QWP4RCHLIf Page or Row Locks for Held Cursors are Released at Commit DB2CWP4RCHCHAR3DB2CHAR03L
QWP4DIV3Minimum Divide Scale DB2CWP4DI3CHAR3DB2CHAR03L
QWP4OJEHOuter Join Performance Enhancement DB2CWP4OJECHAR3DB2CHAR03L
QWP4VCFKVARCHAR from Index DB2CWP4VCFCHAR3DB2CHAR03L
QWP4XLUDWhether X lock is Used for Searched Update or Delete DB2CWP4XLDCHAR6DB2CHAR06L
QWP4PSTUtility Cache Option DB2CWP4PSTCHAR3DB2CHAR03L
QWP4HINTIndicates Whether Access Path Hints are Allowed DB2CWP4HINCHAR3DB2CHAR03L
QWP4CDCIndicates Whether Change Data Capture is Enabled DB2CWP4CDCHAR3DB2CHAR03L
QWP4ENFIndicates Whether DPROP is Supported DB2CWP4ENFCHAR3DB2CHAR03L
QWP4ABXIndicates Whether Explain is Allowed During Autobind DB2CWP4ABXCHAR3DB2CHAR03L
QWP4DSSTIf an SQLDA for Describe is Built During Bind for Static SQL DB2CWP4DSSCHAR3DB2CHAR03L
QWP4REGIWhether Data Definition Control Support is to Be Used DB2CWP4REICHAR3DB2CHAR03L
QWP4REGDWhether Only Registered Packages or Plans Can Use DDL DB2CWP4REDCHAR3DB2CHAR03L
QWP4REGQWhether Two-Part Names are Required for Objects Reg. in ORT DB2CWP4REQCHAR3DB2CHAR03L
QWP4REGUUnregistered DDL Default DB2CWP4REUCHAR10DB2CHAR10L
QWP4NPAGNPAGES threshold for index scan DB2CWP4NPANUMC5DB2NUMC05
QWP4DCFSSMS Dataclass for tablespaces DB2CWP4DCFCHAR8DB2CHAR08
QWP4DCIXSMS Dataclass for indexspaces DB2CWP4DCICHAR8DB2CHAR08
QWP4HOPHop site authorization DB2CWP4HOPCHAR10DB2CHAR10
QWP4EBFDB2 for OS/390: EDM Pool Algorithm DB2WP4EDMCHAR10DB2CHAR10
QWP4SJRTDB2 for OS/390: Star Join controls DB2WP4SJRCCHAR10

Key field Non-key field



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

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

How to access SAP table DB2QWP4C

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