Version 8.2.5
 —  Utilities  —

ONLREORFASSO: Start Online Reorder Associator for Files

The ONLREORFASSO function starts an online process to reorder the Associator of specified files.

Notes:

  1. The online reorder process does not change the existing file extents but only reorganizes the file's index within these extents.
  2. The online index reorder process does not move index elements out of blocks that are full (according to the Asso padding factor); it only moves elements into blocks that are not full.
  3. Released index blocks are not put into the unused RABN chain.
  4. This function is not available in the Adabas Cluster Services or Adabas Parallel Services environments.

graphics/util_adadbs_onlreorfasso.png

This document covers the following topics:


Essential Parameters

FILE: File Number

FILE specifies the file to which the parameters that follow in the statement sequence apply.

Several files and their related parameters may be specified within one ONLREORFASSO operation. In this case, the files are reordered in the specified sequence.

If a component file of an Adabas expanded file is specified, only that file's Associator is reordered; this has no adverse effect on the other component files.

The Adabas checkpoint or security file number must not be specified.

Top of page

Optional Parameters

ASSOPFAC: Associator Padding Factor

ASSOPFAC defines the Associator block padding factor, which is the percentage of each Associator block not used during the reorder process. Specify a value in the range 1-90. The number of bytes free after padding must be greater than the largest descriptor value plus 10.

If this parameter is omitted, the current padding factor in effect for the file is used.

PASSWORD: File Password

If the file is password-protected, use this parameter to specify the password.

NOUSERABEND: Termination without Abend

When a parameter error or a functional error occurs while this utility function is running, the utility ordinarily prints an error message and terminates with user abend 34 (with a dump) or user abend 35 (without a dump). If NOUSERABEND is specified, the utility will not abend after printing the error message. Instead, the message "utility TERMINATED DUE TO ERROR CONDITION" is displayed and the utility terminates with condition code 20.

Note:
When NOUSERABEND is specified, we recommend that it be specified as the first parameter of the utility function (before all other parameters). This is necessary to ensure that its parameter error processing occurs properly.

TEST: Test Syntax

The TEST parameter tests the operation syntax without actually performing the operation. Only the syntax of the specified parameters can be tested; not the validity of values and variables.

WAIT: Wait for End of Process

Specify WAIT if ADADBS is to wait for the end of the online process before proceeding either with the next function or with termination.

If WAIT is not specified, ADADBS proceeds immediately after initiating the online process.

Top of page

Example

Initiate an online process that reorders the Associator of file 10 first and then file 11. The Associator padding factor of file 11 is to be 5 percent.

ADADBS ONLREORFASSO FILE=10
ADADBS              FILE=11,ASSOPFAC=5

Top of page