SAP Table DB2IREORG

Information for Database Reorgcheck: Indexes

The table DB2IREORG (Information for Database Reorgcheck: Indexes) is a standard table in SAP ERP. It belongs to the package STU2.

Technical Information

Table	DB2IREORG
Short Text	Information for Database Reorgcheck: Indexes
Package	STU2
Table Type	Transparent Table

Fields for Table DB2IREORG

Field Name	Key	Description	Data Element	Type	Length	Check Table
DB2IOWNER	✔	index owner		CHAR	8
DB2INAME	✔	index name		CHAR	18
DB2TOWNER		table owner (same as table schema)		CHAR	8
DB2TNAME		Table name		CHAR	18
DB2TSPACE		name of the tablespace		CHAR	18
DB2CARD		Cardinality (number of rows) in a table		CHAR	10
DB2ISIZE		size of an index		INT4	10
DB2F4		formula 4 of reorgchk analysis		CHAR	3
DB2F5		formula 5 of reorgchk analysis		CHAR	3
DB2F6		formula 6 of reorgchk analysis		CHAR	3
DB2REORG		reorgchk - recommendation		CHAR	3
DB2DATETIM		date time of last reorgchk		CHAR	26