SAP ABAP Table DB6PMCD_DB2 (DB6: Structure of GET_DB_CONFIG result set)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Basic Data

Table Category	INTTAB	Structure
Structure	DB6PMCD_DB2	Table Relationship Diagram
Short Description	DB6: Structure of GET_DB_CONFIG result set

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	DBCONFIG_TYPE	☐			INT2	5	0
2	AP_CTL_HP	☐			INT4	10	0
3	APPLHEAPSZ	☐			INT4	10	0
4	AUTORESTRT	☐			CHAR	10	0
5	AVG_APPLS	☐			INT4	10	0
6	BUFFPAGE	☐			DEC	22	0
7	CATCA_SZ	☐			DEC	22	0
8	CHGPGS_THR	☐			INT4	10	0
9	CPPROTECT	☐			CHAR	25	0
10	DBHEAP	☐			DEC	22	0
11	DFT_DEGREE	☐			DEC	22	0
12	DFT_EXTSZ	☐			DEC	22	0
13	DFT_LDRECS	☐			INT4	10	0
14	DFT_PF_SZ	☐			INT4	10	0
15	DFT_QOPT	☐			DEC	22	0
16	DFT_REFAGE	☐			CHAR	25	0
17	DFT_SQLMW	☐			CHAR	25	0
18	DIR_OBJ_NM	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
19	DISCOVER	☐			CHAR	10	0
20	DL_EXPINT	☐			DEC	22	0
21	DL_NIM_CPS	☐			INT4	10	0
22	DL_TM_DROP	☐			INT4	10	0
23	DL_TOKEN	☐			CHAR	10	0
24	DL_UPPER	☐			CHAR	25	0
25	DLCHKTIME	☐			DEC	22	0
26	DYNQRYMGMT	☐			CHAR	10	0
27	ESTOR_SQSZ	☐			DEC	22	0
28	INDEXREC	☐			CHAR	25	0
29	INDEXSORT	☐			CHAR	25	0
30	LCKLIST	☐			INT4	10	0
31	LCKTMOUT	☐			INT4	10	0
32	LOGBUFSZ	☐			INT4	10	0
33	LOGFILSIZ	☐			DEC	22	0
34	LOGPRIMARY	☐			INT4	10	0
35	LOGRETAIN	☐			CHAR	10	0
36	LOGSECOND	☐			INT4	10	0
37	MAXAPPLS	☐			INT4	10	0
38	MAXFILOP	☐			INT4	10	0
39	MAXLOCKS	☐			INT4	10	0
40	MINCOMMIT	☐			INT4	10	0
41	NEWLOGPATH	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
42	NUM_DBBKPS	☐			INT4	10	0
43	NUM_EST_SG	☐			DEC	22	0
44	NUM_FRQVAL	☐			INT4	10	0
45	NUM_IOCLNS	☐			INT4	10	0
46	NUM_IOSVRS	☐			INT4	10	0
47	NUM_QUANT	☐			INT4	10	0
48	PCKCACHESZ	☐			DEC	22	0
49	REC_HIS_RT	☐			INT4	10	0
50	SEQDETECT	☐			CHAR	25	0
51	SOFTMAX	☐			INT4	10	0
52	SORTHEAP	☐			DEC	22	0
53	STA_HP_SZ	☐			DEC	22	0
54	STMTHEAP	☐			INT4	10	0
55	TSM_MGMT	☐			CHAR	30	0
56	TSM_NODE	☐			CHAR	64	0
57	TSM_OWNER	☐			CHAR	64	0
58	TSM_PW	☐			CHAR	64	0
59	USEREXIT	☐			CHAR	10	0
60	UTIL_HP_SZ	☐			DEC	22	0
61	BACKUP_PND	☐			CHAR	25	0
62	CODEPAGE	☐			INT4	10	0
63	CODESET	☐			CHAR	17	0
64	COLLATESEQ	☐			CHAR	260	0
65	COUNTRY	☐			INT4	10	0
66	DB_CONSIST	☐			CHAR	25	0
67	DB_LEVEL	☐			INT4	10	0
68	LOG_RET_ST	☐			CHAR	25	0
69	LOGHEAD	☐			CHAR	12	0
70	LOGPATH	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
71	MULTPG_ALO	☐			CHAR	25	0
72	NUMSEGS	☐			INT4	10	0
73	REL_LEVEL	☐			INT4	10	0
74	REST_PEND	☐			CHAR	25	0
75	RFWD_PEND	☐			CHAR	25	0
76	TERRITORY	☐			CHAR	33	0
77	UEXIT_STAT	☐			CHAR	25	0
78	LOGINDEXBUILD	☐			DEC	22	0
79	HADR_DB_ROLE	☐			DEC	22	0
80	HADR_LOCAL_HOST	☐			CHAR	255	0
81	HADR_LOCAL_SVC	☐			CHAR	40	0
82	HADR_REMOTE_HOST	☐			CHAR	255	0
83	HADR_REMOTE_SVC	☐			CHAR	40	0
84	HADR_REMOTE_INST	☐			CHAR	8	0
85	HADR_TIMEOUT	☐			DEC	22	0
86	HADR_SYNCMODE	☐			DEC	22	0
87	STMT_HEAP	☐			DEC	22	0
88	AUTO_SWITCHES	☐			INT4	10	0
89	ARCHMETH1	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
90	ARCHMETH2	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
91	ARCHMETH1OPT	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
92	ARCHMETH2OPT	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
93	FAILOVERLOG	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
94	NUMARCHRETRY	☐			INT4	10	0
95	ARCHRETRYDELAY	☐			INT4	10	0
96	VENDOROPT	☐			CHAR	242	0
97	ALT_COLLATE	☐			DEC	22	0
98	APG_MEM_SZ	☐			DEC	22	0
99	BLK_LD_FUL	☐			CHAR	10	0
100	DB_MEMORY	☐			DEC	22	0
101	DFT_MTTB_TYPES	☐			DEC	22	0
102	DL_WT_IEXP	☐			INT4	10	0
103	GRPHP_RAT	☐			INT4	10	0
104	MAXLOG	☐			INT4	10	0
105	MR_LOGPATH	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
106	NUMLOGSP	☐			INT4	10	0
107	OV_LOGPATH	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
108	SHEAPTRES	☐			DEC	22	0
109	TRACKMOD	☐			CHAR	10	0
110	AUTO_MAINT	☐			CHAR	10	0
111	AUTO_DB_BACKUP	☐			CHAR	10	0
112	AUTO_TBL_MAINT	☐			CHAR	10	0
113	AUTO_RUNSTATS	☐			CHAR	10	0
114	AUTO_STATS_PROF	☐			CHAR	10	0
115	AUTO_PROF_UPD	☐			CHAR	10	0
116	AUTO_REORG	☐			CHAR	10	0
117	PAGESIZE	☐			DEC	22	0

History

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