SAP ABAP Table DB4FLESTAT (iSeries: File Statistics)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	INTTAB	Structure
Structure	DB4FLESTAT	Table Relationship Diagram
Short Description	iSeries: File Statistics

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DB4LIB	☐	QQTLN	QQTLN	CHAR	10	0	iSeries: System Name of Library (Database Monitor)
2	.INCLUDE	☐				0	0	Table Sizes in the Database
3	TABNAME	☐	TNAME	AS4TAB	CHAR	30	0	Table name	*
4	ANDAT	☐	AM_DATE	CHAR12	CHAR	12	0	Analysis date (yyyymmddhhmm)
5	VWTYP	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
6	TABSIZE	☐	UBLOCKS_KB	DEC11	DEC	11	0	Used blocks of a table in KB
7	CURROWS	☐	OROWS	DEC15	DEC	15	0	Number of rows in a table
8	INDBS	☐	BBLOCKS_KB	DEC15	DEC	15	0	Used blocks of an index-Btree (kb)
9	DLTROWS	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
10	NUMOPEN	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
11	NUMCLOSE	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
12	NUMINSERT	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
13	NUMUPDATE	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
14	NUMDELETE	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
15	NUMLREAD	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
16	NUMPREAD	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
17	NUMCST	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
18	CSTSIZE	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
19	CRTDATE	☐	DATUM	DATUM	DATS	8	0	Date
20	CRTTIME	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
21	SAVDATE	☐	DATUM	DATUM	DATS	8	0	Date
22	SAVTIME	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
23	RSTDATE	☐	DATUM	DATUM	DATS	8	0	Date
24	RSTTIME	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6

History

Last changed by/on	SAP	20130604
SAP Release Created in	610