SAP ABAP Table TST04HIST (Statistics: Structure for Database Information Display)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-INF (Application Component) Informix
     ⤷ STUI (Package) Informix Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	TST04HIST	Table Relationship Diagram
Short Description	Statistics: Structure for Database Information Display

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
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	BUFREADS	☐	BUFREADS64	STUI_INT64	DEC	18	0	Number of reads from shared memory buffer
2	DSKREADS	☐	DSKREADS64	STUI_INT64	DEC	18	0	Actual reads (I/O requests) from disk
3	BUFWRITES	☐	BUFWRITS64	STUI_INT64	DEC	18	0	Number of writes to shared memory buffer
4	DSKWRITES	☐	DSKWRITS64	STUI_INT64	DEC	18	0	Actual number of writes (I/O requests) to disk
5	LLGPAGEWRI	☐	LLGPGWRI64	STUI_INT64	DEC	18	0	Number of logical log pages written
6	FGWRITES	☐	FGWRITES64	STUI_INT64	DEC	18	0	Number of foreground writes
7	LRUWRITES	☐	LRUWRITS64	STUI_INT64	DEC	18	0	Number of lru writes
8	CHUNKWRITE	☐	CHKWRITS64	STUI_INT64	DEC	18	0	Writes resulting from a checkpoint
9	ISCOMMITS	☐	ISCOMMIT64	STUI_INT64	DEC	18	0	ISAM commits since database startup
10	ISROLLBACK	☐	ISROLLBK64	STUI_INT64	DEC	18	0	ISAM rollbacks since database startup
11	SEQSCANS	☐	SEQSCANS64	STUI_INT64	DEC	18	0	Number of sequential scans
12	NUMCKPTS	☐	NUMCKPTS	SINT4_NOS	INT4	10	0	Number of checkpoints since database startup
13	RA_USED	☐	RA_USED64	STUI_INT64	DEC	18	0	Read ahead pages used
14	RA_COUNT	☐	RA_COUNT64	STUI_INT64	DEC	18	0	Sum of read ahead pages
15	BUFWTS	☐	BUFWAITS64	STUI_INT64	DEC	18	0	Number of Buffer Wait Events
16	ISAMREADS	☐	ISREADS64	STUI_INT64	DEC	18	0	ISAM Read Calls
17	ISAMSTARTS	☐	ISSTARTS64	STUI_INT64	DEC	18	0	ISAM Start Calls (Index read)
18	MEMSORTS	☐	MEMSORTS	STUI_INT64	DEC	18	0	Number of Sort Events in Memory
19	DISKSORTS	☐	DISKSORTS	STUI_INT64	DEC	18	0	Number of Sort Events in Memory
20	LOCKWAITS	☐	LOCKWAIT64	STUI_INT64	DEC	18	0	Number of Lock Wait Events
21	LOCKREQS	☐	LOCKREQS64	STUI_INT64	DEC	18	0	Number of Lock Requests

History

Last changed by/on	SAP	20041216
SAP Release Created in	700