DB2IREORG - Information for Database Reorgcheck: Indexes

Information for Database Reorgcheck: Indexes information is stored in SAP table DB2IREORG.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".

Fields for table DB2IREORG

Field Name	Description	Is Key	Data Type	Length
DB2IOWNER	index owner	X	CHAR	8
DB2INAME	index name	X	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	4
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