DB4TABLE_STAT - Table Sizes in the Database

Table Sizes in the Database information is stored in SAP table DB4TABLE_STAT.
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 DB4TABLE_STAT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
DBHOST	Application Server	X	SYHOST	CHAR	32
SCHEMANAME		X		CHAR	10
TABNAME	Table name	X	TNAME	CHAR	30	*
TABNAME_LONG	Table name		TNAME	CHAR	30	*
ANDAT	Analysis date (yyyymmddhhmm)		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
RSTTIME	Character field of length 6		CHAR6	CHAR	6