Version 8.1.3
 —  File Maintenance  —

Modify File Parameters

Note:
AOS in not able to modify file parameters for Adabas files incorporated in Predict. This is because AOS cannot modify the FCB of these files. Error messages are produced when such an attempt is made. We recommend that you use Predict 4.5.1 to make file parameter updates for Adabas files incorporated in Predict.

Start of instruction set To modify parameters for a file

  1. Select option "M" (modify file parameters).

  2. Specify the number of the file to be modified.

  3. If the file is protected, supply the password.

  4. Press ENTER.

    The Modify File Parameters screen is displayed:

    10:19:39         *****  A D A B A S   BASIC  SERVICES  *****       2006-07-20
     DBID 1955               -  Modify File Parameters   -              PFLM002
    
     File No. ... 1
     File Name .. EMPLOYEES
     -----------------------------------------------------------------------------
                                        Max. Allocation
     ASSO PFAC ...... 10                  UI Blks per extent .. 0
     DATA PFAC ...... 10                  NI Blks per extent .. 0
     Max. RECL ...... 4816                DS Blks per extent .. 0
    
     New File Name .. EMPLOYEES______   ISN Reuse ............. OFF
     New File No. ... 1                        with RESET ..... ___
                                               in Parallel .... NO
     User ISN ....... OFF               DS Reuse .............. ON_
                                               with RESET ..... ON_
     File Password ..                          in Parallel
                                        Mixed DS Device........ OFF
     AlphaNum Encoding .. 0             Program Refresh ....... OFF
     WideChar Encoding .. 0
    
    PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
    Help               Exit                                           Menu

    This function corresponds to the utility function ADADBS MODFCB.

    If large object (LOB) flags are set, the following screen is displayed:

    16:55:50          ***** A D A B A S  BASIC  SERVICES *****          2006-08-25
    DBID 1956                -  Modify File Parameters  -               PFLM012   
    
    File No. ... 16                                                              
    File Name .. LOBFILE                                                        
    -----------------------------------------------------------------------------
                                          Max. Allocation                     
     ASSO PFAC .......... 10                    UI Blks per extent .. 0           
     DATA PFAC .......... 10                    NI Blks per extent .. 0           
     Max. RECL .......... 5060                  DS Blks per extent .. 0           
    
     New File Name ...... LOBFILE__________   ISN Reuse ............. ON_         
     New File No. ....... 16                         with RESET ..... ___         
                                                     in Parallel .... NO_         
     User ISN ........... OFF                 DS Reuse .............. ON_         
                                                     with RESET ..... ___         
     File Password ......                            in Parallel .... NO_         
                                              Mixed DS Device ....... OFF         
     AlphaNum Encoding .. 0                   Program Refresh ....... OFF         
     WideChar Encoding .. 0                                                       
    
    PF1----- PF2------ PF3------ PF4------ PF6------ PF7----- PF8----- PF12-----  
    Help               Exit   LOB Info                                 Menu

    If you press PF4 on the screen when it displays a LOB file, a pop-up window appears showing detailed information abou the file:

    - LOB File Information -          
    
       *****************                       
    
       * File   16     *                       
    
       *****************                       
    
      File Info: LOB file                     
      Related LOB File Number ....... 15___   
    
       PF3---                                  
       Cancel

    The equivalent direct command is

    MODIFY FILE file-number

This document covers the following topics:


Change Padding Factors

Using the ASSO PFAC and the DATA PFAC fields on the Modify File Parameters screen, you can change the Associator and Data Storage padding factors for the file.

The "padding factor" is the percentage (%) of each Associator or Data Storage block that is reserved; that is, not loaded. This area is used to create new records later. The range is from 3 to 90 percent. The factor size allocated should depend on the amount of updating that is expected. The number of bytes left in the Associator after padding must exceed the largest descriptor value by at least 10.

Top of page

Change Maximum Allocation

Using the Max Allocation fields on the Modify File Parameters screen, you can change the maximum number of blocks that can be allocated for Data Storage (field DS Blks per extent), the normal index (field NI Blks per extent), or the upper index extent (field UI Blks per extent).

The value specified must be specified in blocks and cannot be more than 65535. If one of the parameters is either not specified or specifies "0", the maximum secondary extent allocation for that component has no limit.

In all cases, however, Adabas enforces minimum secondary allocations for these parameters:

DS Blks per extent=6 
NI Blks per extent=6 
UI Blks per extent=15

If you specify a value lower than these minimum allocations, the Adabas-enforced minimum value is used.

Top of page

Change Record Length

Using the Max. RECL field on the Modify File Parameters screen, you can change the maximum compressed record length allowed.

Top of page

Rename or Renumber the File

Using the New File Name and New File No. fields on the Modify File Parameters screen, you can change the name or number of the file.

The equivalent direct commands are

RENAME FILE file-number
RENUMBER FILE file-number

Top of page

Select File Options

You can also turn off or on several file options on this screen:

User ISN
ISN Reuse ...with RESET
Data Storage Reuse ...with RESET
Mix Data Storage Dev
Program Refresh

ISN Reuse and Data Storage Reuse determine whether ISNs and Data Storage blocks for deleted records are reused as new records are added to the file. The equivalent direct commands are

REUSE ISNS file-number
REUSE DS file-number

When setting either of these two options to "ON", you can also set the RESET option "ON" to start the search for an unused ISN or Data Storage block at the beginning of the file.

Top of page

Change Code Pages

If the file was loaded using universal encoding support (UES), the code values may be changed on this screen using the AlphaNum Encoding and WideChar Encoding fields.

Top of page