Example 1

    RMU will call Rdb for each logical area that requires rebuilding.

    $ RMU/SET AIP/REBUILD_SPAMS MF_PERSONNEL
    %RMU-I-AIPSELMOD, Logical area id 86, name ACCOUNT_AUDIT selected for
    modification
    %RMU-I-AIPSELMOD, Logical area id 94, name DEPARTMENTS_INDEX selected for
    modification

    Example 2

    RMU will request that the EMPLOYEES table length be updated
    in the AIP. Oracle Rdb will use the latest table layout to
    calculate the length in the AIP and write this back to the AIP.
    The EMPLOYEES table is partitioned across three storage areas and
    therefore the Log qualifier shows these three logical areas being
    updated.

    $ RMU/SET AIP MF_PERSONNEL EMPLOYEES/LENGTH/LOG
    %RMU-I-AIPSELMOD, Logical area id 80, name EMPLOYEES selected for modification
    %RMU-I-AIPSELMOD, Logical area id 81, name EMPLOYEES selected for modification
    %RMU-I-AIPSELMOD, Logical area id 82, name EMPLOYEES selected for modification

    Example 3

    RMU will request that the EMPLOYEES table length be updated
    in the AIP and then the SPAM pages will be rebuilt. This is an
    ONLINE operation. Note: there is an implied relationship between
    the logical area name and the name of the object. This example
    assumes that the EMPLOYEES object is mapped to a UNIFORM page
    format area.

    $ RMU/SET AIP MF_PERSONNEL EMPLOYEES/LENGTH/REBUILD_SPAMS

    Example 4

    When Thresholds for an index are modified they will not be
    effective until the SPAM pages are updated (rebuilt) to use these
    new values. The following example shows that index maintenance
    performed by SQL. The SET FLAGS command is used to display
    information about the change. Note that the change is applied at
    COMMIT time and that the SPAM rebuild is deferred until a later
    time. RMU Set AIP is then used to rebuild the SPAM pages.

    $ SQL$
    SQL> set flags 'index_stats';
    SQL> alter index candidates_sorted store in rdb$system (thresholds are (32,56,
    77));
    ~Ai alter index "CANDIDATES_SORTED" (hashed=0, ordered=0)
    ~Ai larea length is 215
    ~As locking table "CANDIDATES" (PR -> PU)
    ~Ai: reads: async 0 synch 58, writes: async 8 synch 0
    SQL> commit;
    %RDMS-I-LOGMODVAL,     modified space management thresholds to (32%, 56%, 77%)
    %RDMS-W-REBUILDSPAMS, SPAM pages should be rebuilt for logical area
    CANDIDATES_SORTED
    $
    $ RMU/SET AIP MF_PERSONNEL CANDIDATES_SORTED/REBUILD_SPAMS/LOG
    %RMU-I-AIPSELMOD, Logical area id 74, name CANDIDATES_SORTED selected for
    modification