SAP ABAP Table DB2QWP1 (Installation Parameters (DSN6SYSP))

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	DB2QWP1	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	☐	DB2WP1SMRC		CHAR	38	0	The individual write-to-operator routing codes started
2	QWP1RLF	☐	DB2WP1RLF	DB2CHAR03L	CHAR	3	0	Resource limit facility automatic start
3	QWP1TRSZ	☐	DB2WP1TRSZ	DB2SINT	INT2	5	0	Size of resident trace table (multiple of 4K)
4	QWP1LOGL	☐	DB2WP1LOGL	DB2INT4	INT4	10	0	Number of log records written between checkpoints
5	QWP1IDB	☐	DB2WP1IDB	DB2SINT	INT2	5	0	Maximum number of concurrent connections from batch job
6	QWP1IDF	☐	DB2WP1IDF	DB2SINT	INT2	5	0	Maximum number of concurrent TSO foreground connections
7	QWP1CT	☐	DB2WP1CT	DB2SINT	INT2	5	0	The maximum number of concurrent allied threads
8	QWP1RMT	☐	DB2WP1RMT	DB2SINT	INT2	5	0	Maximum number of database access threads
9	QWP1LVL	☐	DB2WP1LVL	DB2SINT	INT2	5	0	Used to detect parameters and code that are out of sync
10	QWP1DTIM	☐	DB2WP1DTIM	DB2SINT	INT2	5	0	Time Interval Before DB2 Resets Data Set Statistics (Min.)
11	QWP1DB1M	☐	DB2WP1DB1M	DB2INT4	INT4	10	0	Amount of space reserved for MVS functions
12	QWP1CRIT	☐	DB2WP1CRIT	DB2INT4	INT4	10	0	Amount of space reserved for critical work
13	QWP1SOS	☐	DB2QWP1SOS	DB2INT4	INT4	10	0	Amount of space above MVS and critical space
14	QWP1STIM	☐	DB2WP1STIM	DB2SINT	INT2	5	0	Time interval (in minutes) between statistics collection
15	QWP1DBPR	☐	DB2WP1DBPR	DB2CHAR08	CHAR	8	0	Database protocol for 3-part names
16	QWP1TRST	☐	DB2WP1TRST	DB2CHAR03L	CHAR	3	0	The GLOBAL TRACE Classes Started
17	QWP1SMFS	☐	DB2WP1SMFS	DB2CHAR03L	CHAR	3	0	The SMF STATISTICS TRACE Classes Started
18	QWP1SMFA	☐	DB2WP1SMFA	DB2CHAR03L	CHAR	3	0	The SMF ACCOUNTING TRACE Classes Started
19	QWP1AUDT	☐	DB2WP1AUDT	CHAR8	CHAR	8	0	The AUDIT TRACE classes started
20	QWP1RLFA	☐	DB2WP1RLFA	CHAR128	CHAR	128	0	Authorization ID of the resource limit specification table
21	QWP1RLFT	☐	DB2WP1RLFT	DB2CHAR04	CHAR	4	0	Resource limit specification table ID
22	QWP1RLFR	☐	DB2WP1RLFR	DB2RAW01	RAW	1	0	FLAGS (ONE BYTE, USED AS BITS 1-8)
23	QWP1RLFN	☐	DB2WP1RLFN		CHAR	10	0	Resource limit specification table error action
24	QWP1MON	☐	DB2WP1MON	DB2CHAR03L	CHAR	3	0	Monitor tracing start options
25	QWP1MONS	☐	DB2WP1MONS	DB2INT4	INT4	10	0	Monitor Buffer Size (KB)
26	QWP1FREQ	☐	DB2WP1FREQ	DB2SINT	INT2	5	0	Pseudo-close frequency
27	QWP1TMR	☐	DB2WP1TMR	DB2SINT	INT2	5	0	Pseudo-close time
28	QWP1DFRQ	☐	DB2WP1DFRQ		CHAR	10	0	Number of checkpoints
29	QWP1SPPN	☐	DB2WP1SPPN	DB2CHAR10	CHAR	10	0	Name of JCL procedure used to start DB2 address space
30	QWP1SPAB	☐	DB2WP1SPAB	DB2SINT	INT2	5	0	Number of abends allowed for a stored procedure
31	QWP1SPTO	☐	DB2WP1SPTO	DB2SINT	INT2	5	0	Stored procedure timeout value
32	QWP1SCER	☐	DB2WP1SCER	DB2CHAR04	CHAR	4	0	Extended security
33	QWP1URCK	☐	DB2WP1URCK	DB2SINT	INT2	5	0	UR Checkpoint Frequency
34	QWP1FLBZ	☐	DB2WP1FLBZ	DB2SINT	INT2	5	0	Maximum DSN1DBM1 Storage for Fast Log Apply (MB)
35	QWP1TBPL	☐	DB2WP1TBPL	DB2BPNAME	CHAR	8	0	Default buffer pool for 4 KB tablespaces
36	QWP1IXPL	☐	DB2WP1IXPL	DB2BPNAME	CHAR	8	0	Default buffer pool for user indexspaces
37	QWP1WLME	☐	DB2WP1WLME	DB2CHAR18	CHAR	18	0	Default WLM environment for user-defined functions/stoprocs
38	QWP1LMBO	☐	DB2WP1LMBO	DB2CHAR04L	CHAR	4	0	Whether DB2 postpones backward log processing during restart
39	QWP1BDUR	☐	DB2WP1BDUR	DB2SINT	INT2	5	0	Restart backout limit
40	QWP1EXBR	☐	DB2WP1EXBR	DB2SINT	INT2	5	0	Maximum number of extra DRDA query blocks for DB2 requester
41	QWP1EXBS	☐	DB2WP1EXBS	DB2SINT	INT2	5	0	Maximum number of extra DRDA query blocks for DB2 server
42	QWP1LVA	☐	DB2WP1LVA	DB2INT4	INT4	10	0	Max. number of KB that a user can use to store lob values
43	QWP1LVS	☐	DB2WP1LVS	DB2INT4	INT4	10	0	Max. number of MB a subsystem can use to store lob values
44	QWP1CDB	☐	DB2WP1CDB	DB2INT4	INT4	10	0	Maximum number of connected remote threads
45	QWP1PROL	☐	DB2WP1PROL	DB2CHAR03L	CHAR	3	0	Whether accounting records should be rolled up
46	QWP1TLSZ	☐	DB2WP1TLSZ	DB2SINT	INT2	5	0	Size of the Local Trace Tables in Multiples of 4 KB
47	QWP1SYNO	☐	DB2WP1SYNO	CHAR8	CHAR	8	0	Statistics synchronization
48	QWP1SYNV	☐			INT4	10	0
49	QWP1LWCK	☐	DB2WP1LWCK	DB2INT4U	INT4	10	0	Long URs detection (UR based)
50	QWP1TP8	☐			CHAR	10	0
51	QWP1TP16	☐			CHAR	10	0
52	QWP1TP32	☐			CHAR	10	0
53	QWP1TPLB	☐			CHAR	10	0
54	QWP1TPXM	☐			CHAR	10	0
55	QWP1EIDB	☐			CHAR	10	0
56	QWP1SITS	☐			CHAR	10	0
57	QWP1DIDS	☐			CHAR	10	0
58	QWP1CITS	☐			CHAR	10	0
59	QWP1ACID	☐			CHAR	53	0
60	QWP1IXQT	☐			INT4	10	0
61	QWP1MESZ	☐			CHAR	10	0
62	QWP1TSQT	☐			INT4	10	0
63	QWP1UNIC	☐			CHAR	10	0
64	QWP1VVCI	☐			CHAR	10	0
65	QWP1DSSZ	☐			INT2	5	0
66	QWP1TKMD	☐			CHAR	3	0
67	QWP1LBIL	☐			INT2	5	0
68	QWP1DCFS	☐			CHAR	3	0

History

Last changed by/on	SAP	20130604
SAP Release Created in