File Parameters

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

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.

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 AG.

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.

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.

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.

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.

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

• Direct Access Optimization

• Read-Ahead Optimization

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.

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.

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.

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.

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.

Adabas Fastpath creates sets of direct access command models. This parameter limits the size (in KB) of data items within each set.

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.

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

• Direct Access Optimization

• Read-Ahead Optimization

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:

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.

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.