SAP ABAP Table DB6_JOB_STATSVIEW_UPDATE (DB6: Parameters for StatsView Update)

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_STATSVIEW_UPDATE	Table Relationship Diagram
Short Description	DB6: Parameters for StatsView Update

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

History

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