Adabas Files, File Type A

The following topics are covered below:

Add/Modify a File

Adabas file attributes

Note:
Parameters common to all object types are described under Global Attributes. For parameters common to all file types, see Common File Attributes.

Parameters
Sequence field The descriptor to be used by Natural for logical sequential reading. Determines the sequence in which records are delivered by the READ LOGICAL statement. The GENERATE DDM function will use this field as the default READ LOGICAL field in the Natural data definition module.
Vista Access DBnr, Vista Access Fnr The L-DBnr and L-Fnr are used as database and file number for function Generate DDM if the parameter Use Vista access-nr is set to Y or T in the Generate DDM menu.
Valid values are 0 to 65535 for DBnr and Fnr. No check for uniqueness is performed.

Note:
This parameter should not be confused with the Vista parameter Vista number, which is used to identify a file uniquely within a network. See Including the Definition in the Vista Table in the section Adabas Vista in the Predict and Other Systems documentation

Adabas SQL usage File is accessible via Adabas SQL Server.

Modifying Adabas Attributes

This can only be defined via the "Contains FI" association of the object type Database.

When the node for such a type of association is expanded in the list of all documentation objects, you can select a field and choose Attributes of Link from the context menu.

Note:
If you do not modify the values in this window, the default values set in the Default Adabas Attributes screen are taken. See the Predict Administration documentation.

Base attributes

Parameters
Required attributes
Phys. file number If a database is specified, the file number is taken as a physical file number automatically if this is possible.
AssociatedLOB file number An associated LOB file can be specified for a base file containing fields of type LO. Whenever the number of an associated LOB file is entered in the Adabas attributes of a base file, an own set of Adabas attributes is stored for SAG-ADA-LOB having the specified file number.
Min ISN ADALOD LOAD parameter MINISN.
Max ISN ADALOD LOAD parameter MAXISN.

Device and Size Specification for Adabas Files

The device type and the size of the Upper Index (UI), Normal Index (NI) and Data Storage (DS) can be specified.

Four characters specify the type of device used to store this part of the file. This device type must already be defined in the Predict database object containing this file. When this device type is changed in the database, the same change should be made in every file object contained in the database.

DATA padding factor ADALOD LOAD parameter DATAPFAC.
ASSO padding factor ADALOD LOAD parameter ASSOPFAC.
Device The device type of the Upper Index (UI), Normal Index (NI) and Data Storage (DS). The device type for Data Storage is ADALOD LOAD parameter DSDEV.
Size (Cylinders/Blocks) ADALOD LOAD parameters UISIZE (Upper Index), NISIZE (Normal Index) and DSSIZE (Data Storage).

Note:
See also Extent Allocation.

Loading attributes
Max recl. ADALOD LOAD parameter MAXRECL.
ISN reusage ADALOD LOAD parameter ISNREUSE.
User ISN ADALOD LOAD parameter USERISN.
One AC extent ADALOD LOAD parameter NOACEXTENSION.
DS reusage ADALOD LOAD parameter DSREUSE.
Maximum secondary allocation ADALOD LOAD parameters MAXUI (Upper Index), MAXNI (Normal Index) and MAXDS (Data Storage).

For attributes on the Base Attibutes tab not described in this section, see Miscellaneous Attributes.

Phys. distribution attr.

This can only be defined via the "Contains FI" association of the object type Database.

When the node for such a type of association is expanded in the list of all documentation objects, you can select a field and choose Attributes of Link from the context menu.

Parameters
Phys. distribution type
The types for the physical file are limited by the logical distribution type, as shown below:
Physical distribution Type Logical distribution Type
E expanded E expanded
P partitioned P partitioned
blank simple File any

Adabas Security Definition

This can only be defined via the "Contains FI" association of the object type Database.

When the node for such a type of association is expanded in the list of all documentation objects, you can select a field and choose Attributes of Link from the context menu.

Adabas security definition

Parameters
Access level The Adabas access security level of the file.
Update level The Adabas update security level of the file.

Base attributes

Parameters
Ciphered
Y The file is a ciphered file.
Length Owner ID Length of internal Owner ID of a multi-client file.
Refresh from program Adabas parameter PGMREFRESH. See the Adabas DBA documentation.
Automatic allocation
Y Adabas will automatically allocate and deallocate extents. See the Adabas Reference documentation.
PLOG
Y Database runs with protection log. UNIX only.
ISN Size

Length of ISN.

Valid values: 0, 2, 3 and 4.

For Adabas/UNIX: 0, 2 and 4 are valid.

For mainframes: 0, 3 and 4 are valid.
Erase
Y For Adabas/UNIX. All index and data storage blocks are overwritten with zeroes when they are returned to the free space table.
Index compression
Y Adabas reduces space requirements for the index and for data storage by removing redundant information on an individual descriptor basis.
No BT file
Y Exclude file from BACKOUT TRANSACTION processing.
Record spanning
Spanned When record spanning is enabled, the size of compressed records in a file may exceed the maximum data storage block size. Default is Y.
Max secondary ISN Defines the initial size of secondary ISNs.
Secondary start RABN If spanned records are used, a secondary address converter is used to map the secondary ISNs to the RABNs of the Data Storage blocks where the secondary records are stored.
Max occ system fields This parameter specifies the maximum number of values generated for a system-generated multiple-value field.

For attributes on the Base Attibutes tab not described in this section, see Modifying Adabas Attributes.

Extent Allocation - Size Specifications For More Than One Extent

This can only be defined via the "Contains FI" association of the object type Database.

When the node for such a type of association is expanded in the list of all documentation objects, you can select a field and choose Attributes of Link from the context menu.

More than one extent can be specified.

The size and first RABN (Start) of the Address Converter (AC), Upper Index (UI), Normal Index (NI) and Data Storage (DS) can be specified for up to 99 extents. The scroll bars are activated when more than one extent has been specified.

Extent allocation

Modifying ADAM Descriptor Definition

This can only be defined via the "Contains FI" association of the object type Database.

When the node for such a type of association is expanded in the list of all documentation objects, you can select a field and choose Attributes of Link from the context menu.

Adabas security definition

Parameters
ADAM descriptor Fields to be used as ADAM descriptor.
ADALOD LOAD parameter ADAMDE.
ADAM parm ADALOD LOAD parameter ADAMPARM.
ADAM overflow ADALOD LOAD parameter ADAMOFLOW.

Encodings

This can only be defined via the "Contains FI" association of the object type Database.

When the node for such a type of association is expanded in the list of all documentation objects, you can select a field and choose Attributes of Link from the context menu.

Universal encoding support of an Adabas file can be defined in the tab shown below.

Note:
See the Adabas Administration documentation for further information on this topic.