Selecting (option ) from the Adabas Online System invokes the menu:
12:37:27 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
- File Maintenance - PFL0004
Code Service Code Service
---- -------------------------------- ---- --------------------------------
C Define/modify FDT M Modify file parameters
D Release descriptor O Reorder file online
E Delete existing file R Refresh file to empty status
F Define new file S Allocate/deallocate file space
L Logically delete/undel descriptr X Maintain expanded files
? Help . Exit
---- -------------------------------- ---- --------------------------------
Code ......... _
File No ...... 0 Descriptor Name .. __
Database ID .. 1955 (WIS1955)
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu
Û 14,025 |
Options (Define/modify FDT) and (Maintain expanded files) on this menu display additional menus. The other file maintenance options require you to enter a valid file number and database ID. Option (Release descriptor) also requires that you specify the name of the descriptor to be released.
From the menu, you can perform any of the following functions, selectable by menu option:
| Option | Function |
|---|---|
| C | Defining or Modifying the FDT allows you to change the length of a field; add a field to a file; create a new field definition table (FDT); or create a special descriptor table (SDT). |
| D | Releasing a Descriptor allows you to release a field from descriptor status by freeing the specified field's inverted list in the Associator. |
| E | Deleting an Adabas File allows you to free extents used by an existing Adabas file. |
| F | Defining a New File allows you to define a new database file for which an FDT has already been created. |
| L | Logically Deleting or Undeleting a Descriptor allows you to logically delete or undelete a descriptor field. |
| M | Modifying File Parameters allows you to modify the padding factor, the maximum compressed record length, file number, file name, extent allocation for NI/UI/AC/DS, ISN reusage, and DS reusage. |
| O | Reordering a File Online allows you to start a process to reorder the Associator, Data Storage, or the entire file. |
| R | Refreshing a File to Empty Status allows you to delete all file records and assign a single extent to each file component. |
| S | Allocating or Deallocating File Space allows you to create or remove extents for the address converter, normal and upper index, and Data Storage of a file. |
| X | Maintaining Expanded Files allows you to insert or remove a component file into/from an expanded file chain. |
Selecting (option ) on the menu displays the menu:
12:37:59 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
- FDT/SDT Definition / Modification - PFLC004
Code Service Code Service
---- ---------------------------- ---- ----------------------------
A Add new field(s) I Online invert
C Change field parameters S Define/add SDT
D Define new FDT U Release UQ from descriptor
F Delete field from FDT ? Help
G Undelete field from FDT . Exit
---- ---------------------------- ---- ----------------------------
Code ......... _
File No. .....
Field Name ... __
File Password.
Database ID .. 1955 (WIS1955)
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Def. File Exit Menu |
This section covers the following topics:
Selecting (option ) on the allows you to add one or more fields to an existing Adabas file.
The function corresponds to the Adabas ADADBS NEWFIELD utility function. The equivalent direct command is:
ADD FIELD
To add a new field definition to the field definition table
(FDT) of an existing file:
In the Code field, select option (add new fields) on the menu.
Specify the number of the existing file in the File No field.
Specify a unique two-character field name that is not currently being used by the specified file in the Field Name field.
Press Enter.
Note:
You can view the FDT of the existing file by selecting
option , Database Report from the
Adabas Online System .
An Add New Field(s) screen similar to the following is displayed providing input fields for defining a new field:
12:41:36 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Add New Field(s) - PFLCA22
File = 1 (EMPLOYEES) In Parallel .. YES
Enter Password if file is security protected ...
Level I Name I Length I Format I Options I DT and SY fields
---------------------------------------------------------------------------
__ I __ I ___ I _ I __ __ __ __ __ I ________________________
__ I __ I ___ I _ I __ __ __ __ __ I ________________________
__ I __ I ___ I _ I __ __ __ __ __ I ________________________
__ I __ I ___ I _ I __ __ __ __ __ I ________________________
__ I __ I ___ I _ I __ __ __ __ __ I ________________________
__ I __ I ___ I _ I __ __ __ __ __ I ________________________
__ I __ I ___ I _ I __ __ __ __ __ I ________________________
__ I __ I ___ I _ I __ __ __ __ __ I ________________________
__ I __ I ___ I _ I __ __ __ __ __ I ________________________
__ I __ I ___ I _ I __ __ __ __ __ I ________________________
Continue: _
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
Specify the field level, name, length, format and any appropriate field options in the appropriate fields on the Add New Field(s) screen. For complete information on defining new fields, refer to the description of field definition statements in your Adabas ADACMP utility documentation.
If the file is password-protected, be sure to supply the password in the appropriate place at the top of the screen.
Caution:
The In Parallel field
allows you to specify whether processing should continue against a file while
the function you have selected modifies the file. Specify
"YES" to allow file processing to continue; specify
"NO" to give Adabas exclusive file control while
performing the function. With this option set to
"YES", Adabas performs the function while all
applications executing against the file are temporarily quiesced and suspended.
File integrity is always maintained. For this reason, your applications that
are executing against the file may experience difficulty. Please maintain an
awareness of the impact on your environment and the consequences of performing
your selected functions against a file when using this option. With this option
set to "NO" (the default), Adabas requires exclusive
file control (that is, no applications can be executing against the file) when
performing the function.
The DT and SY fields area can be used to specify a valid date-time edit mask for binary, packed, or unpacked fields. Valid edit masks are: DATE, TIME, DATETIME, TIMESTAMP, NATDATE, NATTIME, UNIXTIME, and XTIMESTAMP. For complete information about these edit masks, refer to your Adabas documentation.
Selecting (option ) on the allows you to change the parameters of an existing field in an Adabas file.
This function corresponds to the Adabas utility function ADADBS CHANGE. The equivalent direct command is:
CHANGE FIELD file-number field-name
To change the parameters of an existing field in an existing
file:
In the Code field, select option (change field parameters) on the menu.
Specify the number of the existing file in the File No field.
Specify the two-character field name of the field to be changed in the Field Name field.
Note:
You can view the FDT of the existing file by selecting
option , Database Report from the
Adabas Online System .
Press Enter.
The Change Field Parameters screen appears.
20:34:13 ***** A D A B A S BASIC SERVICES ***** 2018-07-17
DBID 1955 - Change Field Parameters - PFLCC32
Enter New Field Length or Option:
File ........... 102
File Name ...... TEST-102
Field Name ..... YF Change Field Option:
Field Format ... A NB .... NO
Field Length ... NC .... NO
Field Option ... __ NN .... NO
NU .... NO
NV .... YES
In Parallel .... NO
File Password ..
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Rel UQ Menu |
If the field is a binary, packed or unpacked date and time field, fields appear on this screen allowing you to change the edit mask and the time zone (TZ) setting:
12:59:22 ***** A D A B A S BASIC SERVICES ***** 2018-07-17
DBID 1955 - Change Field Parameters - PFLCC32
Enter New Field Length or Option:
File ........... 102
File Name ...... TEST-102
Field Name ..... AK Change Field Option:
Field Format ... P NB .... NO
Field Length ... 10 NC .... NO
Field Option ... __ NN .... NO
DT= editmask ... ___________ NU .... NO
TZ setting ..... NO_ NV .... NO
In Parallel .... NO
File Password ..
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Rel UQ Menu |
On the Change Field Parameters screen, you can change:
the standard length of an Adabas field. To do this, enter the new value in the Field Length field.
a normal alphanumeric (A) field to a long-alpha (LA) field. To do this, enter "LA" in the Field Option field (if it appears on the screen).
the default field format from unpacked (U) to packed(P). To do this, overwrite the "U" in the Field Format field with "P".
An elementary field defined as format "U" can only be changed to "P" if the field:
has not been defined with the field option "FI" (fixed storage length);
is not the parent of a sub-/super-/hyperdescriptor; and
is not within an expanded file chain.
the edit mask for a date-time field. To do this, change the value in the DT= editmask field (if it appears on the screen). Valid edit masks are: DATE, TIME, DATETIME, TIMESTAMP, NATDATE, NATTIME, UNIXTIME, and XTIMESTAMP. For complete information about these edit masks, refer to your Adabas documentation.
the setting of NB, NC, NN, NU, and NV, according to the allowed settings
NU and NC cannot be set at the same time, but a change from one to the other is possible.
If NC is set, existing records’ empty values will appear as null values, and for a new record, a value will be suppressed when the null value indicator is set to NULL, otherwise an empty value will not be suppressed and is stored.
If NU is set, empty values will be suppressed and not stored (e.g., blanks in an alpha field).
If the field you selected has been defined with the UQ (unique descriptor) option, you can press PF4 (Rel UQ) to remove it.
No modifications to records in Data Storage are made by this function. You are, therefore, responsible for preventing references to the field that would cause invalid results because of an inconsistency between the new parameter value as defined to Adabas and the actual value contained in the record.
If the file is protected, enter the password in the File Password field before you press Enter.
Caution:
The In Parallel field allows
you to specify whether processing should continue against a file while the
function you have selected modifies the file. Specify
"YES" to allow file processing to continue; specify
"NO" to give Adabas exclusive file control while
performing the function. With this option set to
"YES", Adabas performs the function while all
applications executing against the file are temporarily quiesced and suspended.
File integrity is always maintained. For this reason, your applications that
are executing against the file may experience difficulty. Please maintain an
awareness of the impact on your environment and the consequences of performing
your selected functions against a file when using this option. With this option
set to "NO" (the default), Adabas requires exclusive
file control (that is, no applications can be executing against the file) when
performing the function.
Selecting (option ) on the allows you to define a new FDT for an Adabas file.
This function corresponds to the Adabas utility function ADACMP COMPRESS. The equivalent direct command is:
DEFINE FDT
To define a new FDT:
In the Code field, select option (define new FDT) on the menu.
The Define FDT screen appears, which can be used to define a new FDT for a new file:
12:46:24 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Define FDT - PFLCD12
File Number .... 90 New FDT ... Y
Enter Field Description(s) ::
I Levl I Name I Length I Format I Options I Date/time and System fields
I--------------------------------------------------------------------------
I __ I __ I ___ I _ I __ __ __ __ __ I ________________________
I __ I __ I ___ I _ I __ __ __ __ __ I ________________________
I __ I __ I ___ I _ I __ __ __ __ __ I ________________________
I __ I __ I ___ I _ I __ __ __ __ __ I ________________________
I __ I __ I ___ I _ I __ __ __ __ __ I ________________________
I __ I __ I ___ I _ I __ __ __ __ __ I ________________________
I __ I __ I ___ I _ I __ __ __ __ __ I ________________________
I __ I __ I ___ I _ I __ __ __ __ __ I ________________________
I __ I __ I ___ I _ I __ __ __ __ __ I ________________________
I __ I __ I ___ I _ I __ __ __ __ __ I ________________________
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Def SDT Exit Def File Disp FDT Menu |
FDTs for existing files cannot be redefined with this option.
Selecting (option ) on the allows you to logically delete a field from the FDT for a file.
This function corresponds to the Adabas ADADBS DELFN utility function.
The Delete Field screen appears.
12:48:40 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Delete Field - PFLCF02
Field Name ....... AA
File Number ...... 1
File Name ........ EMPLOYEES
Enter 'DELETE' to confirm ... ______
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Confirm Menu |
To delete the field:
Press PF6 to delete the field.
Or:
Type "DELETE" in the space
provided and press Enter.
The field is deleted from the FDT.
Note:
Fields marked for deletion are identified in the
Field Definition Table (FDT) section
of the Database Report.
Selecting (option ) on the allows you to logically undelete a field you had previously deleted from the FDT for a file.
This function corresponds to the Adabas ADADBS UNDELFN utility function.
The Undelete Field screen appears.
12:48:40 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Undelete Field - PFLCG02
Field Name ....... AA
File Number ...... 1
File Name ........ EMPLOYEES
Enter 'UNDELETE' to confirm .. ________
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Confirm Menu |
To undelete the field:
Press PF6 to undelete the field.
Or:
Type "UNDELETE" in the space
provided and press Enter.
The field is undeleted from the FDT.
Selecting (option ) on the displays the Online Invert screen.
The equivalent direct command is:
ONLINE INVERT
13:02:04 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Online Invert - PFLCI02
File Number .... 1 EMPLOYEES
Password .......
Enter the definition, using the syntax of the ADADBS ONLINVERT utility:
______________________________________________________________________
______________________________________________________________________
Note: Only one Invert Process can be active for a file at any time.
Examples:
FIELD='AA' HYPDE='01,HD,20,A,NU,MU=AA,AB'
SUBDE='SB=AA(1,5)' PHONDE='PH(AA)'
SUPDE='SP=AA(1,5),BB(1,2),CC(3,5)' COLDE='1,CD=AA'
Enter Descriptor information and press 'enter'
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
The specified file must be currently loaded.
Specify the definition in the space provided, using the ADADBS ONLINVERT syntax. PF1 provides help information for this syntax; see the Adabas Utilities documentation for additional information.
Only one descriptor can be specified per process.
Only one invert process can be active for a file at any time. If an attempt is made to start a second invert process before the first one has completed, a response code 64 is returned.
Selecting (option ) on the menu allows you to define special descriptors in an existing FDT for a new file. This option is available only if an FDT exists but no file control block (FCB) exists for the file (for example, if the FDT has been created but no records loaded, or if the file was deleted with the option to retain the FDT).
This function corresponds to the Adabas utility function ADACMP COMPRESS. The equivalent direct command is
DEFINE STD
The Define SDT screen appears.
13:02:42 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Define SDT - PFLCH12
File Number .... 1
Password .......
Enter SDT-Definition, using the syntax of the ADACMP Utility:
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
Enter SDT information and press 'enter'
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Def File Exit Refresh Menu |
Use ADACMP syntax (see the Adabas Utilities documentation) on this screen.
Selecting (option ) on the menu after specifying the file number and descriptor field on the menu allows you to release the UQ (unique descriptor) option from the descriptor field.
The Release UQ screen appears.
13:08:00 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Release UQ - PFLCU02
Confirm Release of UQ:
File ........... 41
File Name ...... BIGFDT2
Field Name ..... AA
File Password ..
Enter 'RELEASE' to confirm ... _______
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Confirm Menu |
Selection option , , on the menu allows you to remove a descriptor by freeing the specified field's inverted list in the Associator. Field names listed in the field definition table (FDT) with an option of "DE" are descriptors.
Note:
You can view the FDT of the existing file by selecting option
, Database Report, from the
AOS main menu.
This function corresponds to the Adabas utility function ADADBS RELEASE. The equivalent direct command is
RELEASE DESCRIPTOR file-number descriptor
To release a descriptor:
Select option (Release Descriptor) on the menu.
Specify the number of the existing file.
Specify the name of the existing descriptor to be released.
Press ENTER.
Confirm the release on the Release Descriptor screen:
13:48:20 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Release Descriptor - PFLD022
Descriptor Name .. AA
File Number ...... 1
File Name ........ EMPLOYEES
Password .........
In Parallel ...... NO_
Enter 'RELEASE' to confirm .. _______
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Confirm Menu |
Press PF6 to release the descriptor.
Or:
Type "RELEASE" in the space
provided and press Enter.
The descriptor is released.
Selecting option (Delete existing file) on the menu allows you to free extents used by an existing file for use by other existing files or newly added files.
You have the option to save the field definition table (FDT) so that the field description of the deleted file remains in the database and can be used for a subsequent new file definition.
If the file to be deleted is a coupled file, it must first be
uncoupled using option on the menu or the UNCOUPLE direct
command.
This function corresponds to the utility function ADADBS DELETE.
The equivalent direct command is
DELETE FILE file-number
To delete an Adabas file:
Select option (Delete existing file) on the menu.
Specify the number of the existing file.
Press ENTER.
The Delete File screen appears.
13:48:50 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Delete File - PDMD002
File Number ......................... 1
File Name ........................... EMPLOYEES
Enter File Name to confirm delete ...
Save Field Description Table ........ N
File Password .......................
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
Tab to the Enter File Name to confirm delete field and type in the name of the file.
Tab to the Save Field Description Table field and type "Y" to save the FDT for the file or "N" to delete the FDT.
Tab to the File Password field and specify the file password, if any.
Press Enter to delete the file.
The file is deleted.
Before option (Define new file) on the menu can be used to add a new file to the specified database, an FDT must be defined for the file. Alternatively, you may choose to use an already existing FDT (retained from a Delete File function run with the "SAVE FDT" option).
This function corresponds to the utility function ADALOD LOAD.
The equivalent direct command is
DEFINE FILE file-number
To define a new FDT for a file, read Defining a New Field Definition Table (FDT) .
To add a new file for which an FDT has been defined:
Select option (Define new file) on the menu.
Specify the number of the file to be added.
Specify the database to which it will be added.
Press Enter.
If the file already exists in that database, a message is displayed at the top of the menu. Otherwise, the Define File screen appears.
13:49:15 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Define File - PFLF012
File Name ......... TEST-90_________
MAXISN ............ __________ ACRABN .....
Datastorage Size .. __________ B (BLKs/CYLs) DSRABN .....
Normalindex Size .. __________ B (BLKs/CYLs) NIRABN .....
Upperindex Size ... __________ B (BLKs/CYLs) UIRABN .....
MINISN .......* 1 ISN Size .......... 3 Byte Anchor Fnr .....
ISN Reuse ....* N MIXDSDEV .......... N Ciphering ...... N
DS Reuse .....* Y Spanned Records ... N Alpha Code .....
DATA device ..* 3390 MU / PE > 191 ..... N Wide Code ......
ASSO padding .* 10 % LOB file .......... N User Wide Code .
DATA padding .* 10 % Rel. LOB file # ... Reptor upd only. N
SYFMAXUV ....... 0
Max Blks: Max comp. rec.len . 5060
DS extents .. Index Compression . N Multi Client
NI extents .. No AC Extension ... N Support ........ N
UI extents .. Program Refresh ... N Owner-ID Len ... 8
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit ADAM Menu |
Supply values for the MAXISN, Datastorage Size, Normalindex Size, and Upperindex Size, at a minimum. Alter any other fields as appropriate for the file.
When all field values have been specified, press Enter to define the file.
To specify parameters for an ADAM file:
Press PF7 (ADAM).
The following ADAM File Information window appears:
ADAM File Information:
ADAMDE (field/ISN).
ADAMPARM ..........
ADAM Overflow .....
ADAM Dataform ..... Y
|
Supply values for all fields and press Enter.
You can use AOS to logically delete and undelete a descriptor. Logically deleting a field from a file removes the field from the FDT, but retains the field data in the database. Logically undeleting a field that was previously logically deleted reinstates the field in the FDT.
Selecting Logically delete/undel descriptr (option ) on the allows you to logically delete a descriptor from a file.
This function corresponds to the Adabas ADADBS DELDE, DELFN, UNDELDE, and UNDELFN utility functions.
The Logically Delete Undelete Descriptor screen appears.
13:50:16 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Logically Delete Undelete Descriptor - PFLL002
Descriptor Name ................. AA
File Number ..................... 29
File Name ....................... TEST-29
Password ........................
Delete (yes) or Undelete (no) ... NO
Enter 'LDELETE' to confirm .. _______
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Confirm Menu |
To delete the descriptor:
Be sure that a valid descriptor is correctly identified on the menu.
Tab to the Delete (yes) or Undelete (no) field and type "YES".
Press PF6 to confirm the descriptor deletion.
Or:
Type "LDELETE." in the space
provided and press Enter.
The descriptor is logically deleted.
To undelete a descriptor:
Be sure that a valid descriptor is correctly identified on the menu.
Tab to the Delete (yes) or Undelete (no) field and type "NO".
Press PF6 to confirm the descriptor undeleting.
Or:
Type "LDELETE." in the space
provided and press Enter.
The descriptor is logically undeleted.
Note:
AOS is 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.
You can use AOS to modify file parameters unless they are incorporated in Predict.
This function corresponds to the utility function ADADBS MODFCB. The equivalent direct command is
MODIFY FILE file-number
To modify parameters for a file
Select option (Modify file parameters) on the menu.
Specify the number of the file to be modified.
If the file is protected, supply the password.
Press Enter.
The Modify File Parameters screen appears:
15:46:43 ***** A D A B A S BASIC SERVICES ***** 2016-07-15
DBID 1974 - Modify File Parameters - PFLM032
File No. ... 21
File Name .. FILE-1974-21 in Parallel ....... YES
------------------------------------------------------------------------------
ASSO PFAC ......... 10 Max. UI Blks per extent .. 0
DATA PFAC ......... 10 Max. NI Blks per extent .. 0
Max. RECL ......... 5060 Max. DS Blks per extent .. 0
ISN Reuse ................ OFF
New File Name ..... FILE-1974-21____ with RESET ........ ___
New File No. ...... 21 SETISN ....... 0
User ISN .......... OFF DS Reuse ................. ON_
File Password ..... with RESET ........ ___
Filereadonly ...... OFF Mixed DS Device .......... OFF
Spanned Records ... OFF Program Refresh .......... OFF
MU/PE indices ..... 1 Max occur system fields .. 0
Reptor update only. OFF Replication .............. OFF__
AlphaNum Encoding . 0
WideChar Encoding . 0
PF1----- PF2------ PF3------ PF4------ PF6------ PF7----- PF8----- PF12-----
Help Exit Menu |
If large object (LOB) flags are set (if the file is a LOB file) and you press PF4 on the screen when it displays a LOB file, a pop-up window appears showing detailed information about the file:
- LOB File Information - ***************** * File 16 * ***************** File Info: LOB file Related LOB File Number ....... 15___ PF3--- Cancel |
Update file parameters as described in the rest of this section
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.
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.
Using the Max. RECL field on the Modify File Parameters screen, you can change the maximum compressed record length allowed.
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
Use the File Password field to specify a password for the file.
ISN Reuse and DS 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.
If you want this file to be accessed only in read-only mode, set the Filereadonly field to ON. This is useful if you need to maintain them while the rest of the database is up.
To activate spanned record support for a file, set the Spanned Records field to ON. Once spanned record support is turned on, you can create spanned records in that file; if spanned record support is not turned on, you cannot create spanned records in a file.
You can also turn off or on several file options on this screen:
User ISN ISN Reuse ...with RESET DS Reuse ...with RESET Mixed DS Device MU PE Indices Program Refresh
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.
You can change the settings of several replication parameters:
| Parameter | Description |
|---|---|
| Reptor update only | Indicates whether the file may be updated only by the Event Replicator Server as part of Adabas-to-Adabas replication or by other means as well. |
| Replication | Indicates whether replication has been turned on for the Adabas file. |
Notes:
Selecting Reorder File Online (option ) on the menu displays the Online Reorder File screen, which can be used to start an online reorder process for the specified file.
The equivalent direct command is
ONLINE REORDER
13:55:43 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Online Reorder File - PFLO002
Reorder for file... 29 TEST-29
Password....
-----------------------------------------------------------------------------
Type of Reorder...... _
Options: Asso Padding Factor.. __
Data Padding Factor.. __
Sort Sequence........ ___
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
To select the type of reorder to be performed:
Enter one of the following reorder type codes in the Type of Reorder field:
| Reorder type | Corresponds to ADADBS function... | Reorders ... |
|---|---|---|
| B (both) | ONLREORFILE | the entire file |
| A (Associator) | ONLREORFASSO | the Associator for the file only |
| D (Data Storage) | ONLREORFDATA | Data Storage for the file only |
The only file level parameters that can be changed using this function are the padding factors. If these fields are left blank, the current parameter settings are used during the reorder.
When reordering Data Storage for a file, you can specify a sort sequence. The default is physical sequence or "PHY". Other possible options include "ISN" if the file is to be sorted in ISN order, or the two character descriptor name to sort the file according to the value of the specified descriptor.
Press Enter.
Option , (Refresh file to empty status) on the menu deletes all file records and assigns a single extent to each file component.
This function corresponds to the utility function ADADBS REFRESH. The equivalent direct command is
REFRESH FILE file-number
To refresh a file to empty status:
Select option (Refresh file to empty status) on the menu.
Specify the number of the existing file in the specified database.
Press Enter.
The Refresh File screen appears.
13:56:13 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Refresh File - PFLR002
File Number ... 29
File Name ..... TEST-29
Password ......
Enter File Name to confirm ...
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
Tab to the Password field and enter a password for the file, if necessary.
Tab to the Enter File Name to confirm field and enter the name of the file.
Press Enter to confirm the refresh on the Refresh File screen.
Option , (Allocate/deallocate file space) on the menu allows you to allocate or deallocate extents for the address converter, normal index, upper index, and Data Storage of a file. You can specify the allocation in blocks or in cylinders, a starting relative Adabas block number, and the device where the allocated space should be located.
This function corresponds to the utility functions ADADBS ALLOCATE and ADADBS DEALLOCATE.
Note:
If an attempt is made to allocate AC beyond MAXISN, Adabas will
detect this and only allocate up to MAXISN.
The equivalent direct commands are
ALLOCATE SPACE file-number
DEALLOCATE SPACE file-number
To allocate or deallocate space for a file:
Select option (allocate/deallocate file space).
Specify the file to be modified.
Press Enter.
The Allocate/Deallocate File Space screen appears.
13:56:35 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Allocate/Deallocate File Space - PFLS002
File Number .............. 29
File Name ................ TEST-29
Enter Parameters : Possible values:
Allocate/Deallocate ... _ (A/D)
Table Type ............ __ (AC/A2/DS/NI/UI)
Size ..................
Blocks or Cylinders ... B (B/C)
Start RABN ............ __________
Device Type ........... ____
File Password ............
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
Indicate whether you are allocating or deallocating space in the Allocate/Deallocate field. Specify "A" to allocate space and "D" to deallocate space.
Tab to the Table Type field and specify the type of space you are allocating or deallocating (address converter, Data Storage, normal index, or upper index)>
Specify the amount of space that should be allocated or deallocated using the Size field.
Specify whether the space should be allocated or deallocated in blocks (B) or cylinders (C) using the Blocks or Cylinders field.
Optionally specify a starting RABN in the Start RABN field.
If the file is protected, supply the password in the File Password field.
Press Enter to perform the allocation or deallocation.
Selecting option and a file number (File No field) on the menu displays the menu:
13:57:18 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
- Expanded File Maintenance - PFLX002
Code Service
---- ----------------------
I Insert file into chain
R Remove file from chain
? Help
. Exit
---- ----------------------
Code .........
File No. ..... 29
Master Fnr ...
Password .....
Database ID .. 1955 (WIS1955)
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
The functions available on this menu correspond to the utility functions ADALOD LOAD and ADALOD UPDATE.
To insert an existing file into an expanded file chain:
Select option on the menu.
Specify the number of the file to be inserted (File No field).
Specify the number of the master file of the expanded file chain into which the file is being inserted (Master Fnr field).
If the file is protected, supply the password in the File Password field.
Press Enter.
Note:
If the file to be inserted is to be the first (master) file of
the chain, both File No and Master
Fnr fields must be set to the same value.
To remove a component file from an expanded file chain:
Select option "R" on the menu.
Specify just the number of the file to be removed (File No field) from the chain.
If the file to be removed is the master file, the next file in the chain will become the new master file.
If the file is protected, supply the password in the File Password field.
Press Enter.