File Parameters

#### Search Results

Search

# File Parameters

File parameters control the optimization of specific files. Some file parameters can override buffer parameter settings when applied to a specific file.

File Parameters
`Additional Encodings`
`Cache Secure File`
`Default Pacing Rate`
`Direct Access Optimization`
`End Time`
`Expanded File`
`Initial Status`
`L1/L2/L3 Read; L9 Histogram`
`Password Secure File DA-Caching`
`RB Length Limit`
`Read-Ahead Optimization`
`Set Concurrency`
`Set ID Length Limit`
`Set Limit`
`Start Time`
`S1/S2 FIND; S8/S9 Sort ISN List`
`Update Sensitivity`

## Additional Encodings

Parameter Type | Use | Possible Values | Default
--- | --- | --- | ---
File | Controls whether data in a character encoding other than that used by the database/file to hold the data can be cached. The Default of this parameter value is defined by the value of the Buffer parameter. | Default None All Single byte ascii Single byte ebcdic Double byte ascii Double byte ebcdic | Buffer Parameter value

## Cache Secure File

Parameter Type | Use | Possible Values | Default
--- | --- | --- | ---
File | Records cached by Adabas Fastpath become available to all sessions. Files that are password protected are not normally cached. This field may be set to Y and a password provided in the Password Secure DA-Caching file parameter to allow the caching of such files. Use of this parameter is to be carefully considered and only used where the risk to secure data is acceptable. | Y or N | N

## Default Pacing Rate

Parameter Type | Use | Possible Values | Default
--- | --- | --- | ---
File | Expressed as a percentage, this parameter controls the rate at which housekeeping is performed by FASTABM. If a value of 0 is entered, then the Buffer parameter value is assumed. It is recommended this parameter is only modified when you are instructed to do so by Software GmbH. | 0-100 | 0

## Direct Access Optimization

Parameter Type | Use | Possible Values | Default
--- | --- | --- | ---
File | Defines the direct access optimization settings at the file level for Adabas commands: `L1`: Get ISN `L3`: Read Logical `L9`: Histogram `S1`: Find `S2`: Find Sorted Each command type may have optimization set ON or OFF. In addition, this setting may have up to seven field level overrides which can be achieved by inserting the Adabas two-character field name(s) on the appropriate command line. For `L3,L9,S1,S2` commands, when optimization is set ON, field level overrides indicate that commands using that field are not to be optimized. OFF, field level overrides indicate that commands using that field are to be optimized. | ON | OFF | OFF

## End Time

Parameter Type | Use | Minimum | Maximum | Default
--- | --- | --- | --- | ---
File | Indicates the time that optimization is to be ended. File start and end times define the period for which the file parameters are to be used for optimization. The start and end times are continuously monitored and the file parameters are switched on/off dynamically. It is also possible to define various file parameters each with a different start and end time period. Note The values 00:00 and 24:00 have the same meaning; that is, midnight. | 00:00 | 24:00 | none

## Expanded File

Parameter Type | Use | Possible Values | Default
--- | --- | --- | ---
File | This parameter must be defined (no default) and tells Adabas Fastpath whether or not the Adabas file is defined as 'expanded'. If this parameter is set to Y, direct access optimization for `L3` or `L9` commands for the file are not permitted. For more information on expanded files, refer to the Adabas documentation. | Y | N | none

## Initial Status

Parameter Type | Use | Possible Values | Default
--- | --- | --- | ---
File | Controls the activation of file parameters. If the setting is OFF, the file parameters are inactive. The setting must be changed to ON and SYSAFP must be used to stop/start the file. | ON | OFF | ON

## L1/L2/L3 Read; L9 Histogram

The use of these parameters is described in the descriptions of the following parameters:

Parameter Type | Use
--- | ---
File | The use of these parameters is described in the descriptions of the following parameters: Direct Access Optimization Read-Ahead Optimization

## Password For Secure File DA-Caching

Parameter Type | Use | Possible Values | Default
--- | --- | --- | ---
File | Used in combination with the Cache Secure File file parameter, this field allows for specifying the 8-character password required for access to the secured file. | 1-8 char | 0

## RB Length Limit

