SAP ABAP Table DB6PMCTBS (DB6: Tablespace Configuration Data (Calculated))

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	DB6PMCTBS	Table Relationship Diagram
Short Description	DB6: Tablespace Configuration Data (Calculated)

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	COMPTIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
2	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
3	TBS_ID	☐			DEC	22	0
4	TBS_NAME	☐	DB6TSPNAME		CHAR	30	0	DB6: Tablespace Name
5	PARTITN	☐			CHAR	5	0
6	TBS_TYPE	☐			CHAR	50	0
7	TOTALKB	☐			DEC	31	0
8	TOTALPAGES	☐			DEC	22	0
9	USABLEKB	☐			DEC	31	0
10	USABLEPGS	☐			DEC	22	0
11	USEDKB	☐			DEC	31	0
12	USEDPAGES	☐			DEC	22	0
13	PCTUSEDKB	☐			DEC	8	2
14	FREEKB	☐			DEC	31	0
15	FREEPAGES	☐			DEC	22	0
16	PCTFREEKB	☐			DEC	8	2
17	PAGESIZE	☐			DEC	22	0
18	HGHWTRMRK	☐			DEC	22	0
19	EXTSIZE	☐			DEC	22	0
20	PF_SZ	☐			DEC	22	0
21	NUM_CONT	☐			DEC	22	0
22	NUM_CONT_DLT	☐			DEC	22	0
23	CONTENTS	☐			CHAR	50	0
24	TBSSTATE	☐			CHAR	50	0
25	AUTOSTOR	☐			CHAR	3	0
26	AUTORESIZ	☐			CHAR	3	0
27	INITSIZ	☐			DEC	22	0
28	CURRSIZ	☐			DEC	22	0
29	INCRSIZABS	☐			DEC	22	0
30	INCRSIZPCT	☐			DEC	22	0
31	LASTRSZDAT	☐			DATS	8	0
32	LASTRSZTIM	☐			TIMS	6	0
33	LASTRSZFAI	☐			INT2	5	0
34	MAX_SIZE	☐			DEC	22	0
35	FS_CACHING	☐			CHAR	3	0
36	TBSP_CUR_POOL_ID	☐			DEC	22	0
37	TBSP_NXT_POOL_ID	☐			DEC	22	0
38	TBSP_PENDING_FREE_PAGES	☐			DEC	22	0
39	TBSP_MIN_RECOVERY_TIME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
40	TBSP_NUM_RANGES	☐			DEC	22	0
41	TBSP_PAGE_TOP	☐			DEC	22	0
42	RECLAIMABLE_SPACE_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
43	TBSP_PATHS_DROPPED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
44	TBSP_LAST_RESIZE_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
45	PF_SIZE_IMAGE	☐			CHAR	20	0
46	TOTALKB_DELTA	☐			DEC	31	0
47	USEDKB_DELTA	☐			DEC	31	0
48	PF_SZ_CURRENT	☐			DEC	22	0
49	FS_FREE_SIZE_MB	☐			DEC	22	0
50	TOTAL_FREE_MB	☐			DEC	22	0
51	TOTAL_USED_PERCENT	☐			DEC	8	2
52	NUM_TABLES	☐			DEC	22	0
53	NUM_TABLES_DLT	☐			DEC	22	0
54	NUM_INDEXES	☐			DEC	22	0
55	NUM_INDEXES_DLT	☐			DEC	22	0
56	TOTALKB_GB	☐			DEC	31	0
57	TOTALKB_KB	☐			DEC	31	0
58	USABLEKB_KB	☐			DEC	31	0
59	USEDKB_KB	☐			DEC	31	0
60	FREEKB_KB	☐			DEC	31	0
61	USEDKB_DELTA_KB	☐			DEC	31	0
62	TOTALKB_DELTA_KB	☐			DEC	31	0
63	TOTALKB_DELTA_MB	☐			DEC	22	2
64	TOTAL_FREE_GB	☐			DEC	22	2

History

Last changed by/on	SAP	20140117
SAP Release Created in	46D