SAP ABAP Table DB2QWP1C (Installation Parameters (DSN6SYSP))

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	DB2QWP1C	Table Relationship Diagram
Short Description	Installation Parameters (DSN6SYSP)

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	QWP1SMRC	☐	DB2WP1CSMR		CHAR	38	0	The individual write-to-operator routing codes started
2	QWP1RLF	☐	DB2WP1CRLF	DB2CHAR03L	CHAR	3	0	Resource limit facility automatic start
3	QWP1TRSZ	☐	DB2WP1CTRS	DB2NUMC10	NUMC	10	0	Size of resident trace table (multiple of 4K)
4	QWP1LOGL	☐	DB2WP1CLOG	DB2NUMC10	NUMC	10	0	Number of log records written between checkpoints
5	QWP1IDB	☐	DB2WP1CIDB	DB2NUMC10	NUMC	10	0	Maximum number of concurrent connections from batch job
6	QWP1IDF	☐	DB2WP1CIDF	DB2NUMC10	NUMC	10	0	Maximum number of concurrent TSO foreground connections
7	QWP1CT	☐	DB2WP1CCT	DB2NUMC10	NUMC	10	0	The maximum number of concurrent allied threads
8	QWP1RMT	☐	DB2WP1CRMT	DB2NUMC10	NUMC	10	0	Maximum number of database access threads
9	QWP1LVL	☐	DB2WP1CLVL	DB2NUMC10	NUMC	10	0	Used to detect parameters and code that are out of sync
10	QWP1DTIM	☐	DB2WP1CDTI	DB2NUMC05	NUMC	5	0	Time Interval Before DB2 Resets Data Set Statistics (Min.)
11	QWP1DB1M	☐	DB2WP1CDB1	DB2NUMC10	NUMC	10	0	Amount of space reserved for MVS functions
12	QWP1CRIT	☐	DB2WP1CCRI	DB2NUMC10	NUMC	10	0	Amount of space reserved for critical work
13	QWP1SOS	☐	DB2QWP1CSO	DB2NUMC10	NUMC	10	0	Amount of space above MVS and critical space
14	QWP1STIM	☐	DB2WP1CSTI	DB2NUMC10	NUMC	10	0	Time interval (in minutes) between statistics collection
15	QWP1DBPR	☐	DB2WP1CDBP	DB2CHAR08	CHAR	8	0	Database protocol for 3-part names
16	QWP1TRST	☐	DB2WP1CTRT	DB2CHAR90	CHAR	90	0	The GLOBAL TRACE Classes Started
17	QWP1SMFS	☐	DB2WP1CSMF	DB2CHAR90	CHAR	90	0	The SMF STATISTICS TRACE Classes Started
18	QWP1SMFA	☐	DB2WP1CSMA	DB2CHAR90	CHAR	90	0	The SMF ACCOUNTING TRACE Classes Started
19	QWP1AUDT	☐	DB2WP1CAUD	DB2CHAR90	CHAR	90	0	The AUDIT TRACE classes started
20	QWP1RLFA	☐	DB2WP1CRLA	DB2CHAR08	CHAR	8	0	Authorization ID of the resource limit specification table
21	QWP1RLFT	☐	DB2WP1CRLT	DB2CHAR04	CHAR	4	0	Resource limit specification table ID
22	QWP1RLFR	☐	DB2WP1CRLR	DB2RAW01	RAW	1	0	FLAGS (ONE BYTE, USED AS BITS 1-8)
23	QWP1RLFN	☐	DB2WP1CRLN	DB2NUMC10	NUMC	10	0	Resource limit specification table error action
24	QWP1MON	☐	DB2WP1CMON	DB2CHAR09	CHAR	9	0	Monitor tracing start options
25	QWP1MONS	☐	DB2WP1CMOS	DB2NUMC10	NUMC	10	0	Monitor Buffer Size (KB)
26	QWP1FREQ	☐	DB2WP1CFRE	DB2NUMC10	NUMC	10	0	Pseudo-close frequency
27	QWP1TMR	☐	DB2WP1CTMR	DB2NUMC10	NUMC	10	0	Pseudo-close time
28	QWP1DFRQ	☐	DB2WP1CDFR		CHAR	10	0	Number of checkpoints
29	QWP1SPPN	☐	DB2WP1CSPP	DB2CHAR10	CHAR	10	0	Name of JCL procedure used to start DB2 address space
30	QWP1SPAB	☐	DB2WP1CSPA	DB2NUMC10	NUMC	10	0	Number of abends allowed for a stored procedure
31	QWP1SPTO	☐	DB2WP1CSPT	DB2NUMC10	NUMC	10	0	Stored procedure timeout value
32	QWP1SCER	☐	DB2WP1CSCE	DB2CHAR04	CHAR	4	0	Extended security
33	QWP1URCK	☐	DB2WP1CURC	DB2NUMC10	NUMC	10	0	UR Checkpoint Frequency
34	QWP1FLBZ	☐	DB2WP1CFLB	DB2NUMC10	NUMC	10	0	Maximum DSN1DBM1 Storage for Fast Log Apply (MB)
35	QWP1TBPL	☐	DB2WP1CTBP	DB2BPNAME	CHAR	8	0	Default buffer pool for user tablespaces
36	QWP1IXPL	☐	DB2WP1CIXP	DB2BPNAME	CHAR	8	0	Default buffer pool for user indexspaces
37	QWP1WLME	☐	DB2WP1CWLM	DB2CHAR18	CHAR	18	0	Default WLM environment for user-defined functions/stoprocs
38	QWP1LMBO	☐	DB2WP1CLMB	DB2CHAR04L	CHAR	4	0	Whether DB2 Postpones Backward Log Processing During Restart
39	QWP1BDUR	☐	DB2WP1CBDU	DB2NUMC05	NUMC	5	0	Restart backout limit
40	QWP1EXBR	☐	DB2WP1CEXB	DB2NUMC05	NUMC	5	0	Maximum number of extra DRDA query blocks for DB2 requester
41	QWP1EXBS	☐	DB2WP1CEXS	DB2NUMC05	NUMC	5	0	Maximum number of extra DRDA query blocks for DB2 server
42	QWP1LVA	☐	DB2WP1CLVA	DB2NUMC10	NUMC	10	0	Max. number of KB that a user can use to store lob values
43	QWP1LVS	☐	DB2WP1CLVS	DB2NUMC10	NUMC	10	0	Max. number of MB a subsystem can use to store lob values
44	QWP1CDB	☐	DB2WP1CCDB	DB2NUMC10	NUMC	10	0	Maximum number of connected remote threads
45	QWP1PROL	☐	DB2WP1CPRO	DB2CHAR03L	CHAR	3	0	Indicates Whether Accounting Records Should Be Rolled Up
46	QWP1TLSZ	☐	DB2WP1CTLS	DB2NUMC05	NUMC	5	0	Size of the Local Trace Tables in Multiples of 4 KB

History

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