SAP ABAP Table TST04MEM (INFORMIX DB Monitor: Shared Memory Monitor Descriptions)

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	TST04MEM	Table Relationship Diagram
Short Description	INFORMIX DB Monitor: Shared Memory Monitor Descriptions

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	BUFREADS	☐	BUFREADSI	SINT4_NOS	INT4	10	0	Number of reads from shared memory buffer
2	BUFWRITES	☐	BUFWRITES	SINT4_NOS	INT4	10	0	Number of writes to shared memory buffer
3	DSKREADS	☐	DSKREADS	SINT4_NOS	INT4	10	0	Actual reads from disk
4	DSKWRITES	☐	DSKWRITES	SINT4_NOS	INT4	10	0	Actual number of writes to disk
5	RAPGS_USED	☐	RA_USED	SINT4_NOS	INT4	10	0	Number of used pages from read ahead data
6	BTRADATA	☐	BTRADATA	SINT4_NOS	INT4	10	0	Data pages read ahead through leaf
7	BTRAIDX	☐	BTRAIDX	SINT4_NOS	INT4	10	0	Leaf read aheads through parent
8	DPRA	☐	DPRA	SINT4_NOS	INT4	10	0	Data page read aheads
9	READ_QUALI	☐	READ_QUALI	SINT4_NOS	INT4	10	0	Percentage of successful reads from shared memory
10	WRITE_QUAL	☐	WRITE_QUAL	SINT4_NOS	INT4	10	0	Percentage of successful writes for shared memory buffer
11	READ_AHEAD	☐	READ_AHEAD	SINT4_NOS	INT4	10	0	Read ahead effectiveness
12	BUFFERS	☐	BUFFERS	SINT4_NOS	INT4	10	0	Number of regular shared memory buffers
13	DIRTY_BUFF	☐	DIRTY_BUFF	SINT4_NOS	INT4	10	0	Number of dirty buffers
14	LRUS	☐	LRUS	SINT4_NOS	INT4	10	0	Number of LRU queues
15	LRU_MAX_DI	☐	LRUMAXDIRT	SINT4_NOS	INT4	10	0	When to begin cleaning LRU queues
16	LRU_MIN_DI	☐	LRUMINDIRT	SINT4_NOS	INT4	10	0	When to stop cleaning LRU queues
17	SHMVIRTSIZ	☐	SHMVIRTSIZ	SINT4_NOS	INT4	10	0	Initial size of virtual shared memory segment
18	SHMADD	☐	XMEM_ALLOC	SINT4_NOS	INT4	10	0	Amount of additional virtual shared memory
19	SHMTOTAL	☐	SHMTOTAL	SINT4_NOS	INT4	10	0	Total amount of virtual shared memory
20	RA_PAGES	☐	RA_PAGES	SINT4_NOS	INT4	10	0	Number of pages to read ahead for sequential or index scans
21	RA_THRESHO	☐	RA_THRESH	SINT4_NOS	INT4	10	0	Read ahead page trigger

History

Last changed by/on	SAP	20041216
SAP Release Created in