SAP ABAP Table DB2QWP4 (Instrumentation Mapping for System Initialization Parameter)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-DB2 (Application Component) DB2 for z/OS
     STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Table Category INTTAB    Structure 
Structure DB2QWP4   Table Relationship Diagram
Short Description Instrumentation Mapping for System Initialization Parameter    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 QWP4ID DB2INT2AA DB2SINT INT2 5   0   Small integer  
2 QWP4LEN DB2INT2AA DB2SINT INT2 5   0   Small integer  
3 QWP4EYE DB2CHAR04 DB2CHAR04 CHAR 4   0   Field type char, length 4  
4 QWP4LVL DB2CHAR08 DB2CHAR08 CHAR 8   0   Field type char, length 8  
5 QWP4MMRB DB2INT2AA DB2SINT INT2 5   0   Small integer  
6 QWP4WREN DB2INT2AA DB2SINT INT2 5   0   Small integer  
7 QWP4BPOF DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
8 QWP4MVS DB2CHAR03 DB2CHAR03 CHAR 3   0   Field type char, length 3  
9 QWP4CNTL DB2BIT02 DB2CHAR02 CHAR 2   0   Field type char, length 2, bit field  
10 QWP4IDCK DB2BIT01 DB2CHAR01 CHAR 1   0   Field type char, length 1, bit field  
11 QWP4MISC DB2BIT01 DB2CHAR01 CHAR 1   0   Field type char, length 1, bit field  
12 QWP4MISZ DB2BIT01 DB2CHAR01 CHAR 1   0   Field type char, length 1, bit field  
13 QWP4AUTH DB2WP4AUTH DB2CHAR08L CHAR 8   0   DB2 authorization  
14 QWP4SADM DB2WP4SADM CHAR128 CHAR 128   0   The authorization ID of the system administrator 1  
15 QWP4RRU DB2WP4RRU DB2CHAR03L CHAR 3   0   UPDATE lock for repeatable read or read stability  
16 QWP4MIS2 DB2BIT01 DB2CHAR01 CHAR 1   0   Field type char, length 1, bit field  
17 QWP4MSTG DB2WPMSTG DB2CHAR09 CHAR 9   0   Thread Storage Algorithm  
18 QWP4RES1 DB2RES02 DB2CHAR02 CHAR 2   0   Field type char, length 2, reserved  
19 QWP4EDPL DB2WP4EDPL DB2INT4 INT4 10   0   Maximum Size of the EDM Pool (MB)  
20 QWP4VCOF DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
21 QWP4DBOF DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
22 QWP4DFID DB2WP4DFID CHAR128 CHAR 128   0   The authorization ID of the system default user  
23 QWP4IPRC DB2WP4IPRC CHAR8 CHAR 8   0   Name of IRLM procedure which DB2 uses to start IRLM  
24 QWP4ISID DB2WP4ISID CHAR4 CHAR 4   0   Name of the IRLM subsystem by which IRLM is known to MVS  
25 QWP4TOUT DB2WP4TOUT DB2INT4 INT4 10   0   Maximum time DB2 waits for the release of a locked resource  
26 QWP4ISWT DB2WP4ISWT DB2INT4 INT4 10   0   Seconds DB2 will wait for IRLM start  
27 QWP4ISWI DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
28 QWP4IAU DB2WP4IAU CHAR4 CHAR 4   0   Indicates whether IRLM is started automatically by DB2  
29 QWP4DBC DB2WP4IAUT CHAR4 CHAR 4   0   Autostart of IRLM  
30 QWP4SWFN DB2INT2AA DB2SINT INT2 5   0   Small integer  
31 QWP4SPOL DB2WP4SPOL DB2INT4 INT4 10   0   Maximum Size of the Sort Pool (MB)  
32 QWP4SMXN DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
33 QWP4BMC1 DB2INT2AA DB2SINT INT2 5   0   Small integer  
34 QWP4BMC2 DB2INT2AA DB2SINT INT2 5   0   Small integer  
35 QWP4SWT1 DB2INT2AA DB2SINT INT2 5   0   Small integer  
36 QWP4SWT2 DB2INT2AA DB2SINT INT2 5   0   Small integer  
37 QWP4DWF1 DB2INT2AA DB2SINT INT2 5   0   Small integer  
38 QWP4DWF2 DB2INT2AA DB2SINT INT2 5   0   Small integer  
39 QWP4DWU1 DB2INT2AA DB2SINT INT2 5   0   Small integer  
40 QWP4DWU2 DB2INT2AA DB2SINT INT2 5   0   Small integer  
41 QWP4VDWT DB2INT2AA DB2SINT INT2 5   0   Small integer  
42 QWP4RES2 DB2RES02 DB2CHAR02 CHAR 2   0   Field type char, length 2, reserved  
43 QWP4KDSA DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
44 QWP4KDSB DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
45 QWP4RDEU DB2INT2AA DB2SINT INT2 5   0   Small integer  
46 QWP4LRUT DB2INT2AA DB2SINT INT2 5   0   Small integer  
47 QWP4PF32 DB2INT2AA DB2SINT INT2 5   0   Small integer  
48 QWP4PFT1 DB2INT2AA DB2SINT INT2 5   0   Small integer  
49 QWP4PFT2 DB2INT2AA DB2SINT INT2 5   0   Small integer  
50 QWP4BBTR DB2INT2AA DB2SINT INT2 5   0   Small integer  
51 QWP4RES3 DB2RES02 DB2CHAR02 CHAR 2   0   Field type char, length 2, reserved  
52 QWP4PSID DB2BIT04 DB2CHAR04 CHAR 4   0   Field type char, length 4, bit field  
53 QWP4DSPM DB2WP4DSPM DB2SINT INT2 5   0   Maximum locks per table(space) before escalation  
54 QWP4LKTS DB2WP4LKTS DB2INT4 INT4 10   0   Maximum number of locks per tablespace  
55 QWP4LKUS DB2WP4LKUS DB2INT4 INT4 10   0   Maximum number of locks per user  
56 QWP4ADM2 DB2WP4ADM2 CHAR128 CHAR 128   0   The authorization ID of the system administrator 2  
57 QWP4OPR1 DB2WP4OPR1 CHAR128 CHAR 128   0   The authorization ID of the system operator 1  
58 QWP4OPR2 DB2WP4OPR2 CHAR128 CHAR 128   0   The authorization ID of the system operator 2  
59 QWP4CHKL DB2INT2AA DB2SINT INT2 5   0   Small integer  
60 QWP4PDQ DB2INT2AA DB2SINT INT2 5   0   Small integer  
61 QWP4PCBS DB2INT2AA DB2SINT INT2 5   0   Small integer  
62 QWP4PS4 DB2INT2AA DB2SINT INT2 5   0   Small integer  
63 QWP4PS32 DB2INT2AA DB2SINT INT2 5   0   Small integer  
64 QWP4NCPU DB2NUMC03 DB2NUMC03 NUMC 3   0   Field type numc, length 3, 1 byte  
65 QWP4HRC DB2RES01 DB2CHAR01 CHAR 1   0   Field type char, length 1, reserved  
66 QWP4PCWH DB2INT2AA DB2SINT INT2 5   0   Small integer  
67 QWP4PCRB DB2INT2AA DB2SINT INT2 5   0   Small integer  
68 QWP4MXRB DB2INT2AA DB2SINT INT2 5   0   Small integer  
69 QWP4HRCD DB2INT2AA DB2SINT INT2 5   0   Small integer  
70 QWP4RCST DB2INT2AA DB2SINT INT2 5   0   Small integer  
71 QWP4TRWT DB2INT2AA DB2SINT INT2 5   0   Small integer  
72 QWP4WPFQ DB2INT2AA DB2SINT INT2 5   0   Small integer  
73 QWP4WPFS DB2INT2AA DB2SINT INT2 5   0   Small integer  
74 QWP4SQTM DB2INT2AA DB2SINT INT2 5   0   Small integer  
75 QWP4SQTD DB2INT2AA DB2SINT INT2 5   0   Small integer  
76 QWP4VDTM DB2INT2AA DB2SINT INT2 5   0   Small integer  
77 QWP4VDTD DB2INT2AA DB2SINT INT2 5   0   Small integer  
78 QWP4MPFQ DB2INT2AA DB2SINT INT2 5   0   Small integer  
79 QWP4SWFU DB2INT2AA DB2SINT INT2 5   0   Small integer  
80 QWP4TISP DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
81 QWP4DRBS DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
82 QWP4RMIN DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
83 QWP4RMAX DB2WP4RMAX NUMC10 NUMC 10   0   Maximum size of RID pool in the DB2 subsystem  
84 QWP4RNLP DB2INT2AA DB2SINT INT2 5   0   Small integer  
85 QWP4AUCA DB2INT2AA DB2SINT INT2 5   0   Small integer  
86 QWP4INTV DB2INT2AA DB2SINT INT2 5   0   Small integer  
87 QWP4QCTM DB2INT2AA DB2SINT INT2 5   0   Small integer  
88 QWP4TDDN DB2WP4DDN DB2SINT INT2 5   0   Asynchronous drain start  
89 QWP4MDDN DB2WP4MDDN DB2SINT INT2 5   0   Asynchronous drain stop  
90 QWP4TXS DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
91 QWP4SRBT DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
92 QWP4AND DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
93 QWP4OR DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
94 QWP4CPUM DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
95 QWP4FDP DB2INT2AA DB2SINT INT2 5   0   Small integer  
96 QWP4KNFC DB2INT2AA DB2SINT INT2 5   0   Small integer  
97 QWP4UTO DB2WP4UTO DB2SINT INT2 5   0   Utility timeout factor  
98 QWP4EST DB2INT2AA DB2SINT INT2 5   0   Small integer  
99 QWP4CUT DB2INT2AA DB2SINT INT2 5   0   Small integer  
100 QWP4SPC DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
101 QWP4SPS DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
102 QWP4AST DB2INT2AA DB2SINT INT2 5   0   Small integer  
103 QWP4WBMP DB2INT2AA DB2SINT INT2 5   0   Small integer  
104 QWP4WDLI DB2INT2AA DB2SINT INT2 5   0   Small integer  
105 QWP4XCTH DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
106 QWP4BNVA DB2WP4BNVA CHAR10 CHAR 10   0   Indicates the authorities required to add a new package  
107 QWP4SCTM DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
108 QWP4MDEG DB2WP4MDEG DB2INT4 INT4 10   0   Upper limit on the degree of parallelism  
109 QWP4PAC DB2WP4PAC DB2INT4 INT4 10   0   Package authorization cache  
110 QWP4UBS DB2INT2AA DB2SINT INT2 5   0   Small integer  
111 QWP4REGF DB2BIT01 DB2CHAR01 CHAR 1   0   Field type char, length 1, bit field  
112 QWP4REGC DB2WP4REGC CHAR128 CHAR 128   0   Owner of the application registration table  
113 QWP4REGA DB2WP4REGA CHAR128 CHAR 128   0   Name of the application registration table  
114 QWP4REGO DB2WP4REGX CHAR128 CHAR 128   0   The name of the object registration table  
115 QWP4SIT DB2WP4SIT DB2CHAR10L CHAR 10   0   Indicates whether the site is local or remote  
116 QWP4EBF DB2WP4EBF DB2CHAR09 CHAR 9   0   Always use EDM Best Fit Algorithm  
117 QWP4REGN DB2WP4REGN CHAR8 CHAR 8   0   Name of the database containing the registration tables  
118 QWP4KSIZ DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
119 QWP4IFS DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
120 QWP4ABN DB2WP4ABN DB2CHAR03L CHAR 3   0   Indicates whether autobind operations are allowed  
121 QWP4DXTP DB2WP4DXTP DB2NUMC1 NUMC 1   0   Default index type  
122 QWP4RMTI DB2INT2AA DB2SINT INT2 5   0   Small integer  
123 QWP4ZTN DB2INT2AA DB2SINT INT2 5   0   Small integer  
124 QWP4ZUT DB2INT2AA DB2SINT INT2 5   0   Small integer  
125 QWP4MDE DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
126 QWP4ESC DB2WP4ESC CHAR4 CHAR 4   0   The data definition escape character for ART and ORT search  
127 QWP4CDEG DB2WP4CDEG DB2CHAR03 CHAR 3   0   Default parallelism degree  
128 QWP4CDE1 DB2CHAR01 DB2CHAR01 CHAR 1   0   Field type char, length 1  
129 QWP4RES4 DB2RES03 DB2CHAR03 CHAR 3   0   Field type char, length 3, reserved  
130 QWP4ULBZ DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
131 QWP4ULFR DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
132 QWP4RHTI DB2INT2AA DB2SINT INT2 5   0   Small integer  
133 QWP4UMD DB2WP4UMD DB2SINT INT2 5   0   Maximum degree of utility parallelism  
134 QWP4MXKD DB2WP4MXKD DB2INT4 INT4 10   0   Maximum number of prepared dynamic statements  
135 QWP4SREC DB2CHAR02 DB2CHAR02 CHAR 2   0   Field type char, length 2  
136 QWP4RES5 DB2RES05 DB2CHAR05 CHAR 5   0   Field type char, length 5 (reserved)  
137 QWP4DSFL DB2RES01 DB2CHAR01 CHAR 1   0   Field type char, length 1, reserved  
138 QWP4COC1 DB2INT2AA DB2SINT INT2 5   0   Small integer  
139 QWP4COC2 DB2INT2AA DB2SINT INT2 5   0   Small integer  
140 QWP4DATE DB2CHAR08 DB2CHAR08 CHAR 8   0   Field type char, length 8  
141 QWP4CDYN DB2WP4CDYN DB2CHAR03L CHAR 3   0   Cache prepared dynamic SQL statements  
142 QWP4SCAC DB2WP4SCAC   CHAR 10   0   Sequential mode to read cached data from a 3990 controller  
143 QWP4WAIT DB2WP4WAIT DB2SINT INT2 5   0   Multiplier for Determining Retained Lock Timeout  
144 QWP4RAC DB2WP4RAC DB2INT4 INT4 10   0   Routine authorization cache size  
145 QWP4EDDS DB2WP4EDDS DB2INT4 INT4 10   0   EDM Pool Data Space Size (MB)  
146 QWP4DSMX DB2INT4 DB2INT4 INT4 10   0   Field Type INT, Length 4  
147 QWP4LEM DB2WP4LEM DB2SINT INT2 5   0   Max. no. of language environment tokens active at any time  
148 QWP4CONT DB2WP4CONT DB2CHAR03L CHAR 3   0   Storage contraction  
149 QWP4CTHR DB2WP4CTHR DB2SINT INT2 5   0   Storage Contraction Threshold (Commits)  
150 QWP4STHR DB2WP4STHR DB2INT4 INT4 10   0   Storage Contraction Threshold (MB)  
151 QWP4XLUC DB2WP4XLUC DB2CHAR03L CHAR 3   0   Flag if X lock is used for searched update or delete  
152 QWP4RCHL DB2WP4RCHL DB2CHAR03L CHAR 3   0   If page or row locks for held cursors are released at commit  
153 QWP4DIV3 DB2WP4DIV3 DB2CHAR03L CHAR 3   0   Minimum divide scale  
154 QWP4OJEH DB2WP4OJEH DB2CHAR03L CHAR 3   0   Outer join performance enhancement  
155 QWP4VCFK DB2WP4VCFK DB2CHAR03L CHAR 3   0   VARCHAR from index  
156 QWP4XLUD DB2WP4XLUD DB2CHAR06L CHAR 6   0   Whether X lock is used for searched update or delete  
157 QWP4PST DB2WP4PST DB2CHAR03L CHAR 3   0   Utility cache option  
158 QWP4HINT DB2WP4HINT DB2CHAR03L CHAR 3   0   Whether access path hints are allowed  
159 QWP4CDC DB2WP4CDC DB2CHAR03L CHAR 3   0   Whether change data capture is enabled  
160 QWP4ENF DB2WP4ENF DB2CHAR03L CHAR 3   0   Whether DPROP is supported  
161 QWP4ABX DB2WP4ABX DB2CHAR03L CHAR 3   0   Whether explain is allowed during autobind  
162 QWP4DSST DB2WP4DSST DB2CHAR03L CHAR 3   0   If an SQLDA for describe is built during bind for static SQL  
163 QWP4REGI DB2WP4REGI DB2CHAR03L CHAR 3   0   Whether data definition control support is to be used  
164 QWP4REGD DB2WP4REGD DB2CHAR03L CHAR 3   0   Whether only registered packages or plans can use DDL  
165 QWP4REGQ DB2WP4REGQ DB2CHAR03L CHAR 3   0   Whether two-part names are required for objects reg. in ORT  
166 QWP4REGU DB2WP4REGU DB2CHAR10L CHAR 10   0   Unregistered DDL default  
167 QWP4SJRT DB2WP4SJRT   CHAR 10   0   DB2 for OS/390: Star Join controls  
168 QWP4OPTP DB2WP4OPTP CHAR8 CHAR 8   0   Optimizer index prefetch enhancement  
169 QWP4NPAG DB2WP4NPAG DB2INT4U INT4 10   0   NPAGES threshold for index scan  
170 QWP4VUN DB2WP4VUN CHAR8 CHAR 8   0   Evaluate uncommitted  
171 QWP4URNM DB2WP4URNM CHAR8 CHAR 8   0   REORG FASTSWITCH  
172 QWP4INTE DB2WP4INTE DB2INT4U INT4 10   0   Real-time statistics interval  
173 QWP4SJTB DB2WP4SJTB DB2INT4U INT4 10   0   Minimum star join tables  
174 QWP4STHT DB2WP4STHT CHAR20 CHAR 20   0   Statistics history default  
175 QWP4STRL DB2WP4STRL CHAR8 CHAR 8   0   Statistics rollup default  
176 QWP4MXTB DB2WP4MXTB DB2INT4U INT4 10   0   Maximum joined tables  
177 QWP4EDMX DB2WP4EDMX DB2INT4U INT4 10   0   Max EDM Pool data space size (MB)  
178 QWP4NLG DB2WP4NLG DB2CHAR8 CHAR 8   0   Active log disabled  
179 QWP4PKYU DB2WP4PKYU DB2CHAR8 CHAR 8   0   Allow partitioning key update  
180 QWP4MXCE     INT4 10   0    
181 QWP4TJTH     INT4 10   0    
182 QWP4REOT     CHAR 10   0    
183 QWP4RRFD     CHAR 10   0    
184 QWP4SLBU     CHAR 10   0    
185 QWP4RSDC     CHAR 20   0    
186 QWP4RSMT     CHAR 10   0    
187 QWP4RPTC     CHAR 10   0    
188 QWP4WFAL     INT4 10   0    
189 QWP4STCL     CHAR 10   0    
190 QWP4FRLC     INT4 10   0    
191 QWP4MXDC     INT4 10   0    
192 QWP4SJMK     CHAR 10   0    
193 QWP4COS4     CHAR 10   0    
194 QWP4RVDPR DB2WP4RVDPR   CHAR 10   0   REVOKE dependent privileges  
195 QWP4SECA1_TYPE DB2WP4SECA1_TYPE   CHAR 10   0   Security Administrator 1 Type  
196 QWP4SECA2_TYPE DB2WP4SECA2_TYPE   CHAR 10   0   Security Administrator 2 Type  
197 QWP4SECA1_E DB2WP4SECA1   CHAR 128   0   Security Admin 1  
198 QWP4SECA2_E DB2WP4SECA2   CHAR 128   0   Security Admin 2  
199 QWP4SEPSD DB2WP4SEPSD   CHAR 10   0   Separate security duties  
200 QWP4EDBC     INT4 10   0    
201 QWP4ESTC     INT4 10   0    
202 QWP4LRTH     INT4 10   0    
203 QWP4MXNC     INT4 10   0    
204 QWP4MXOC     INT4 10   0    
205 QWP4MXOE     INT4 10   0    
206 QWP4MXOS     INT4 10   0    
207 QWP4MXSP     INT4 10   0    
208 QWP4PDIX     CHAR 10   0    
209 QWP4PJSJ     CHAR 10   0    
210 QWP4SJXP     INT4 10   0    
211 QWP4ACCU     INT4 10   0    
212 QWP4DCIX DB2CWP4DCI DB2CHAR08 CHAR 8   0   SMS Dataclass for indexspaces  
213 QWP4DCFS DB2CWP4DCF DB2CHAR08 CHAR 8   0   SMS Dataclass for tablespaces  
214 QWP4RRF     CHAR 7   0    
215 QWP4CFRP     CHAR 9   0    
216 QWP4RFRP     CHAR 9   0    
217 QWP4FCPPRC     CHAR 9   0    
218 QWP4CCP     CHAR 3   0    
219 QWP4CLD     CHAR 3   0    
220 QWP4CROT     CHAR 3   0    
221 QWP4RBI     CHAR 3   0    
222 QWP4ROI     CHAR 3   0    
History
Last changed by/on SAP  20130604 
SAP Release Created in