SAP ABAP Table DB2QWP4C (Instrumentation Mapping for System Initialization Parameter)

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	DB2QWP4C	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	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
2	QWP4LEN	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
3	QWP4EYE	☐	DB2CCHAR04	DB2CHAR04	CHAR	4	0	Field type char, length 4
4	QWP4LVL	☐	DB2CCHAR08	DB2CHAR08	CHAR	8	0	Field type char, length 8
5	QWP4MMRB	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
6	QWP4WREN	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
7	QWP4BPOF	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
8	QWP4MVS	☐	DB2CCHAR03	DB2CHAR03	CHAR	3	0	Field type char, length 3
9	QWP4CNTL	☐	DB2CBIT02	DB2CHAR02	CHAR	2	0	Field type char, length 2, bit field
10	QWP4IDCK	☐	DB2CBIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
11	QWP4MISC	☐	DB2CBIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
12	QWP4MISZ	☐	DB2CBIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
13	QWP4AUTH	☐	DB2CWP4AUT	DB2CHAR08L	CHAR	8	0	DB2 authorization
14	QWP4SADM	☐	DB2CWP4SAD	CHAR8	CHAR	8	0	The authorization ID of the system administrator 1
15	QWP4RRU	☐	DB2CWP4RRU	DB2CHAR03L	CHAR	3	0	UPDATE lock for repeatable read or read stability
16	QWP4MIS2	☐	DB2CBIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
17	QWP4RES1	☐	DB2CRES02	DB2CHAR02	CHAR	2	0	Field type char, length 2, reserved
18	QWP4EDPL	☐	DB2CWP4EDP	DB2NUMC10	NUMC	10	0	Maximum Size of the EDM Pool (MB)
19	QWP4VCOF	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
20	QWP4DBOF	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
21	QWP4DFID	☐	DB2CWP4DFI	CHAR8	CHAR	8	0	The authorization ID of the system default user
22	QWP4IPRC	☐	DB2CWP4IPR	CHAR8	CHAR	8	0	Name of IRLM procedure which DB2 uses to start IRLM
23	QWP4ISID	☐	DB2CWP4ISI	CHAR4	CHAR	4	0	Name of the IRLM subsystem by which IRLM is known to MVS
24	QWP4TOUT	☐	DB2CWP4TOU	DB2NUMC10	NUMC	10	0	Maximum time DB2 waits for the release of a locked resource
25	QWP4ISWT	☐	DB2CWP4ISW	DB2NUMC10	NUMC	10	0	Seconds DB2 will wait for IRLM start
26	QWP4ISWI	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
27	QWP4IAU	☐	DB2CWP4IAU	CHAR4	CHAR	4	0	Indicates whether IRLM is started automatically by DB2
28	QWP4DBC	☐	DB2CWP4IAT	CHAR4	CHAR	4	0	Autostart of IRLM
29	QWP4SWFN	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
30	QWP4SPOL	☐	DB2CWP4SPO	DB2INT4U	INT4	10	0	Maximum Size of the Sort Pool (MB)
31	QWP4SMXN	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
32	QWP4BMC1	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
33	QWP4BMC2	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
34	QWP4SWT1	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
35	QWP4SWT2	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
36	QWP4DWF1	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
37	QWP4DWF2	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
38	QWP4DWU1	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
39	QWP4DWU2	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
40	QWP4VDWT	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
41	QWP4RES2	☐	DB2CRES02	DB2CHAR02	CHAR	2	0	Field type char, length 2, reserved
42	QWP4KDSA	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
43	QWP4KDSB	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
44	QWP4RDEU	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
45	QWP4LRUT	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
46	QWP4PF32	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
47	QWP4PFT1	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
48	QWP4PFT2	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
49	QWP4BBTR	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
50	QWP4RES3	☐	DB2CRES02	DB2CHAR02	CHAR	2	0	Field type char, length 2, reserved
51	QWP4PSID	☐	DB2CBIT04	DB2CHAR04	CHAR	4	0	Field type char, length 4, bit field
52	QWP4DSPM	☐	DB2CWP4DSP	DB2NUMC10	NUMC	10	0	Maximum locks per table(space) before escalation
53	QWP4LKTS	☐	DB2CWP4LKT	DB2NUMC10	NUMC	10	0	Maximum number of locks per tablespace
54	QWP4LKUS	☐	DB2CWP4LKU	DB2NUMC10	NUMC	10	0	Maximum number of locks per user
55	QWP4ADM2	☐	DB2CWP4AD2	CHAR8	CHAR	8	0	The authorization ID of the system administrator 2
56	QWP4OPR1	☐	DB2CWP4OP1	CHAR8	CHAR	8	0	The authorization ID of the system operator 1
57	QWP4OPR2	☐	DB2CWP4OP2	CHAR8	CHAR	8	0	The authorization ID of the system operator 2
58	QWP4CHKL	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
59	QWP4PDQ	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
60	QWP4PCBS	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
61	QWP4PS4	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
62	QWP4PS32	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
63	QWP4NCPU	☐	DB2CNUMC03	DB2NUMC03	NUMC	3	0	Field type numc, length 3, 1 byte
64	QWP4HRC	☐	DB2CRES01	DB2CHAR01	CHAR	1	0	Field type char, length 1, reserved
65	QWP4PCWH	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
66	QWP4PCRB	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
67	QWP4MXRB	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
68	QWP4HRCD	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
69	QWP4RCST	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
70	QWP4TRWT	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
71	QWP4WPFQ	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
72	QWP4WPFS	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
73	QWP4SQTM	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
74	QWP4SQTD	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
75	QWP4VDTM	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
76	QWP4VDTD	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
77	QWP4MPFQ	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
78	QWP4SWFU	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
79	QWP4TISP	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
80	QWP4DRBS	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
81	QWP4RMIN	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
82	QWP4RMAX	☐	DB2CWP4RMA	NUMC10	NUMC	10	0	Maximum Size of RID Pool in the DB2 Subsystem (MB)
83	QWP4RNLP	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
84	QWP4AUCA	☐	DB2CWP4AUC	DB2NUMC10	NUMC	10	0	Indicates the size of the authorization cache
85	QWP4INTV	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
86	QWP4QCTM	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
87	QWP4TDDN	☐	DB2CWP4DDN	DB2NUMC10	NUMC	10	0	Asynchronous drain start
88	QWP4MDDN	☐	DB2CWP4MDD	DB2NUMC10	NUMC	10	0	Asynchronous drain stop
89	QWP4TXS	☐	DB2WP4TXS	DB2NUMC10	NUMC	10	0	Agent local pool extension size (bytes)
90	QWP4SRBT	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
91	QWP4AND	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
92	QWP4OR	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
93	QWP4CPUM	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
94	QWP4FDP	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
95	QWP4KNFC	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
96	QWP4UTO	☐	DB2CWP4UTO	NUMC6	NUMC	6	0	Utility timeout factor
97	QWP4EST	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
98	QWP4CUT	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
99	QWP4SPC	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
100	QWP4SPS	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
101	QWP4AST	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
102	QWP4WBMP	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
103	QWP4WDLI	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
104	QWP4XCTH	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
105	QWP4BNVA	☐	DB2CWP4BNV	CHAR10	CHAR	10	0	Indicates the authorities required to add a new package
106	QWP4SCTM	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
107	QWP4MDEG	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
108	QWP4PAC	☐	DB2CWP4PAC	DB2NUMC10	NUMC	10	0	Package authorization cache
109	QWP4UBS	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
110	QWP4REGF	☐	DB2CBIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
111	QWP4REGC	☐	DB2CWP4REG	CHAR8	CHAR	8	0	Owner of the application registration table
112	QWP4REGA	☐	DB2CWP4REA	CHAR17	CHAR	17	0	Name of the application registration table
113	QWP4REGO	☐	DB2CWP4REO	CHAR17	CHAR	17	0	The name of the object registration table
114	QWP4SIT	☐	DB2CWP4SIT	DB2CHAR10L	CHAR	10	0	Indicates Whether the Site is Local or Remote
115	QWP4REGN	☐	DB2CWP4REN	CHAR8	CHAR	8	0	Name of the database containing the registration tables
116	QWP4KSIZ	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
117	QWP4IFS	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
118	QWP4ABN	☐	DB2CWP4ABN	DB2CHAR03L	CHAR	3	0	Indicates whether autobind operations are allowed
119	QWP4DXTP	☐	DB2CWP4DXT	DB2NUMC10	NUMC	10	0	Default index type
120	QWP4RMTI	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
121	QWP4ZTN	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
122	QWP4ZUT	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
123	QWP4MDE	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
124	QWP4ESC	☐	DB2CWP4ESC	CHAR4	CHAR	4	0	The data definition escape character for ART and ORT search
125	QWP4CDEG	☐	DB2CWP4CDE	DB2CHAR03	CHAR	3	0	Default Parallelism Degree
126	QWP4CDE1	☐	DB2CCHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
127	QWP4RES4	☐	DB2CRES03	DB2CHAR03	CHAR	3	0	Field type char, length 3, reserved
128	QWP4ULBZ	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
129	QWP4ULFR	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
130	QWP4RHTI	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
131	QWP4UMD	☐	DB2CWP4UMD	DB2NUMC10	NUMC	10	0	Maximum degree of utility parallelism
132	QWP4MXKD	☐	DB2CWP4MXK	DB2NUMC10	NUMC	10	0	Maximum number of prepared dynamic statements
133	QWP4SREC	☐	DB2CCHAR02	DB2CHAR02	CHAR	2	0	Field type char, length 2
134	QWP4RES5	☐	DB2CRES05	DB2CHAR05	CHAR	5	0	Character field of length 5 (reserved)
135	QWP4DSFL	☐	DB2CRES01	DB2CHAR01	CHAR	1	0	Field type char, length 1, reserved
136	QWP4COC1	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
137	QWP4COC2	☐	DB2CNUMC05	DB2NUMC05	NUMC	5	0	Field type numc, length 5, short integer
138	QWP4DATE	☐	DB2CCHAR08	DB2CHAR08	CHAR	8	0	Field type char, length 8
139	QWP4CDYN	☐	DB2CWP4CDY	DB2CHAR03L	CHAR	3	0	Cache prepared dynamic SQL statements
140	QWP4SCAC	☐	DB2CWP4SCA		CHAR	10	0	Sequential Mode to Read Cached Data from a 3990 Controller
141	QWP4WAIT	☐	DB2CWP4WAI	DB2NUMC05	NUMC	5	0	Multiplier for Determining Retained Lock Timeout
142	QWP4RAC	☐	DB2CWP4RAC	DB2NUMC10	NUMC	10	0	Routine authorization cache size
143	QWP4EDDS	☐	DB2CWP4EDD	DB2NUMC10	NUMC	10	0	EDM Pool Data Space Size (MB)
144	QWP4DSMX	☐	DB2CNUMC10	DB2NUMC10	NUMC	10	0	Field type numc, length 10, integer
145	QWP4LEM	☐	DB2CWP4LEM	DB2NUMC05	NUMC	5	0	Max. no. of language environment tokens active at any time
146	QWP4CONT	☐	DB2CWP4CON	DB2CHAR03L	CHAR	3	0	Storage Contraction
147	QWP4CTHR	☐	DB2CWP4CTH	DB2NUMC05	NUMC	5	0	Storage Contraction Threshold (Commits)
148	QWP4STHR	☐	DB2CWP4STH	DB2NUMC10	NUMC	10	0	Storage Contraction Threshold (MB)
149	QWP4XLUC	☐	DB2CWP4XLU	DB2CHAR03L	CHAR	3	0	Flag if X lock is Used for Searched Update or Delete
150	QWP4RCHL	☐	DB2CWP4RCH	DB2CHAR03L	CHAR	3	0	If Page or Row Locks for Held Cursors are Released at Commit
151	QWP4DIV3	☐	DB2CWP4DI3	DB2CHAR03L	CHAR	3	0	Minimum Divide Scale
152	QWP4OJEH	☐	DB2CWP4OJE	DB2CHAR03L	CHAR	3	0	Outer Join Performance Enhancement
153	QWP4VCFK	☐	DB2CWP4VCF	DB2CHAR03L	CHAR	3	0	VARCHAR from Index
154	QWP4XLUD	☐	DB2CWP4XLD	DB2CHAR06L	CHAR	6	0	Whether X lock is Used for Searched Update or Delete
155	QWP4PST	☐	DB2CWP4PST	DB2CHAR03L	CHAR	3	0	Utility Cache Option
156	QWP4HINT	☐	DB2CWP4HIN	DB2CHAR03L	CHAR	3	0	Indicates Whether Access Path Hints are Allowed
157	QWP4CDC	☐	DB2CWP4CD	DB2CHAR03L	CHAR	3	0	Indicates Whether Change Data Capture is Enabled
158	QWP4ENF	☐	DB2CWP4ENF	DB2CHAR03L	CHAR	3	0	Indicates Whether DPROP is Supported
159	QWP4ABX	☐	DB2CWP4ABX	DB2CHAR03L	CHAR	3	0	Indicates Whether Explain is Allowed During Autobind
160	QWP4DSST	☐	DB2CWP4DSS	DB2CHAR03L	CHAR	3	0	If an SQLDA for Describe is Built During Bind for Static SQL
161	QWP4REGI	☐	DB2CWP4REI	DB2CHAR03L	CHAR	3	0	Whether Data Definition Control Support is to Be Used
162	QWP4REGD	☐	DB2CWP4RED	DB2CHAR03L	CHAR	3	0	Whether Only Registered Packages or Plans Can Use DDL
163	QWP4REGQ	☐	DB2CWP4REQ	DB2CHAR03L	CHAR	3	0	Whether Two-Part Names are Required for Objects Reg. in ORT
164	QWP4REGU	☐	DB2CWP4REU	DB2CHAR10L	CHAR	10	0	Unregistered DDL Default
165	QWP4NPAG	☐	DB2CWP4NPA	DB2NUMC05	NUMC	5	0	NPAGES threshold for index scan
166	QWP4DCFS	☐	DB2CWP4DCF	DB2CHAR08	CHAR	8	0	SMS Dataclass for tablespaces
167	QWP4DCIX	☐	DB2CWP4DCI	DB2CHAR08	CHAR	8	0	SMS Dataclass for indexspaces
168	QWP4HOP	☐	DB2CWP4HOP	DB2CHAR10	CHAR	10	0	Hop site authorization
169	QWP4EBF	☐	DB2WP4EDM	DB2CHAR10	CHAR	10	0	DB2 for OS/390: EDM Pool Algorithm
170	QWP4SJRT	☐	DB2WP4SJRC		CHAR	10	0	DB2 for OS/390: Star Join controls

History

Last changed by/on	SAP	20110908
SAP Release Created in	620