Note:
This function is only available for Adabas version 7 or above
databases and is not available in the Cluster or Parallel Services
environments. It cannot be started for the checkpoint or security files.
Selecting Reorder File Online (option "O") from the File Maintenance menu displays the following screen, which can be used to start an online reorder process for the specified file:
10:25:37 ***** A D A B A S BASIC SERVICES ***** 2006-07-20
DBID 105 - Online Reorder File - PFLO002
Reorder for file... 5 EMPLOYEES
Password....
------------------------------------------------------------------------------
Type of Reorder...... _
Options: Asso Padding Factor.. __
Data Padding Factor.. __
Sort Sequence........ ___ |
To select the type of reorder to be performed
Enter one of the following reorder type codes:
| Reorder type | Corresponds to ADADBS ... | 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.
ONLINE REORDER
The equivalent direct command is
