SAP ABAP Table INFST04 (ST04 - Informix Monitor Main List)

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	INFST04	Table Relationship Diagram
Short Description	ST04 - Informix Monitor Main List

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	SHMTOTAL	☐	SHMTOTAL	SINT4_NOS	INT4	10	0	Total amount of virtual shared memory
2	SHMRES	☐	SHMRES	SINT4_NOS	INT4	10	0	Size of Resident Portion of Shared Memory (KB)
3	SHMVIRT	☐	SHMVIRT	SINT4_NOS	INT4	10	0	Size of Virtual Portion of Shared Memory (KB)
4	SHMMES	☐	SHMMES	SINT4_NOS	INT4	10	0	Message Portion of Shared Memory(KB)
5	PAGSIZE	☐	PAGSIZE	SINT4_NOS	INT4	10	0	Informix Page Size in Bytes
6	BUFFSIZE	☐	BUFFSIZE	SINT4_NOS	INT4	10	0	Size of Data Buffer (KB)
7	BUFREADRAT	☐	BUFREADRAT	SINT4_NOS	INT4	10	0	Buffer Read Quality in %
8	BUFWRITRAT	☐	BUFWRITRAT	SINT4_NOS	INT4	10	0	Buffer Write Quality in %
9	READS	☐	INFREADS	SINT4_NOS	INT4	10	0	Total Number of Physical and Buffer Reads
10	WRITES	☐	INFWRITES	SINT4_NOS	INT4	10	0	Total Number of Writes
11	CLEANERS	☐	CLEANERS	SINT4_NOS	INT4	10	0	Number of database buffer cleaner processes
12	LRUS	☐	LRUS	SINT4_NOS	INT4	10	0	Number of LRU queues
13	LRUMAXDIRT	☐	LRUMAXDIRT	SINT4_NOS	INT4	10	0	When to begin cleaning LRU queues
14	LRUMINDIRT	☐	LRUMINDIRT	SINT4_NOS	INT4	10	0	When to stop cleaning LRU queues
15	BUFFFLUSH	☐	BUFPOOLFLU	SINT4_NOS	INT4	10	0	Number of buffer pool flushes
16	FOREWRITE	☐	FGWRITES	SINT4_NOS	INT4	10	0	Number of foreground writes
17	LRUWRITE	☐	LRUWRITES	SINT4_NOS	INT4	10	0	Number of LRU writes
18	CHUNKWRITE	☐	CHUNKWRITE	SINT4_NOS	INT4	10	0	Writes resulting from a checkpoint
19	PHYSBUFF	☐	PHYSBUFF	SINT4_NOS	INT4	10	0	Size of the two physical log buffers
20	LOGBUFF	☐	LOGBUFF	SINT4_NOS	INT4	10	0	Size of each of the three logical log buffers
21	PHYSWRITE	☐	PHYSWRITE	SINT4_NOS	INT4	10	0	Physical Log Written Per I/O (KB)
22	LOGWRITE	☐	LOGWRITE	SINT4_NOS	INT4	10	0	Logical Log Written Per I/O (KB)
23	NUMCPUVPS	☐	NUMCPUVPS	SINT4_NOS	INT4	10	0	Number of user (CPU) virtual processors
24	ACTIVESESS	☐	ACTIVE_SES	SINT4_NOS	INT4	10	0	Active database server sessions
25	ISCALL_MIN	☐	ISCALL_MIN	SINT4_NOS	INT4	10	0	ISAM Calls Per Minute
26	ISCALLS_TR	☐	ISCALLS_TR	SINT4_NOS	INT4	10	0	ISAM calls per transaction
27	ISCOMMITS	☐	ISCOMMITS	SINT4_NOS	INT4	10	0	ISAM commits since database startup
28	ISROLLBACK	☐	ISROLLBACK	SINT4_NOS	INT4	10	0	ISAM rollbacks since database startup
29	ISAMTOT	☐	ISAMTOT	SINT4_NOS	INT4	10	0	Total number of ISAM calls since database startup
30	SEQSCANS	☐	SEQSCANS	SINT4_NOS	INT4	10	0	Number of sequential scans since database startup
31	CKPTINTVL	☐	CKPTINTVL	SINT4_NOS	INT4	10	0	Database checkpoint interval (s)
32	PHYSFILE	☐	PHYSFILE	SINT4_NOS	INT4	10	0	Physical log file size (KB)
33	LOGSIZ	☐	LOGSIZ	SINT4_NOS	INT4	10	0	Size of a single logical log
34	NUMCKPTS	☐	NUMCKPTS	SINT4_NOS	INT4	10	0	Number of checkpoints since database startup
35	CHKPTCORR	☐	CHKPTCORR	SINT4_NOS	INT4	10	0	Percentage of checkpoints due to Checkpoint Interval
36	PHYSCORR	☐	PHYSCORR	SINT4_NOS	INT4	10	0	% of checkpoints which occur because physical log 75% full
37	NUMAIOVPS	☐	AIOVPS	SINT4_NOS	INT4	10	0	Number of AIO virtual processors
38	KAIOTHREAD	☐	KAIOTHREAD	SINT4_NOS	INT4	10	0	Number of kaio threads for kernel asynchronous disk I/O
39	DBFILES	☐	DBFILES	SINT4_NOS	INT4	10	0	Number of disk files used for INFORMIX database
40	CURR_TIME	☐	CURR_TIME	T	TIMS	6	0	Current time of query
41	CURR_DATE	☐	CURR_DATE	DATS	DATS	8	0	Current date at time of query
42	DB_UP_DAYS	☐	DB_UP_TIME	T	TIMS	6	0	Time of database start
43	DB_UP_HOUR	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time

History

Last changed by/on	SAP	20130604
SAP Release Created in