Parameter Type | Use | Minimum | Maximum | Default
--- | --- | --- | --- | ---
File | Restricts the size of buffer used for evaluating data for direct access optimization. A file parameter value can be used to restrict the buffer parameter setting. A file parameter with a value of zero is ignored. | 16 | 32768 | Buffer Parameter value

## Read-Ahead Optimization

Parameter Type | Use | Possible Values | Default
--- | --- | --- | ---
File | Defines the read-ahead optimization settings at the file level for Adabas commands: `L1: Get ISN` `L2: Read Physical` `L3: Read Logical` `L9: Histogram` `S1: Find` `S2: Find Sorted` `S8: Process ISN List` `S9: Sort ISN List` Each command type may have optimization set ON or OFF. In addition, this setting may have up to seven field level overrides which can be achieved by inserting the Adabas two-character field name(s) on the appropriate command line. When optimization is set ON, field level overrides indicate that commands using that field are not to be optimized. OFF, field level overrides indicate that commands using that field are to be optimized. | ON | OFF | OFF

## Set Concurrency

Parameter Type | Use | Minimum | Maximum | Default
--- | --- | --- | --- | ---
File | This parameter indicates the number of concurrent retrievals which can occur from each set of direct access data created by Adabas Fastpath. A file parameter value can be used to restrict the buffer parameter setting. A file parameter with a value of zero is ignored. | 1 | 16 | Buffer Parameter value

## Set ID Length Limit

Parameter Type | Use | Minimum | Maximum | Default
--- | --- | --- | --- | ---
File | Adabas Fastpath uses direct access set identifiers which contain search and format data for direct access command models. This parameter limits the size of data items within each set. A file parameter value can be used to restrict the buffer parameter setting. A file parameter with a value of zero is ignored. | 256 | 16384 | Buffer Parameter value

## Set Limit

Parameter Type | Use | Minimum | Maximum | Default
--- | --- | --- | --- | ---
File | Adabas Fastpath creates sets of direct access command models. This parameter limits the size (in KB) of data items within each set. | 0 |  | 0

## Start Time

Parameter Type | Use | Minimum | Maximum | Default
--- | --- | --- | --- | ---
File | Indicates the time that optimization is to be started. File start and end times define the period for which the file parameters are to be used for optimization. The start and end times are continuously monitored and the file parameters are switched on/off dynamically. It is also possible to define various file parameters each with a different start and end time period. Note The values 00:00 and 24:00 have the same meaning; that is, midnight. | 00:00 | 24:00 | none

## S1/S2 FIND; S8/S9 Sort ISN List

Parameter Type | Use
--- | ---
File | The use of these parameters is described in the descriptions of the following parameters: Direct Access Optimization Read-Ahead Optimization

## Update Sensitivity

Parameter Type | Use | Possible Values | Default
--- | --- | --- | ---
File | This parameter is used to control how update type commands are to be processed for a file. The effect of these parameter values differ based on the location of the Fastpath Buffer Manager relative to the file, as follows: | N | R | F | D | R
Fastpath Buffer Manager local to the file:
N (none) | Update type commands are ignored for data held in the Fastpath Buffer. Warning Do not use this setting if using direct-access optimization.
F (file level) | Update type commands will cause removal of all file-related data held in the Fastpath Buffer.
R (record level) D (distributed record level | Update type commands will cause removal of the affected data held in the Fastpath Buffer.
Fastpath Buffer Manager remote to the file:
N (none) F (file level) R (record level) | Update type commands will not cause removal of data held in the Fastpath Buffer so direct-access optimization will be disabled.
D (distributed record level) | Update type commands will cause removal of the affected data held in the Fastpath Buffer.
Special Note for D (distributed record level) | This setting is automatically set at runtime for ALS databases. Otherwise use only on advice from Software AG. Refer to Update Processing for information on how Adabas Fastpath processes update type commands.

### On this page

- Additional Encodings
- Cache Secure File
- Default Pacing Rate
- Direct Access Optimization
- End Time
- Expanded File
- Initial Status
- L1/L2/L3 Read; L9 Histogram
- Password For Secure File DA-Caching
- RB Length Limit
- Read-Ahead Optimization
- Set Concurrency
- Set ID Length Limit
- Set Limit
- Start Time
- S1/S2 FIND; S8/S9 Sort ISN List
- Update Sensitivity