Start of Content Area

Object documentation RA_PAGES and RA_THRESHOLD (Informix)  Locate the document in its SAP Library structure

Definition

The RA_PAGES and RA_THRESHOLD parameters in the Informix ONCONFIG file specifies read-ahead (RA) database behavior. RA_PAGES determines how many pages are read in one input/output operation. RA_THRESHOLD determines when the database system is to read the next portion of pages.

Use

For up-to-date recommendations, see SAP Note 41360.

You can check read-ahead behavior using onstat –p .