SAP ABAP Table DB2QWPT1 (DB2 installation parameters (sec. part: DB2QWPT2))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	DB2QWPT1	Table Relationship Diagram
Short Description	DB2 installation parameters (sec. part: DB2QWPT2)

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	MEMBNM	☑	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
2	.INCLUDE	☐				0	0	Installation Parameters (DSN6SYSP)
3	QWP1SMRC	☐	DB2WP1SMRC		CHAR	38	0	The individual write-to-operator routing codes started
4	QWP1RLF	☐	DB2WP1RLF	DB2CHAR03L	CHAR	3	0	Resource limit facility automatic start
5	QWP1TRSZ	☐	DB2WP1TRSZ	DB2SINT	INT2	5	0	Size of resident trace table (multiple of 4K)
6	QWP1LOGL	☐	DB2WP1LOGL	DB2INT4	INT4	10	0	Number of log records written between checkpoints
7	QWP1IDB	☐	DB2WP1IDB	DB2SINT	INT2	5	0	Maximum number of concurrent connections from batch job
8	QWP1IDF	☐	DB2WP1IDF	DB2SINT	INT2	5	0	Maximum number of concurrent TSO foreground connections
9	QWP1CT	☐	DB2WP1CT	DB2SINT	INT2	5	0	The maximum number of concurrent allied threads
10	QWP1RMT	☐	DB2WP1RMT	DB2SINT	INT2	5	0	Maximum number of database access threads
11	QWP1LVL	☐	DB2WP1LVL	DB2SINT	INT2	5	0	Used to detect parameters and code that are out of sync
12	QWP1DTIM	☐	DB2WP1DTIM	DB2SINT	INT2	5	0	Time Interval Before DB2 Resets Data Set Statistics (Min.)
13	QWP1DB1M	☐	DB2WP1DB1M	DB2INT4	INT4	10	0	Amount of space reserved for MVS functions
14	QWP1CRIT	☐	DB2WP1CRIT	DB2INT4	INT4	10	0	Amount of space reserved for critical work
15	QWP1SOS	☐	DB2QWP1SOS	DB2INT4	INT4	10	0	Amount of space above MVS and critical space
16	QWP1STIM	☐	DB2WP1STIM	DB2SINT	INT2	5	0	Time interval (in minutes) between statistics collection
17	QWP1DBPR	☐	DB2WP1DBPR	DB2CHAR08	CHAR	8	0	Database protocol for 3-part names
18	QWP1TRST	☐	DB2WP1TRST	DB2CHAR03L	CHAR	3	0	The GLOBAL TRACE Classes Started
19	QWP1SMFS	☐	DB2WP1SMFS	DB2CHAR03L	CHAR	3	0	The SMF STATISTICS TRACE Classes Started
20	QWP1SMFA	☐	DB2WP1SMFA	DB2CHAR03L	CHAR	3	0	The SMF ACCOUNTING TRACE Classes Started
21	QWP1AUDT	☐	DB2WP1AUDT	CHAR8	CHAR	8	0	The AUDIT TRACE classes started
22	QWP1RLFA	☐	DB2WP1RLFA	CHAR128	CHAR	128	0	Authorization ID of the resource limit specification table
23	QWP1RLFT	☐	DB2WP1RLFT	DB2CHAR04	CHAR	4	0	Resource limit specification table ID
24	QWP1RLFR	☐	DB2WP1RLFR	DB2RAW01	RAW	1	0	FLAGS (ONE BYTE, USED AS BITS 1-8)
25	QWP1RLFN	☐	DB2WP1RLFN		CHAR	10	0	Resource limit specification table error action
26	QWP1MON	☐	DB2WP1MON	DB2CHAR03L	CHAR	3	0	Monitor tracing start options
27	QWP1MONS	☐	DB2WP1MONS	DB2INT4	INT4	10	0	Monitor Buffer Size (KB)
28	QWP1FREQ	☐	DB2WP1FREQ	DB2SINT	INT2	5	0	Pseudo-close frequency
29	QWP1TMR	☐	DB2WP1TMR	DB2SINT	INT2	5	0	Pseudo-close time
30	QWP1DFRQ	☐	DB2WP1DFRQ		CHAR	10	0	Number of checkpoints
31	QWP1SPPN	☐	DB2WP1SPPN	DB2CHAR10	CHAR	10	0	Name of JCL procedure used to start DB2 address space
32	QWP1SPAB	☐	DB2WP1SPAB	DB2SINT	INT2	5	0	Number of abends allowed for a stored procedure
33	QWP1SPTO	☐	DB2WP1SPTO	DB2SINT	INT2	5	0	Stored procedure timeout value
34	QWP1SCER	☐	DB2WP1SCER	DB2CHAR04	CHAR	4	0	Extended security
35	QWP1URCK	☐	DB2WP1URCK	DB2SINT	INT2	5	0	UR Checkpoint Frequency
36	QWP1FLBZ	☐	DB2WP1FLBZ	DB2SINT	INT2	5	0	Maximum DSN1DBM1 Storage for Fast Log Apply (MB)
37	QWP1TBPL	☐	DB2WP1TBPL	DB2BPNAME	CHAR	8	0	Default buffer pool for 4 KB tablespaces
38	QWP1IXPL	☐	DB2WP1IXPL	DB2BPNAME	CHAR	8	0	Default buffer pool for user indexspaces
39	QWP1WLME	☐	DB2WP1WLME	DB2CHAR18	CHAR	18	0	Default WLM environment for user-defined functions/stoprocs
40	QWP1LMBO	☐	DB2WP1LMBO	DB2CHAR04L	CHAR	4	0	Whether DB2 postpones backward log processing during restart
41	QWP1BDUR	☐	DB2WP1BDUR	DB2SINT	INT2	5	0	Restart backout limit
42	QWP1EXBR	☐	DB2WP1EXBR	DB2SINT	INT2	5	0	Maximum number of extra DRDA query blocks for DB2 requester
43	QWP1EXBS	☐	DB2WP1EXBS	DB2SINT	INT2	5	0	Maximum number of extra DRDA query blocks for DB2 server
44	QWP1LVA	☐	DB2WP1LVA	DB2INT4	INT4	10	0	Max. number of KB that a user can use to store lob values
45	QWP1LVS	☐	DB2WP1LVS	DB2INT4	INT4	10	0	Max. number of MB a subsystem can use to store lob values
46	QWP1CDB	☐	DB2WP1CDB	DB2INT4	INT4	10	0	Maximum number of connected remote threads
47	QWP1PROL	☐	DB2WP1PROL	DB2CHAR03L	CHAR	3	0	Whether accounting records should be rolled up
48	QWP1TLSZ	☐	DB2WP1TLSZ	DB2SINT	INT2	5	0	Size of the Local Trace Tables in Multiples of 4 KB
49	QWP1SYNO	☐	DB2WP1SYNO	CHAR8	CHAR	8	0	Statistics synchronization
50	QWP1SYNV	☐			INT4	10	0
51	QWP1LWCK	☐	DB2WP1LWCK	DB2INT4U	INT4	10	0	Long URs detection (UR based)
52	QWP1TP8	☐			CHAR	10	0
53	QWP1TP16	☐			CHAR	10	0
54	QWP1TP32	☐			CHAR	10	0
55	QWP1TPLB	☐			CHAR	10	0
56	QWP1TPXM	☐			CHAR	10	0
57	QWP1EIDB	☐			CHAR	10	0
58	QWP1SITS	☐			CHAR	10	0
59	QWP1DIDS	☐			CHAR	10	0
60	QWP1CITS	☐			CHAR	10	0
61	QWP1ACID	☐			CHAR	53	0
62	QWP1IXQT	☐			INT4	10	0
63	QWP1MESZ	☐			CHAR	10	0
64	QWP1TSQT	☐			INT4	10	0
65	QWP1UNIC	☐			CHAR	10	0
66	QWP1VVCI	☐			CHAR	10	0
67	QWP1DSSZ	☐			INT2	5	0
68	QWP1TKMD	☐			CHAR	3	0
69	QWP1LBIL	☐			INT2	5	0
70	QWP1DCFS	☐			CHAR	3	0
71	.INCLUDE	☐				0	0	Installation Parameter (LOG)
72	QWP2OBPS	☐	DB2WP2OBPS	DB2INT4	INT4	10	0	Log Output Buffer Pool Size (MB)
73	QWP2IBPS	☐	DB2WP2IBPS	DB2INT4	INT4	10	0	Log input buffer pool size (in kilobytes)
74	QWP2ARCL	☐	DB2WP2ARCL	DB2INT4	INT4	10	0	Maximum number of archive log datasets
75	QWP2MRTU	☐	DB2WP2MRTU	DB2SINT	INT2	5	0	Maximum number of tape units for archive read
76	QWP2WRTH	☐	DB2WP2WRTH	DB2SINT	INT2	5	0	Write threshold on filled buffers
77	QWP2DUAL	☐	DB2WP2DUAL	CHAR10	CHAR	10	0	Number of active log copies
78	QWP2ADL	☐	DB2WP2ADL	CHAR10	CHAR	10	0	The number of archive log copies
79	QWP2TWOBSDS	☐	DB2BSDSCPY	DB2CHAR10	CHAR	10	0	Dual bootstrap data set
80	QWP2ARC2FRST	☐	DB2RC2FRST	DB2CHAR03L	CHAR	3	0	Whether copy2 archive logs are read first
81	QWP2DMIN	☐	DB2WP2DMS		CHAR	11	0	Tape volume deallocation period
82	QWP2OFFLOAD	☐	DB2OFFLOAD	DB2CHAR03L	CHAR	3	0	Whether offload is switched on
83	.INCLUDE	☐				0	0	Instrumentation Mapping for System Initialization Parameter
84	QWP4ID	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
85	QWP4LEN	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
86	QWP4EYE	☐	DB2CHAR04	DB2CHAR04	CHAR	4	0	Field type char, length 4
87	QWP4LVL	☐	DB2CHAR08	DB2CHAR08	CHAR	8	0	Field type char, length 8
88	QWP4MMRB	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
89	QWP4WREN	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
90	QWP4BPOF	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
91	QWP4MVS	☐	DB2CHAR03	DB2CHAR03	CHAR	3	0	Field type char, length 3
92	QWP4CNTL	☐	DB2BIT02	DB2CHAR02	CHAR	2	0	Field type char, length 2, bit field
93	QWP4IDCK	☐	DB2BIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
94	QWP4MISC	☐	DB2BIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
95	QWP4MISZ	☐	DB2BIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
96	QWP4AUTH	☐	DB2WP4AUTH	DB2CHAR08L	CHAR	8	0	DB2 authorization
97	QWP4SADM	☐	DB2WP4SADM	CHAR128	CHAR	128	0	The authorization ID of the system administrator 1
98	QWP4RRU	☐	DB2WP4RRU	DB2CHAR03L	CHAR	3	0	UPDATE lock for repeatable read or read stability
99	QWP4MIS2	☐	DB2BIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
100	QWP4MSTG	☐	DB2WPMSTG	DB2CHAR09	CHAR	9	0	Thread Storage Algorithm
101	QWP4RES1	☐	DB2RES02	DB2CHAR02	CHAR	2	0	Field type char, length 2, reserved
102	QWP4EDPL	☐	DB2WP4EDPL	DB2INT4	INT4	10	0	Maximum Size of the EDM Pool (MB)
103	QWP4VCOF	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
104	QWP4DBOF	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
105	QWP4DFID	☐	DB2WP4DFID	CHAR128	CHAR	128	0	The authorization ID of the system default user
106	QWP4IPRC	☐	DB2WP4IPRC	CHAR8	CHAR	8	0	Name of IRLM procedure which DB2 uses to start IRLM
107	QWP4ISID	☐	DB2WP4ISID	CHAR4	CHAR	4	0	Name of the IRLM subsystem by which IRLM is known to MVS
108	QWP4TOUT	☐	DB2WP4TOUT	DB2INT4	INT4	10	0	Maximum time DB2 waits for the release of a locked resource
109	QWP4ISWT	☐	DB2WP4ISWT	DB2INT4	INT4	10	0	Seconds DB2 will wait for IRLM start
110	QWP4ISWI	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
111	QWP4IAU	☐	DB2WP4IAU	CHAR4	CHAR	4	0	Indicates whether IRLM is started automatically by DB2
112	QWP4DBC	☐	DB2WP4IAUT	CHAR4	CHAR	4	0	Autostart of IRLM
113	QWP4SWFN	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
114	QWP4SPOL	☐	DB2WP4SPOL	DB2INT4	INT4	10	0	Maximum Size of the Sort Pool (MB)
115	QWP4SMXN	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
116	QWP4BMC1	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
117	QWP4BMC2	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
118	QWP4SWT1	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
119	QWP4SWT2	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
120	QWP4DWF1	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
121	QWP4DWF2	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
122	QWP4DWU1	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
123	QWP4DWU2	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
124	QWP4VDWT	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
125	QWP4RES2	☐	DB2RES02	DB2CHAR02	CHAR	2	0	Field type char, length 2, reserved
126	QWP4KDSA	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
127	QWP4KDSB	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
128	QWP4RDEU	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
129	QWP4LRUT	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
130	QWP4PF32	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
131	QWP4PFT1	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
132	QWP4PFT2	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
133	QWP4BBTR	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
134	QWP4RES3	☐	DB2RES02	DB2CHAR02	CHAR	2	0	Field type char, length 2, reserved
135	QWP4PSID	☐	DB2BIT04	DB2CHAR04	CHAR	4	0	Field type char, length 4, bit field
136	QWP4DSPM	☐	DB2WP4DSPM	DB2SINT	INT2	5	0	Maximum locks per table(space) before escalation
137	QWP4LKTS	☐	DB2WP4LKTS	DB2INT4	INT4	10	0	Maximum number of locks per tablespace
138	QWP4LKUS	☐	DB2WP4LKUS	DB2INT4	INT4	10	0	Maximum number of locks per user
139	QWP4ADM2	☐	DB2WP4ADM2	CHAR128	CHAR	128	0	The authorization ID of the system administrator 2
140	QWP4OPR1	☐	DB2WP4OPR1	CHAR128	CHAR	128	0	The authorization ID of the system operator 1
141	QWP4OPR2	☐	DB2WP4OPR2	CHAR128	CHAR	128	0	The authorization ID of the system operator 2
142	QWP4CHKL	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
143	QWP4PDQ	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
144	QWP4PCBS	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
145	QWP4PS4	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
146	QWP4PS32	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
147	QWP4NCPU	☐	DB2NUMC03	DB2NUMC03	NUMC	3	0	Field type numc, length 3, 1 byte
148	QWP4HRC	☐	DB2RES01	DB2CHAR01	CHAR	1	0	Field type char, length 1, reserved
149	QWP4PCWH	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
150	QWP4PCRB	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
151	QWP4MXRB	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
152	QWP4HRCD	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
153	QWP4RCST	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
154	QWP4TRWT	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
155	QWP4WPFQ	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
156	QWP4WPFS	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
157	QWP4SQTM	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
158	QWP4SQTD	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
159	QWP4VDTM	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
160	QWP4VDTD	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
161	QWP4MPFQ	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
162	QWP4SWFU	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
163	QWP4TISP	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
164	QWP4DRBS	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
165	QWP4RMIN	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
166	QWP4RMAX	☐	DB2WP4RMAX	NUMC10	NUMC	10	0	Maximum size of RID pool in the DB2 subsystem
167	QWP4RNLP	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
168	QWP4AUCA	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
169	QWP4INTV	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
170	QWP4QCTM	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
171	QWP4TDDN	☐	DB2WP4DDN	DB2SINT	INT2	5	0	Asynchronous drain start
172	QWP4MDDN	☐	DB2WP4MDDN	DB2SINT	INT2	5	0	Asynchronous drain stop
173	QWP4TXS	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
174	QWP4SRBT	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
175	QWP4AND	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
176	QWP4OR	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
177	QWP4CPUM	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
178	QWP4FDP	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
179	QWP4KNFC	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
180	QWP4UTO	☐	DB2WP4UTO	DB2SINT	INT2	5	0	Utility timeout factor
181	QWP4EST	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
182	QWP4CUT	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
183	QWP4SPC	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
184	QWP4SPS	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
185	QWP4AST	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
186	QWP4WBMP	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
187	QWP4WDLI	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
188	QWP4XCTH	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
189	QWP4BNVA	☐	DB2WP4BNVA	CHAR10	CHAR	10	0	Indicates the authorities required to add a new package
190	QWP4SCTM	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
191	QWP4MDEG	☐	DB2WP4MDEG	DB2INT4	INT4	10	0	Upper limit on the degree of parallelism
192	QWP4PAC	☐	DB2WP4PAC	DB2INT4	INT4	10	0	Package authorization cache
193	QWP4UBS	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
194	QWP4REGF	☐	DB2BIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
195	QWP4REGC	☐	DB2WP4REGC	CHAR128	CHAR	128	0	Owner of the application registration table
196	QWP4REGA	☐	DB2WP4REGA	CHAR128	CHAR	128	0	Name of the application registration table
197	QWP4REGO	☐	DB2WP4REGX	CHAR128	CHAR	128	0	The name of the object registration table
198	QWP4SIT	☐	DB2WP4SIT	DB2CHAR10L	CHAR	10	0	Indicates whether the site is local or remote
199	QWP4EBF	☐	DB2WP4EBF	DB2CHAR09	CHAR	9	0	Always use EDM Best Fit Algorithm
200	QWP4REGN	☐	DB2WP4REGN	CHAR8	CHAR	8	0	Name of the database containing the registration tables
201	QWP4KSIZ	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
202	QWP4IFS	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
203	QWP4ABN	☐	DB2WP4ABN	DB2CHAR03L	CHAR	3	0	Indicates whether autobind operations are allowed
204	QWP4DXTP	☐	DB2WP4DXTP	DB2NUMC1	NUMC	1	0	Default index type
205	QWP4RMTI	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
206	QWP4ZTN	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
207	QWP4ZUT	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
208	QWP4MDE	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
209	QWP4ESC	☐	DB2WP4ESC	CHAR4	CHAR	4	0	The data definition escape character for ART and ORT search
210	QWP4CDEG	☐	DB2WP4CDEG	DB2CHAR03	CHAR	3	0	Default parallelism degree
211	QWP4CDE1	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
212	QWP4RES4	☐	DB2RES03	DB2CHAR03	CHAR	3	0	Field type char, length 3, reserved
213	QWP4ULBZ	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
214	QWP4ULFR	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
215	QWP4RHTI	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
216	QWP4UMD	☐	DB2WP4UMD	DB2SINT	INT2	5	0	Maximum degree of utility parallelism
217	QWP4MXKD	☐	DB2WP4MXKD	DB2INT4	INT4	10	0	Maximum number of prepared dynamic statements
218	QWP4SREC	☐	DB2CHAR02	DB2CHAR02	CHAR	2	0	Field type char, length 2
219	QWP4RES5	☐	DB2RES05	DB2CHAR05	CHAR	5	0	Field type char, length 5 (reserved)
220	QWP4DSFL	☐	DB2RES01	DB2CHAR01	CHAR	1	0	Field type char, length 1, reserved
221	QWP4COC1	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
222	QWP4COC2	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
223	QWP4DATE	☐	DB2CHAR08	DB2CHAR08	CHAR	8	0	Field type char, length 8
224	QWP4CDYN	☐	DB2WP4CDYN	DB2CHAR03L	CHAR	3	0	Cache prepared dynamic SQL statements
225	QWP4SCAC	☐	DB2WP4SCAC		CHAR	10	0	Sequential mode to read cached data from a 3990 controller
226	QWP4WAIT	☐	DB2WP4WAIT	DB2SINT	INT2	5	0	Multiplier for Determining Retained Lock Timeout
227	QWP4RAC	☐	DB2WP4RAC	DB2INT4	INT4	10	0	Routine authorization cache size
228	QWP4EDDS	☐	DB2WP4EDDS	DB2INT4	INT4	10	0	EDM Pool Data Space Size (MB)
229	QWP4DSMX	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
230	QWP4LEM	☐	DB2WP4LEM	DB2SINT	INT2	5	0	Max. no. of language environment tokens active at any time
231	QWP4CONT	☐	DB2WP4CONT	DB2CHAR03L	CHAR	3	0	Storage contraction
232	QWP4CTHR	☐	DB2WP4CTHR	DB2SINT	INT2	5	0	Storage Contraction Threshold (Commits)
233	QWP4STHR	☐	DB2WP4STHR	DB2INT4	INT4	10	0	Storage Contraction Threshold (MB)
234	QWP4XLUC	☐	DB2WP4XLUC	DB2CHAR03L	CHAR	3	0	Flag if X lock is used for searched update or delete
235	QWP4RCHL	☐	DB2WP4RCHL	DB2CHAR03L	CHAR	3	0	If page or row locks for held cursors are released at commit
236	QWP4DIV3	☐	DB2WP4DIV3	DB2CHAR03L	CHAR	3	0	Minimum divide scale
237	QWP4OJEH	☐	DB2WP4OJEH	DB2CHAR03L	CHAR	3	0	Outer join performance enhancement
238	QWP4VCFK	☐	DB2WP4VCFK	DB2CHAR03L	CHAR	3	0	VARCHAR from index
239	QWP4XLUD	☐	DB2WP4XLUD	DB2CHAR06L	CHAR	6	0	Whether X lock is used for searched update or delete
240	QWP4PST	☐	DB2WP4PST	DB2CHAR03L	CHAR	3	0	Utility cache option
241	QWP4HINT	☐	DB2WP4HINT	DB2CHAR03L	CHAR	3	0	Whether access path hints are allowed
242	QWP4CDC	☐	DB2WP4CDC	DB2CHAR03L	CHAR	3	0	Whether change data capture is enabled
243	QWP4ENF	☐	DB2WP4ENF	DB2CHAR03L	CHAR	3	0	Whether DPROP is supported
244	QWP4ABX	☐	DB2WP4ABX	DB2CHAR03L	CHAR	3	0	Whether explain is allowed during autobind
245	QWP4DSST	☐	DB2WP4DSST	DB2CHAR03L	CHAR	3	0	If an SQLDA for describe is built during bind for static SQL
246	QWP4REGI	☐	DB2WP4REGI	DB2CHAR03L	CHAR	3	0	Whether data definition control support is to be used
247	QWP4REGD	☐	DB2WP4REGD	DB2CHAR03L	CHAR	3	0	Whether only registered packages or plans can use DDL
248	QWP4REGQ	☐	DB2WP4REGQ	DB2CHAR03L	CHAR	3	0	Whether two-part names are required for objects reg. in ORT
249	QWP4REGU	☐	DB2WP4REGU	DB2CHAR10L	CHAR	10	0	Unregistered DDL default
250	QWP4SJRT	☐	DB2WP4SJRT		CHAR	10	0	DB2 for OS/390: Star Join controls
251	QWP4OPTP	☐	DB2WP4OPTP	CHAR8	CHAR	8	0	Optimizer index prefetch enhancement
252	QWP4NPAG	☐	DB2WP4NPAG	DB2INT4U	INT4	10	0	NPAGES threshold for index scan
253	QWP4VUN	☐	DB2WP4VUN	CHAR8	CHAR	8	0	Evaluate uncommitted
254	QWP4URNM	☐	DB2WP4URNM	CHAR8	CHAR	8	0	REORG FASTSWITCH
255	QWP4INTE	☐	DB2WP4INTE	DB2INT4U	INT4	10	0	Real-time statistics interval
256	QWP4SJTB	☐	DB2WP4SJTB	DB2INT4U	INT4	10	0	Minimum star join tables
257	QWP4STHT	☐	DB2WP4STHT	CHAR20	CHAR	20	0	Statistics history default
258	QWP4STRL	☐	DB2WP4STRL	CHAR8	CHAR	8	0	Statistics rollup default
259	QWP4MXTB	☐	DB2WP4MXTB	DB2INT4U	INT4	10	0	Maximum joined tables
260	QWP4EDMX	☐	DB2WP4EDMX	DB2INT4U	INT4	10	0	Max EDM Pool data space size (MB)
261	QWP4NLG	☐	DB2WP4NLG	DB2CHAR8	CHAR	8	0	Active log disabled
262	QWP4PKYU	☐	DB2WP4PKYU	DB2CHAR8	CHAR	8	0	Allow partitioning key update
263	QWP4MXCE	☐			INT4	10	0
264	QWP4TJTH	☐			INT4	10	0
265	QWP4REOT	☐			CHAR	10	0
266	QWP4RRFD	☐			CHAR	10	0
267	QWP4SLBU	☐			CHAR	10	0
268	QWP4RSDC	☐			CHAR	20	0
269	QWP4RSMT	☐			CHAR	10	0
270	QWP4RPTC	☐			CHAR	10	0
271	QWP4WFAL	☐			INT4	10	0
272	QWP4STCL	☐			CHAR	10	0
273	QWP4FRLC	☐			INT4	10	0
274	QWP4MXDC	☐			INT4	10	0
275	QWP4SJMK	☐			CHAR	10	0
276	QWP4COS4	☐			CHAR	10	0
277	QWP4RVDPR	☐	DB2WP4RVDPR		CHAR	10	0	REVOKE dependent privileges
278	QWP4SECA1_TYPE	☐	DB2WP4SECA1_TYPE		CHAR	10	0	Security Administrator 1 Type
279	QWP4SECA2_TYPE	☐	DB2WP4SECA2_TYPE		CHAR	10	0	Security Administrator 2 Type
280	QWP4SECA1_E	☐	DB2WP4SECA1		CHAR	128	0	Security Admin 1
281	QWP4SECA2_E	☐	DB2WP4SECA2		CHAR	128	0	Security Admin 2
282	QWP4SEPSD	☐	DB2WP4SEPSD		CHAR	10	0	Separate security duties
283	QWP4EDBC	☐			INT4	10	0
284	QWP4ESTC	☐			INT4	10	0
285	QWP4LRTH	☐			INT4	10	0
286	QWP4MXNC	☐			INT4	10	0
287	QWP4MXOC	☐			INT4	10	0
288	QWP4MXOE	☐			INT4	10	0
289	QWP4MXOS	☐			INT4	10	0
290	QWP4MXSP	☐			INT4	10	0
291	QWP4PDIX	☐			CHAR	10	0
292	QWP4PJSJ	☐			CHAR	10	0
293	QWP4SJXP	☐			INT4	10	0
294	QWP4ACCU	☐			INT4	10	0
295	QWP4DCIX	☐	DB2CWP4DCI	DB2CHAR08	CHAR	8	0	SMS Dataclass for indexspaces
296	QWP4DCFS	☐	DB2CWP4DCF	DB2CHAR08	CHAR	8	0	SMS Dataclass for tablespaces
297	QWP4RRF	☐			CHAR	7	0
298	QWP4CFRP	☐			CHAR	9	0
299	QWP4RFRP	☐			CHAR	9	0
300	QWP4FCPPRC	☐			CHAR	9	0
301	QWP4CCP	☐			CHAR	3	0
302	QWP4CLD	☐			CHAR	3	0
303	QWP4CROT	☐			CHAR	3	0
304	QWP4RBI	☐			CHAR	3	0
305	QWP4ROI	☐			CHAR	3	0

History

Last changed by/on	SAP	20130604
SAP Release Created in	700