SAP Table DB2TREORG

Information for Database reorgcheck: Tables

The table DB2TREORG (Information for Database reorgcheck: Tables) is a standard table in SAP ERP. It belongs to the package STU2.

Technical Information

Table	DB2TREORG
Short Text	Information for Database reorgcheck: Tables
Package	STU2
Table Type	Transparent Table

Fields for Table DB2TREORG

Field Name	Key	Description	Data Element	Type	Length	Check Table
DB2TOWNER	✔	table owner (same as table schema)		CHAR	8
DB2TNAME	✔	Table name		CHAR	18
DB2TSPACE		name of the tablespace		CHAR	18
DB2TSIZE		table size		INT4	10
DB2F1		formula 1 for reorgchk table		CHAR	3
DB2F2		formula 2 of reorgchk analysis		CHAR	3
DB2F3		formula 3 of reorgchk analysis		CHAR	3
DB2REORG		reorgchk - recommendation		CHAR	3
DB2DATETIM		date time of last reorgchk		CHAR	26
DB2RUNTIME		runtime of last reorg		TIMS	6
DB2REODATE		date of last reorg		DATS	8
QUALNUM		DB2 OS/390: Number to generate unique qual. for DB2 object	DB2QUALNUM	NUMC	6