15.00 - StandAloneReadAheadCount - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

StandAloneReadAheadCount

Purpose  

Specifies the number of data blocks beyond the current block that will be preloaded into memory during the following sequential scan operations:

  • File system startup
  • Ferret and Filer utility operations, such as SCANDISK, that occur when Teradata Database is not running
  • Note: To enable the read-ahead feature, the ReadAhead field must be set to TRUE.

    Field Group

    Performance

    Valid Range

    1 through 100 blocks

    Default

    20 blocks

    Changes Take Effect

    After the DBS Control record has been written.

    Usage Notes  

    The number of data blocks to be preloaded during Ferret and Filer operations when Teradata Database is running is determined by the UtilityReadAheadCount setting.

    Related Topics

  • “ReadAhead” on page 416
  • “Read Ahead Count” on page 418
  • “UseVirtualSysDefault” on page 478