SAP ABAP Table DB6_VIEW_TSP_MAINTENANCE (DB6: View Data of Single Tablespace Maintenance)

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_TSP_MAINTENANCE	Table Relationship Diagram
Short Description	DB6: View Data of Single Tablespace Maintenance

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	CUR_TSP	☐	DB6PMCTBS		STRU	0	0
2	COMPTIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
3	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
4	TBS_ID	☐			DEC	22	0
5	TBS_NAME	☐	DB6TSPNAME		CHAR	30	0	DB6: Tablespace Name
6	PARTITN	☐			CHAR	5	0
7	TBS_TYPE	☐			CHAR	50	0
8	TOTALKB	☐			DEC	31	0
9	TOTALPAGES	☐			DEC	22	0
10	USABLEKB	☐			DEC	31	0
11	USABLEPGS	☐			DEC	22	0
12	USEDKB	☐			DEC	31	0
13	USEDPAGES	☐			DEC	22	0
14	PCTUSEDKB	☐			DEC	8	2
15	FREEKB	☐			DEC	31	0
16	FREEPAGES	☐			DEC	22	0
17	PCTFREEKB	☐			DEC	8	2
18	PAGESIZE	☐			DEC	22	0
19	HGHWTRMRK	☐			DEC	22	0
20	EXTSIZE	☐			DEC	22	0
21	PF_SZ	☐			DEC	22	0
22	NUM_CONT	☐			DEC	22	0
23	NUM_CONT_DLT	☐			DEC	22	0
24	CONTENTS	☐			CHAR	50	0
25	TBSSTATE	☐			CHAR	50	0
26	AUTOSTOR	☐			CHAR	3	0
27	AUTORESIZ	☐			CHAR	3	0
28	INITSIZ	☐			DEC	22	0
29	CURRSIZ	☐			DEC	22	0
30	INCRSIZABS	☐			DEC	22	0
31	INCRSIZPCT	☐			DEC	22	0
32	LASTRSZDAT	☐			DATS	8	0
33	LASTRSZTIM	☐			TIMS	6	0
34	LASTRSZFAI	☐			INT2	5	0
35	MAX_SIZE	☐			DEC	22	0
36	FS_CACHING	☐			CHAR	3	0
37	TBSP_CUR_POOL_ID	☐			DEC	22	0
38	TBSP_NXT_POOL_ID	☐			DEC	22	0
39	TBSP_PENDING_FREE_PAGES	☐			DEC	22	0
40	TBSP_MIN_RECOVERY_TIME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
41	TBSP_NUM_RANGES	☐			DEC	22	0
42	TBSP_PAGE_TOP	☐			DEC	22	0
43	RECLAIMABLE_SPACE_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
44	TBSP_PATHS_DROPPED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
45	TBSP_LAST_RESIZE_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
46	PF_SIZE_IMAGE	☐			CHAR	20	0
47	TOTALKB_DELTA	☐			DEC	31	0
48	USEDKB_DELTA	☐			DEC	31	0
49	PF_SZ_CURRENT	☐			DEC	22	0
50	FS_FREE_SIZE_MB	☐			DEC	22	0
51	TOTAL_FREE_MB	☐			DEC	22	0
52	TOTAL_USED_PERCENT	☐			DEC	8	2
53	NUM_TABLES	☐			DEC	22	0
54	NUM_TABLES_DLT	☐			DEC	22	0
55	NUM_INDEXES	☐			DEC	22	0
56	NUM_INDEXES_DLT	☐			DEC	22	0
57	TOTALKB_GB	☐			DEC	31	0
58	TOTALKB_KB	☐			DEC	31	0
59	USABLEKB_KB	☐			DEC	31	0
60	USEDKB_KB	☐			DEC	31	0
61	FREEKB_KB	☐			DEC	31	0
62	USEDKB_DELTA_KB	☐			DEC	31	0
63	TOTALKB_DELTA_KB	☐			DEC	31	0
64	TOTALKB_DELTA_MB	☐			DEC	22	2
65	TOTAL_FREE_GB	☐			DEC	22	2
66	CUR_TSP_CAT	☐	DB6CATTSP		STRU	0	0
67	DEFINER	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
68	TBS_NAME	☐	DB6TSPNAME		CHAR	30	0	DB6: Tablespace Name
69	TBS_ID	☐			INT4	10	0
70	TBS_TYPE	☐			CHAR	1	0
71	DATA_TYPE	☐			CHAR	1	0
72	EXTSIZE	☐			DEC	22	0
73	PF_SIZE	☐			DEC	22	0
74	OVERHEAD	☐			DEC	5	1
75	TRANSFER	☐			DEC	5	1
76	PAGESIZE	☐			DEC	22	0
77	NGNAME	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
78	BUFFERPOOL	☐	DB6IDENT		CHAR	20	0	DB6: General identifier
79	DROPRECOV	☐			CHAR	1	0
80	SGNAME	☐			STRG	0	0
81	CUR_CONTAINERS	☐	DB6ADMCTR_LIST		TTYP	0	0
82	NODEGROUPS	☐	DBA_LISTBOX_LIST		TTYP	0	0
83	BUFFERPOOLS	☐	DBA_LISTBOX_LIST		TTYP	0	0
84	PAGESIZE	☐			INT4	10	0
85	PAGESIZES	☐	DBA_LISTBOX_LIST		TTYP	0	0
86	PREFETCH_SIZE	☐			CHAR	9	0
87	RESIZE_SIZE_FOR_ALL	☐			DEC	22	0
88	RB_TYPE	☐			STRG	0	0
89	RB_TYPE_REGULAR	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
90	RB_TYPE_LOB	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
91	RB_TYPE_USERTEMP	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
92	RB_TYPE_SYSTEMP	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
93	RB_MGMT	☐			STRG	0	0
94	RB_MGMT_DMS	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
95	RB_MGMT_SMS	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
96	RB_MGMT_AUTO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
97	CB_AUTORESIZE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
98	DROPPED_TABLE_ON	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
99	FIRST_GRID_DISPLAY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
100	ADD_EMPTY_LINES	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
101	REFRESH_IN_DISPLAY_MODE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
102	KEEP_DATA	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
103	RB_INCREASE_ABS	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
104	RB_INCREASE_REL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
105	MAX_SIZE	☐			STRG	0	0
106	AUTOSTORAGE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
107	CB_FS_CACHING	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
108	CB_MGMT_AUTO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
109	RB_INCREASE	☐			STRG	0	0
110	RB_INCREASE_AUTO	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
111	TBSP_RANGE	☐	DB6_TABLESPACE_RANGE		TTYP	0	0
112	SHOW_MAP_TABLE	☐			STRG	0	0
113	TBSP_RANGE_TABLE	☐	DB6_TABLESPACE_RANGE_TBL		TTYP	0	0
114	STORAGE_GROUP_LIST	☐	DBA_LISTBOX_LIST		TTYP	0	0

History

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