SAP ABAP Table DB4TABLE_HIST (History of Table Sizes in the Database)

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	TRANSP	Transparent table
Transparent table	DB4TABLE_HIST	Table Relationship Diagram
Short Description	History of Table Sizes in the Database

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	DBHOST	☑	SYHOST	HOST_ID	CHAR	32	0	Application Server
2	SCHEMANAME	☑			CHAR	10	0
3	TABNAME	☑	TNAME	AS4TAB	CHAR	30	0	Table name	*
4	ANDAT	☑	AM_DATE	CHAR12	CHAR	12	0	Analysis date (yyyymmddhhmm)
5	TABNAME_LONG	☐	TNAME	AS4TAB	CHAR	30	0	Table name	*
6	VWTYP	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
7	TABSIZE	☐	UBLOCKS_KB	DEC11	DEC	11	0	Used blocks of a table in KB
8	CURROWS	☐	OROWS	DEC15	DEC	15	0	Number of rows in a table
9	INDBS	☐	BBLOCKS_KB	DEC15	DEC	15	0	Used blocks of an index-Btree (kb)
10	DLTROWS	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
11	NUMOPEN	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
12	NUMCLOSE	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
13	NUMINSERT	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
14	NUMUPDATE	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
15	NUMDELETE	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
16	NUMLREAD	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
17	NUMPREAD	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
18	NUMCST	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
19	CSTSIZE	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
20	CRTDATE	☐	DATUM	DATUM	DATS	8	0	Date
21	CRTTIME	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
22	SAVDATE	☐	DATUM	DATUM	DATS	8	0	Date
23	SAVTIME	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
24	RSTDATE	☐	DATUM	DATUM	DATS	8	0	Date
25	RSTIME	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6

History

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