DBSTATHDB4 - History of Table Sizes in the Database

History of Table Sizes in the Database information is stored in SAP table DBSTATHDB4.
It is part of development package STU4 in software component BC-DB-DB4. This development package consists of objects that can be grouped under "CCMS / AS/400".

Fields for table DBSTATHDB4

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
TABNAME	Table name	X	TNAME	CHAR	30	*
ANDAT	Analysis date (yyyymmddhhmm)	X	AM_DATE	CHAR	12
VWTYP	Single-Character Flag		CHAR1	CHAR	1
TABSIZE	Used blocks of a table in KB		UBLOCKS_KB	DEC	6
CURROWS	Number of rows in a table		OROWS	DEC	8
INDBS	Used blocks of an index-Btree (kb)		BBLOCKS_KB	DEC	8
DLTROWS	iSeries: Number of rows / object size		DB4_ANZ15	DEC	8
NUMOPEN	iSeries: Number of rows / object size		DB4_ANZ15	DEC	8
NUMCLOSE	iSeries: Number of rows / object size		DB4_ANZ15	DEC	8
NUMINSERT	iSeries: Number of rows / object size		DB4_ANZ15	DEC	8
NUMUPDATE	iSeries: Number of rows / object size		DB4_ANZ15	DEC	8
NUMDELETE	iSeries: Number of rows / object size		DB4_ANZ15	DEC	8
NUMLREAD	iSeries: Number of rows / object size		DB4_ANZ15	DEC	8
NUMPREAD	iSeries: Number of rows / object size		DB4_ANZ15	DEC	8
NUMCST	iSeries: Number of rows / object size		DB4_ANZ15	DEC	8
CSTSIZE	iSeries: Number of rows / object size		DB4_ANZ15	DEC	8
CRTDATE	Date		DATUM	DATS	8
CRTTIME	Character field of length 6		CHAR6	CHAR	6
SAVDATE	Date		DATUM	DATS	8
SAVTIME	Character field of length 6		CHAR6	CHAR	6
RSTDATE	Date		DATUM	DATS	8
RSTIME	Character field of length 6		CHAR6	CHAR	6