SAP ABAP Table DB6PMSR (DB6: Table Reorg Snapshot)

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	DB6PMSR	Table Relationship Diagram
Short Description	DB6: Table Reorg Snapshot

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	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
2	PARTITN	☐			INT4	10	0
3	TAB_SCHEMA	☐	DB6SCHEMA		CHAR	20	0	DB6: Schema Name
4	TABLE_NAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
5	CALLERFLAG	☐			CHAR	1	0
6	DBMSTRTTME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
7	PRGVERS	☐			CHAR	20	0
8	PG_REORGS	☐			DEC	22	0
9	REORG_PHASE	☐			CHAR	50	0
10	REORG_MAX_PHASE	☐			DEC	22	0
11	REORG_CURRENT_COUNTER	☐			DEC	22	0
12	REORG_MAX_COUNTER	☐			DEC	22	0
13	REORG_TYPE	☐			STRG	0	0
14	ONLINE	☐			CHAR	10	0
15	ACCESS_MODE	☐			CHAR	10	0
16	RECLUSTER	☐			CHAR	10	0
17	REORG_LOB	☐			CHAR	10	0
18	NO_TRUNCATE	☐			CHAR	10	0
19	REORG_STATUS	☐			CHAR	50	0
20	REORG_COMPLETION	☐			CHAR	50	0
21	REORG_START	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
22	REORG_END	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
23	REORG_PHASE_START	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
24	REORG_INDEX_ID	☐			DEC	22	0
25	REORG_TBSPC_ID	☐			DEC	22	0
26	REORG_LONG_TBSPC_ID	☐			DEC	22	0
27	REORG_ROWSCOMPRESSED	☐			DEC	22	0
28	REORG_ROWSREJECTED	☐			DEC	22	0
29	REORG_STATUS_FLAG	☐			INT2	5	0

History

Last changed by/on	SAP	20110908
SAP Release Created in	700