SAP ABAP Table DB6_VIEW_COMPRESSION_DETAIL (DB6: View Data of Compression Details)

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_VIEW_COMPRESSION_DETAIL	Table Relationship Diagram
Short Description	DB6: View Data of Compression Details

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	CURRENT	☐	DB6_COMPRESSED_TABLE_ENTRY		STRU	0	0
2	TABSCHEMA	☐			STRG	0	0
3	TABNAME	☐			STRG	0	0
4	DATA_COMPRESSION	☐			CHAR	1	0
5	DATA_COMPRESSION_MODE	☐			STRG	0	0
6	INDEX_COMPRESSION	☐			CHAR	1	0
7	TABLE_SAVED_SIZE	☐			DEC	22	0
8	TABLE_TOTAL_SIZE	☐			DEC	22	0
9	TABLE_SAVED_PCT	☐			DEC	5	0
10	DATA_TOTAL_SIZE	☐			DEC	22	0
11	DATA_SAVED_SIZE	☐			DEC	22	0
12	DATA_SAVED_PCT	☐			DEC	5	0
13	DATA_SAVED_SIZE_ADAPTIVE	☐			DEC	22	0
14	DATA_SAVED_PCT_ADAPTIVE	☐			DEC	5	0
15	INDEX_TOTAL_SIZE	☐			DEC	22	0
16	INDEX_SAVED_SIZE	☐			DEC	22	0
17	INDEX_SAVED_PCT	☐			DEC	5	0
18	CHECK_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
19	CHECK_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
20	PROPOSED_ACTION	☐			STRG	0	0
21	ROWS_READ	☐			DEC	22	0
22	ROWS_WRITTEN	☐			DEC	22	0
23	ESTIMATE	☐	DB6_COMPRESSED_TABLE_ENTRY		STRU	0	0
24	TABSCHEMA	☐			STRG	0	0
25	TABNAME	☐			STRG	0	0
26	DATA_COMPRESSION	☐			CHAR	1	0
27	DATA_COMPRESSION_MODE	☐			STRG	0	0
28	INDEX_COMPRESSION	☐			CHAR	1	0
29	TABLE_SAVED_SIZE	☐			DEC	22	0
30	TABLE_TOTAL_SIZE	☐			DEC	22	0
31	TABLE_SAVED_PCT	☐			DEC	5	0
32	DATA_TOTAL_SIZE	☐			DEC	22	0
33	DATA_SAVED_SIZE	☐			DEC	22	0
34	DATA_SAVED_PCT	☐			DEC	5	0
35	DATA_SAVED_SIZE_ADAPTIVE	☐			DEC	22	0
36	DATA_SAVED_PCT_ADAPTIVE	☐			DEC	5	0
37	INDEX_TOTAL_SIZE	☐			DEC	22	0
38	INDEX_SAVED_SIZE	☐			DEC	22	0
39	INDEX_SAVED_PCT	☐			DEC	5	0
40	CHECK_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
41	CHECK_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
42	PROPOSED_ACTION	☐			STRG	0	0
43	ROWS_READ	☐			DEC	22	0
44	ROWS_WRITTEN	☐			DEC	22	0
45	SUMMARY	☐	DB6_COMPRESSED_TABLE_ENTRY		STRU	0	0
46	TABSCHEMA	☐			STRG	0	0
47	TABNAME	☐			STRG	0	0
48	DATA_COMPRESSION	☐			CHAR	1	0
49	DATA_COMPRESSION_MODE	☐			STRG	0	0
50	INDEX_COMPRESSION	☐			CHAR	1	0
51	TABLE_SAVED_SIZE	☐			DEC	22	0
52	TABLE_TOTAL_SIZE	☐			DEC	22	0
53	TABLE_SAVED_PCT	☐			DEC	5	0
54	DATA_TOTAL_SIZE	☐			DEC	22	0
55	DATA_SAVED_SIZE	☐			DEC	22	0
56	DATA_SAVED_PCT	☐			DEC	5	0
57	DATA_SAVED_SIZE_ADAPTIVE	☐			DEC	22	0
58	DATA_SAVED_PCT_ADAPTIVE	☐			DEC	5	0
59	INDEX_TOTAL_SIZE	☐			DEC	22	0
60	INDEX_SAVED_SIZE	☐			DEC	22	0
61	INDEX_SAVED_PCT	☐			DEC	5	0
62	CHECK_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
63	CHECK_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
64	PROPOSED_ACTION	☐			STRG	0	0
65	ROWS_READ	☐			DEC	22	0
66	ROWS_WRITTEN	☐			DEC	22	0
67	MESSAGE	☐			STRG	0	0
68	DELTA_SIZE	☐			DEC	22	0
69	DELTA_PCT_FROM_CURRENT	☐			DEC	5	0
70	TOTAL_NEW_SAVINGS_SIZE	☐			DEC	22	0
71	TOTAL_NEW_SAVINGS_PCT	☐			DEC	5	0
72	UNCOMPRESSED_SIZE	☐			DEC	22	0

History

Last changed by/on	SAP	20140117
SAP Release Created in	730