SAP ABAP Data Element WRITE_QUAL (Percentage of successful writes for shared memory buffer)

Hierarchy

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

Basic Data

Data Element	WRITE_QUAL
Short Description	Percentage of successful writes for shared memory buffer

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	SINT4_NOS
Data Type	INT4	4-byte integer, integer number with sign
Length	10
Decimal Places	0
Output Length	10
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	0
Medium	0
Long	0
Heading	0

Documentation

Definition

The write quality percentage number is a measure of how much the information needing update is successfully buffered. At system startup, database and shared memory buffer access statistics are refreshed and begin to again compile. Therefore, care must be taken such that this number is not intertpeted too close to system start time where the lack of activity will not show an accurate representation. Database performance is maximal the closer this number approaches 100 percent.

If the cached write percentage is lower than 82 percent, you might be able to improve performance by increasing the LRU_MAX_DIRTY and LRU_MIN_DIRTY parameters. They can be located in the Informix ONCONFIG* parameter file located in the $INFORMIXDIR/etc directory.

History

Last changed by/on	SAP	20010130
SAP Release Created in