SAP ABAP Table TST04INF (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	TST04INF	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	BUFSIZETOT	☐	BUFFERSPAC	SINT4_NOS	INT4	10	0	Total size of database shared memory buffer
2	BUFREADS	☐	BUFREADSI	SINT4_NOS	INT4	10	0	Number of reads from shared memory buffer
3	DSKREADS	☐	DSKREADS	SINT4_NOS	INT4	10	0	Actual reads from disk
4	BUFWRITES	☐	BUFWRITES	SINT4_NOS	INT4	10	0	Number of writes to shared memory buffer
5	DSKWRITES	☐	DSKWRITES	SINT4_NOS	INT4	10	0	Actual number of writes to disk
6	PLGPAGEWRI	☐	PLGPAGEWRI	SINT4_NOS	INT4	10	0	Number of physical log pages written
7	PLGWRITES	☐	PLGWRITES	SINT4_NOS	INT4	10	0	Number of writes to the physical log buffer
8	LLGPAGEWRI	☐	LLGPAGEWRI	SINT4_NOS	INT4	10	0	Number of pages written to logical logs
9	LLGWRITES	☐	LLGWRITES	SINT4_NOS	INT4	10	0	Number of pages written to logical log
10	BUFPOOLFLU	☐	BUFPOOLFLU	SINT4_NOS	INT4	10	0	Number of buffer pool flushes
11	FGWRITES	☐	FGWRITES	SINT4_NOS	INT4	10	0	Number of foreground writes
12	LRUWRITES	☐	LRUWRITES	SINT4_NOS	INT4	10	0	Number of LRU writes
13	CHUNKWRITE	☐	CHUNKWRITE	SINT4_NOS	INT4	10	0	Writes resulting from a checkpoint
14	ISCOMMITS	☐	ISCOMMITS	SINT4_NOS	INT4	10	0	ISAM commits since database startup
15	ISROLLBACK	☐	ISROLLBACK	SINT4_NOS	INT4	10	0	ISAM rollbacks since database startup
16	ISAMTOT	☐	ISAMTOT	SINT4_NOS	INT4	10	0	Total number of ISAM calls since database startup
17	SEQSCANS	☐	SEQSCANS	SINT4_NOS	INT4	10	0	Number of sequential scans since database startup
18	NUMCKPTS	☐	NUMCKPTS	SINT4_NOS	INT4	10	0	Number of checkpoints since database startup
19	READQUAL	☐	READ_QUALI	SINT4_NOS	INT4	10	0	Percentage of successful reads from shared memory
20	WRITEQUAL	☐	WRITE_QUAL	SINT4_NOS	INT4	10	0	Percentage of successful writes for shared memory buffer
21	PHYSLOG_IO	☐	PAGES_IO_1	SINT4_NOS	INT4	10	0	Average number of kbytes to physical-log per write
22	LOGLOG_IO	☐	PAGES_IO_2	SINT4_NOS	INT4	10	0	Average number of kbytes to logical log per write
23	ACTIVESESS	☐	ACTIVE_SES	SINT4_NOS	INT4	10	0	Active database server sessions
24	TRANS_MIN	☐	ISCALLS_SE	SINT4_NOS	INT4	10	0	Transaction per minute
25	ISCALLS_TR	☐	ISCALLS_TR	SINT4_NOS	INT4	10	0	ISAM calls per transaction
26	CKPTCORR	☐	CORR_1	SINT4_NOS	INT4	10	0	Checkpoint activity since bootup (100% = inactive)
27	PHYSCORR	☐	CORR_2	SINT4_NOS	INT4	10	0	Physical log sizing by checkpoint
28	CORR_3	☐	CORR_3	SINT4_NOS	INT4	10	0	Logical log sizing by checkpoint
29	BUFFERS	☐	BUFFERS	SINT4_NOS	INT4	10	0	Number of regular shared memory buffers
30	PAGESIZE	☐	BUFSIZ	SINT4_NOS	INT4	10	0	System page size (KB)
31	PHYSBUFF	☐	PHYSBUFF	SINT4_NOS	INT4	10	0	Size of the two physical log buffers
32	LOGBUFF	☐	LOGBUFF	SINT4_NOS	INT4	10	0	Size of each of the three logical log buffers
33	CLEANERS	☐	CLEANERS	SINT4_NOS	INT4	10	0	Number of database buffer cleaner processes
34	LRUS	☐	LRUS	SINT4_NOS	INT4	10	0	Number of LRU queues
35	LRUMAXDIRT	☐	LRUMAXDIRT	SINT4_NOS	INT4	10	0	When to begin cleaning LRU queues
36	LRUMINDIRT	☐	LRUMINDIRT	SINT4_NOS	INT4	10	0	When to stop cleaning LRU queues
37	CKPTINTVL	☐	CKPTINTVL	SINT4_NOS	INT4	10	0	Database checkpoint interval (s)
38	NUMCPUVPS	☐	NUMCPUVPS	SINT4_NOS	INT4	10	0	Number of user (CPU) virtual processors
39	PHYSFILE	☐	PHYSFILE	SINT4_NOS	INT4	10	0	Physical log file size (KB)
40	LOGSIZ	☐	LOGSIZ	SINT4_NOS	INT4	10	0	Size of a single logical log
41	DBSERVERNA	☑	DBSERVERNA	CHAR20	CHAR	20	0	Name of database server
42	LTXHWM	☐	LTXHWM	SINT4_NOS	INT4	10	0	High watermark percentage
43	LOCKS	☐	LOCKS	SINT4_NOS	INT4	10	0	Max. number of locks
44	RA_PAGES	☐	RA_PAGES	SINT4_NOS	INT4	10	0	Number of pages to read ahead for sequential or index scans
45	RA_THRESH	☐	RA_THRESH	SINT4_NOS	INT4	10	0	Read ahead page trigger
46	RA_USED	☐	RA_USED	SINT4_NOS	INT4	10	0	Number of used pages from read ahead data
47	RA_COUNT	☐	RA_COUNT	SINT4_NOS	INT4	10	0	Total number of pages which were read ahead
48	RA_PERSCAN	☐	RA_PERSCAN	SINT4_NOS	INT4	10	0	Number of sequential scans per read ahead
49	RA_PCNT	☐	RA_PCNT	STUI_PCNT	DEC	4	1	Percentage of pages read ahead actually used
50	IDL_WRITES	☐	IDL_WRITES	SINT4_NOS	INT4	10	0	Number of idle writes
51	PC_SLEEP	☐	PC_SLEEP	SINT4_NOS	INT4	10	0	Sleep time for page cleaners
52	OVBUFF	☐	OVBUFF	SINT4_NOS	INT4	10	0	Number of unsuccessful accesses to shared memory buffer
53	SHMVIRT	☐	XMEM_ALLOC	SINT4_NOS	INT4	10	0	Amount of additional virtual shared memory
54	FLUSHCKPTS	☐	FLUSHCKPTS	SINT4_NOS	INT4	10	0	Number of buffer flushes due to checkpointing
55	SHMTOTAL	☐	TOT_SHMSIZ	SINT4_NOS	INT4	10	0	Total size of INFORMIX shared memory
56	NUMAIOVPS	☐	AIOVPS	SINT4_NOS	INT4	10	0	Number of AIO virtual processors
57	DBFILES	☐	DBFILES	SINT4_NOS	INT4	10	0	Number of disk files used for INFORMIX database
58	SHMRES	☐	RES_SHMSIZ	SINT4_NOS	INT4	10	0	Resident shared menory portion
59	SHMMES	☐	COM_SHMSIZ	SINT4_NOS	INT4	10	0	Shared memory communications portion
60	KAIOTHREAD	☐	KAIOTHREAD	SINT4_NOS	INT4	10	0	Number of kaio threads for kernel asynchronous disk I/O
61	UP_SINCE	☐	UPSINCE	INT4	INT4	10	0	Time since DB start in seconds (Informix monitor)
62	RESET_STAT	☐	RESET_STAT	INT4	INT4	10	0	Time since last reset statistics in seconds
63	PAGREADS	☐	PAGREADS	SINT4_NOS	INT4	10	0	Number of Buffer Pages Read
64	PAGWRITES	☐	PAGWRITES	SINT4_NOS	INT4	10	0	Number of Buffer Pages Written
65	BUFWTS	☐	BUFWTS	SINT4_NOS	INT4	10	0	Number of Buffer Wait Events
66	BUFWTPCNT	☐	BUFWTPCNT	STUI_PCNT	DEC	4	1	Percentage of Buffer Wait Events

History

Last changed by/on	SAP	20041216
SAP Release Created in