The SET-FPA-SCAN-PARAMETERS statement defines which search mode is used for the free place search in a realm (First Scan or Second Scan).
SET-FPA-SCAN-PARAMETERS |
SUBSCHEMA-NAME = <structured-name 1..30> ,REALM-NAME = <structured-name 1..30> ,SEARCH-MODE = *REUSE / *NOREUSE |
SUBSCHEMA-NAME = <structured-name 1..30>
Name of the subschema in which the search mode is to be defined. Only names of user subschemas are pemitted.
REALM-NAME = <structured-name 1..30>
Name of the realm in which the search mode is to be defined. The realm name must be a valid name in the defined subschema. Only names of user realms are permitted. The corresponding check is performed when the procedure statement FPASCAN is executed (see section “Defining the start page for the free place search (FPASCAN)”).
SEARCH-MODE =
Determines the search mode, i.e. the page in a realm from which space is searched for to store the new records and tables which are created by application programs through the DMLs MODIFY and STORE.
SEARCH-MODE = *REUSE
Space for new records and tables which are to be stored is searched for from the beginning of the realm (Second Scan). A change of the search for space becomes effective immediately with *REUSE.
SEARCH-MODE = *NOREUSE
The search for space for the new records and tables which are to be stored takes place at the end of the realm after the first page of the contiguous area of free pages (First Scan).A change of the search for space is initially registered in *NOREUSE and becomes effective when the next checkpoint is reached.