Example 1

    The following command repairs SPAM page corruption for all the
    storage areas in the mf_personnel database. No area bit map
    (ABM) pages are reconstructed because the Abm qualifier is not
    specified.

    $ RMU/REPAIR MF_PERSONNEL

    Example 2

    When columns are deleted from or added to a table, the record
    length stored in the logical area inventory entry is not updated.
    Therefore the search for space needed to store a new record may
    be inefficient, and the SPAM thresholds will not be set properly.
    You can solve this problem by first correcting the length in
    the logical area inventory entry, then generating corrected SPAM
    pages using the RMU Repair command.

    For example, suppose the Departments table was stored in the
    departments.rda uniform page format storage area and the Budget_
    Projected column (integer data type = 4 bytes) was deleted. As
    a result of this deletion, the row length changed from 47 bytes
    to 43 bytes. You can specify a smaller record length (43 bytes)
    in the fix_departments.opt options file to more efficiently use
    space in the storage area.

    $ CREATE FIX_DEPARTMENTS.OPT
    DEPARTMENTS /LENGTH=43

    Then, the following RMU Repair command specifies the record
    length to store in the logical area inventory entry for this
    logical area and rebuilds the SPAM pages:

    $ RMU/REPAIR/SPAMS/INITIALIZE=LAREA_PARAMETERS=FIX_DEPARTMENTS.OPT -
    _$ MF_PERSONNEL

    Example 3

    The following RMU Repair command initializes and renames
    departments.snp; initializes and moves salary_history.snp; and
    initializes, moves, and truncates jobs.snp:

    $ RMU/REPAIR/NOSPAMS/INITIALIZE=SNAPSHOTS=CONFIRM -
    _$ /AREAS=(DEPARTMENTS,JOBS,SALARY_HISTORY) MF_PERSONNEL
    %RMU-I-FULBACREQ, A full backup of this database should be
     performed after RMU Repair
    Area DEPARTMENTS snapshot filename
     [SQL1:[TEST]DEPARTMENTS.SNP;1]: NEW_DEPT
    Area DEPARTMENTS snapshot file allocation [10]?
    Area SALARY_HISTORY snapshot filename
     [SQL1:[TEST]SALARY_HISTORY.SNP;1]: SQL2:[TEST]
    Area SALARY_HISTORY snapshot file allocation [10]?
    Area JOBS snapshot filename [SQL1:[TEST]JOBS.SNP;1]: SQL2:[TEST2]
    Area JOBS snapshot file allocation [10]? 5

    Example 4

    The following RMU Repair command finds incorrect checksums in the
    EMPIDS_LOW storage area and updates them to reflect the correct
    checksum:

    $ RMU/REPAIR MF_PERSONNEL.RDB/AREA=EMPIDS_LOW/CHECKSUM

    Example 5

    The following command updates an AIP type for a table:

    $ RMU/REPAIR MF_PERSONNEL /INITIALIZE=LAREA_PARAMETERS=TABLE.OPT

    Type the TABLE.OPT file to show the contents of the file.

    $ TYPE TABLE.OPT
    EMPLOYEES /TYPE=TABLE

    Example 6

    The following command updates an AIP type for a storage area:

    $ RMU/REPAIR MF_PERSONNEL /INITIALIZE=LAREA_PARAMETERS=AREAS.OPT

    Type the AREAS.OPT file to show the contents of the file.

    $ TYPE AREAS.OPT
    EMPLOYEES /AREA=EMPIDS_OVER /TYPE=TABLE