SAP ABAP Table DB6_JOB_RUNSTATS_TABLES (DB6: Parameters of Table Runstats)

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	DB6_JOB_RUNSTATS_TABLES	Table Relationship Diagram
Short Description	DB6: Parameters of Table Runstats

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	RS	☐	DB6_VIEW_RUNSTATS_CTRL		STRU	0	0
2	RB_SCHEDULED	☐			STRG	0	0
3	RB_AUTO_SCHEDULED	☐			CHAR	1	0
4	RB_USER_SCHEDULED	☐			CHAR	1	0
5	CB_PROPOSED_FOR_RUNSTATS	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
6	UPDATE_RATIO	☐			DEC	22	0
7	CB_COLLECT_FOR_APPLMON	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
8	RB_TABLE	☐			STRG	0	0
9	RB_TABLE_BASIC	☐			CHAR	1	0
10	RB_TABLE_DISTRIBUTED	☐			CHAR	1	0
11	RB_TABLE_NONE	☐			CHAR	1	0
12	CB_KEY_COLUMNS_ONLY	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
13	CB_SAMPLE_TABLE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
14	SAMPLE_TABLE_PERCENT	☐			DEC	7	5
15	RB_SAMPLING	☐			STRG	0	0
16	RB_SAMPLING_SYSTEM	☐			CHAR	1	0
17	RB_SAMPLING_BERNOULLI	☐			CHAR	1	0
18	RB_INDEX	☐			STRG	0	0
19	RB_INDEX_BASIC	☐			CHAR	1	0
20	RB_INDEX_EXTENDED	☐			CHAR	1	0
21	RB_INDEX_NONE	☐			CHAR	1	0
22	RB_INDEX_EXTENDED_SAMPLED	☐			CHAR	1	0
23	RB_STAT	☐			STRG	0	0
24	RB_NO_STAT_AND_VOLATILE	☐			CHAR	1	0
25	RB_STAT_AND_NOT_VOLATILE	☐			CHAR	1	0
26	CB_POOL_LIKE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
27	RB_USE_PROFILE	☐			CHAR	1	0
28	RB_USE_CUSTOM	☐			CHAR	1	0
29	RB_USE	☐			STRG	0	0
30	RB_IDX_SAMPLE_SYSTEM	☐			CHAR	1	0
31	RB_IDX_SAMPLE_BERNOULLI	☐			CHAR	1	0
32	RB_IDX_SAMPLE	☐			STRG	0	0
33	SAMPLE_IDX_PERCENT	☐			DEC	7	5
34	ADMSTAT	☐	DB6ADMSTAT		STRU	0	0
35	TABSCHEMA	☐	DB6SCHEMA		CHAR	20	0	DB6: Schema Name
36	TABNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
37	VWTYP	☐			CHAR	1	0
38	ACTIV	☐			CHAR	1	0
39	SAMPLSZTAB	☐			DEC	7	5
40	SAMPLE_IDX	☐			CHAR	1	0
41	SAMPLE_TAB	☐			CHAR	1	0
42	KEYCOLONLY	☐			CHAR	1	0
43	AMETH	☐			CHAR	1	0
44	VOLA_STAT	☐			CHAR	1	0
45	VOLATHRESH	☐			DEC	22	0
46	UPDRATIO	☐			DEC	22	0
47	AEDAT	☐			DATS	8	0
48	POOL_LIKE	☐			CHAR	1	0
49	SAMPLTYPE	☐			CHAR	1	0
50	SAMPLSZIDX	☐			DEC	7	5
51	SAMPLTYPEIDX	☐			CHAR	1	0
52	PARALLELISM	☐			INT4	10	0
53	TABLE_LIST	☐	DB6RUNSTATSTABLE_TAB		TTYP	0	0
54	TABLE_ALV	☐	CL_DB6_ALV_RUNSTATS_TABLE_LIST		REF	0	0

History

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