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

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	DB2QWPT2	Table Relationship Diagram
Short Description	DB2 installation parameters (first part: DB2QWPT1)

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	Instrumentation Mapping for System Initialization Parameter
3	QWP5PCY	☐	DB2WP5PCY	DB2CHAR03L	CHAR	3	0	IRLM cross memory enabled
4	QWP5DLOK	☐	DB2WP5DLOK	DB2SINT	INT2	5	0	Deadlock time (seconds)
5	QWP5DCYC	☐	DB2WP5DCYC	DB2SINT	INT2	5	0	Deadlock cycle
6	QWP5TVAL	☐	DB2WP5TVAL	DB2INT4	INT4	10	0	Actual resource timeout
7	QWP5MCSA	☐	DB2WP5MCSA	DB2INT4	INT4	10	0
8	QWP5FLG	☐			CHAR	8	0
9	QWP5HASH	☐			INT4	10	0
10	QWP5PHSH	☐			INT4	10	0
11	QWP5RLE	☐			INT4	10	0
12	.INCLUDE	☐				0	0	Data Sharing Group Initialization Parameters
13	QWPAGRPN	☐	DB2WPAGRPN	CHAR10	CHAR	10	0	Name of a DB2 data sharing group
14	QWPAMBRN	☐	DB2WPAMBRN	CHAR10	CHAR	10	0	Name of a new or existing DB2 data sharing member
15	QWPAIOPT	☐	DB2WPAIOPT	CHAR6	CHAR	6	0	Whether data sharing function is used or not
16	QWPACOOR	☐	DB2WPACOOR	DB2CHAR08	CHAR	8	0	Whether a DB2 subsystem can be a parallelism coordinator
17	QWPAASST	☐	DB2WPAASST	DB2CHAR08	CHAR	8	0	Indicates whether this DB2 can assist parallel processing
18	QWPASUCV	☐	DB2WPASUCV	DB2INT4	INT4	10	0	CPU Service Unit Conversion Factor
19	QWPAMAXM	☐	DB2WPAMAXM	DB2INT4	INT4	10	0	Maximum Number of Members
20	QWPAIMMW	☐	DB2WPAIMMW	DB2CHAR8	CHAR	8	0	Immediate writes for GBPs
21	.INCLUDE	☐				0	0	Application Programming Defaults (DB2 for OS390)
22	QWPBSID	☐	DB2WPBSID		INT4	10	0	The EBCDIC single-byte coded character set ID
23	QWPBMID	☐	DB2WPBMID		INT4	10	0	The EBCDIC mixed coded character set ID
24	QWPBGID	☐	DB2WPBGID		INT4	10	0	The EBCDIC graphic coded character set ID
25	QWPBASID	☐	DB2WPBASID		INT4	10	0	The ASCII single-byte coded character set ID
26	QWPBAMID	☐	DB2WPBAMID		INT4	10	0	The ASCII mixed coded character set ID
27	QWPBAR	☐	DB2WPBAR	DB2CHAR10L	CHAR	10	0	Indicates the rules of precision for a decimal field
28	QWPBDRUL	☐	DB2WPBDRUL	DB2CHAR03L	CHAR	3	0	Whether DSNHDECP values are used for dynamic SQL statements
29	QWPBDE	☐	DB2WPBDE	DB2CHAR08L	CHAR	8	0	Whether the decimal contains a comma (,) or a period (.)
30	QWPBCHAR	☐	DB2WPBCHAR	CHAR8	CHAR	8	0	The default character set, which can be ALPHANUM or KATAKANA
31	QWPBENS	☐	DB2WPBENS	CHAR8	CHAR	8	0	The default encoding scheme, which can be ASCII or EBCDIC.
32	QWPBLANG	☐	DB2WPBLANG	CHAR8	CHAR	8	0	The default programming language for your site
33	QWPBGRA	☐	DB2WPBGRA	DB2CHAR03L	CHAR	3	0	Default mixed graphic
34	QWPBSDL	☐	DB2WPBSDL	DB2CHAR10L	CHAR	10	0	The string delimiter for SQL
35	QWPBDSD	☐	DB2WPBDSD	DB2CHAR10L	CHAR	10	0	Distributed SQL string delimiter
36	QWPBDATE	☐	DB2WPBDATE	CHAR10	CHAR	10	0	The default output format for dates
37	QWPBTIME	☐	DB2WPBTIME	CHAR10	CHAR	10	0	The default output format for times
38	QWPBDLEN	☐	DB2WPBDLEN	DB2SINT	INT2	5	0	Local date length
39	QWPBTLEN	☐	DB2WPBTLEN	DB2SINT	INT2	5	0	Local time length
40	QWPBSQL	☐	DB2WPBSQL	DB2CHAR03L	CHAR	3	0	SQL language support level
41	QWPBAGID	☐	DB2WPBAGID	DB2INT4	INT4	10	0	ASCII GBCS CCSID
42	QWPBDEL	☐	DB2WPBDEL	DB2CHAR10L	CHAR	10	0	Default delimiter
43	QWPBLCTP	☐	DB2WPBLCTP	DB2CHAR50L	CHAR	50	0	Default locale LC_CTYPE
44	QWPBUSID	☐			INT4	10	0
45	QWPBUMID	☐			INT4	10	0
46	QWPBUGID	☐			INT4	10	0
47	QWPBAPSC	☐	DB2WPAPSC	CHAR30	CHAR	30	0	Application encoding scheme
48	.INCLUDE	☐				0	0	DB2/OS390 Installation Parameter (Archive)
49	QWP3BKSZ	☐	DB2WP3BKSZ	DB2INT4	INT4	10	0	The block size of the archive log data sets
50	QWP3RISP	☐	DB2WP3RISP	DB2INT4	INT4	10	0	Primary space allocation
51	QWP3SECS	☐	DB2WP3SECS	DB2INT4	INT4	10	0	Secondary space allocation
52	QWP3UNT1	☐	DB2WP3UNT1	CHAR10	CHAR	10	0	The type of device for COPY1 archive logs
53	QWP3RE1N	☐	DB2WP3RE1N	CHAR20	CHAR	20	0	DSN prefix character string for copy-1 archive log dataset
54	QWP3UNT2	☐	DB2WP3UNT2	CHAR10	CHAR	10	0	The type of device for COPY2 archive logs
55	QWP3RE2N	☐	DB2WP3RE2N	CHAR20	CHAR	20	0	DSN prefix character string for copy-2 archive log dataset
56	QWP3CTLG	☐	DB2WP3CTLG		CHAR	4	0	Whether the archive datasets are cataloged in the IFC
57	QWP3UNIT	☐	DB2WP3UNIT	CHAR10	CHAR	10	0	Device type to which the archive log sets are written
58	QWP3MSV1	☐	DB2WP3MSV1	DB2CHAR10L	CHAR	10	0	Mass storage system volume group 1 name
59	SPACEALLOC	☐	DB2SPACEUN	CHAR10	CHAR	10	0	The unit used in allocating archive datasets
60	QWP3MSV2	☐	DB2WP3MSV2	DB2CHAR10L	CHAR	10	0	Mass storage system volume group 2 name
61	QWP3RETN	☐	DB2WP3RETN	DB2SINT	INT2	5	0	Number of days the archive log data sets are to be retained
62	QWP3DTIM	☐	DB2WP3DTIM	DB2CHAR03L	CHAR	3	0	Indicates whether a timestamp is inserted in log datasets
63	QWP3MQP	☐	DB2WP3MQP	DB2SINT	INT2	5	0	Maximum time for DB2 to attempt a full system quiesce
64	QWP3ALCU	☐	DB2WP3ALCU	DB2CHAR10L	CHAR	10	0	The unit used in allocating archive datasets
65	QWP3WTOR	☐	DB2WP3WTOR	DB2CHAR03L	CHAR	3	0	Issue WTOR before archive mounts
66	QWP3COMP	☐	DB2WP3COMP	DB2CHAR03L	CHAR	3	0	Force data compaction
67	QWP3RTCT	☐	DB2WP3RTCT	DB2CHAR03L	CHAR	3	0	Archive logs RACF protection
68	.INCLUDE	☐				0	0	VSAM Catalog Qualifier Used for Database Dataset (DB2)
69	QWP6CATN	☐	DB2WP6CATN	CHAR8	CHAR	8	0	High qualifier name for all DB2 system datasets
70	.INCLUDE	☐				0	0	Databases to be Started Automatically During DBM1 Startup
71	QWP8DBNM	☐	DB2WP8DBNM	CHAR10	CHAR	10	0	Name of database to be automatically started
72	QWP8SPNM	☐	DB2WP8SPNM	CHAR10	CHAR	10	0	Tablespace name or indexspace name
73	.INCLUDE	☐				0	0	Facility Start Information (DB2 for z/OS)
74	QWP9TTO	☐	DB2WP9TTO	DB2SINT	INT2	5	0	Idle thread timeout
75	QWP9STRT	☐	DB2WP9STRT	CHAR14	CHAR	14	0	The startup option for the distributed data facility (DDF)
76	QWP9RYC	☐	DB2WP9RYC	DB2SINT	INT2	5	0	Number of minutes between two resynchronization intervals
77	QWP9CMST	☐	DB2WP9CMST	CHAR10	CHAR	10	0	Status of a DBAT
78	QWP9MAX1	☐	DB2WP9MAX1	DB2INT4	INT4	10	0	Maximum type 1 inactive threads allowed by DB2
79	QWP9RLER	☐	DB2WP9RLER	DB2CHAR10L	CHAR	10	0	Resource limit facility error parameter
80	QWP9RLFN	☐	DB2WP9RLFN	DB2INT4	INT4	10	0	Specifies the Limit in CPU Time Service Units
81	QWP9TCPA	☐	DB2WP9TCPA	DB2CHAR03L	CHAR	3	0	Whether verified conn. are accepted from TCP/IP clients
82	QWP9TCPK	☐			CHAR	10	0
83	QWP9INAC	☐			INT4	10	0
84	QWP9PRSTD	☐			CHAR	10	0
85	.INCLUDE	☐				0	0	DB2 V8 additions to QWP1/2/4
86	QWP4REGO	☐	DB2WP4REGX	CHAR128	CHAR	128	0	The name of the object registration table
87	QWP4EDBC	☐			INT4	10	0
88	QWP4ESTC	☐			INT4	10	0
89	QWP4MXNC	☐			INT4	10	0
90	QWP4MXSP	☐			INT4	10	0
91	QWP4LRTH	☐			INT4	10	0
92	QWP4PDIX	☐			CHAR	10	0
93	QWP4ACCU	☐			INT4	10	0
94	QWP4MXOS	☐			INT4	10	0
95	QWP4MXOC	☐			INT4	10	0
96	QWP4MXOE	☐			INT4	10	0
97	QWP4SJXP	☐			INT4	10	0
98	QWP4DCIX	☐	DB2CWP4DCI	DB2CHAR08	CHAR	8	0	SMS Dataclass for indexspaces
99	QWP4DCFS	☐	DB2CWP4DCF	DB2CHAR08	CHAR	8	0	SMS Dataclass for tablespaces
100	QWP1ACID	☐			CHAR	53	0
101	QWP1MESZ	☐			CHAR	10	0
102	QWP1TSQT	☐			INT4	10	0
103	QWP1IXQT	☐			INT4	10	0
104	QWP1VVCI	☐			CHAR	10	0
105	QWP1UNIC	☐			CHAR	10	0
106	QWP4PJSJ	☐			CHAR	10	0

History

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