RMUALTER72.HLB  —  DEPOSIT_AREA_HEADER, Examples
    Example 1

    The following example shows that for Oracle Rdb single file
    databases, the Unique Identifier value can only be set for the
    storage area snapshot file since the storage area is part of the
    root file. Therefore, the DEPOSIT AREA_HEADER command can only
    specify the "SNAPSHOT" file or an error will be returned.

    $ RMU/ALTER PERSONNEL
    %RMU-I-ATTACH, now altering database
    "DEVICE:[DIRECTORY]PERSONNEL.RDB;1"
      DEPOSIT AREA_HEADER RDB$SYSTEM UNIQUE_IDENTIFIER
    %RMU-F-NOTSFDB, This command is not allowed for a single file
     database
      DEPOSIT AREA_HEADER RDB$SYSTEM SNAPSHOT UNIQUE_IDENTIFIER
    Area RDB$SYSTEM:
    (marked) Root file unique identifier is: "22-OCT-2010 13:49:29.32"
     (00AA557869612643)

     COMMIT
     EXIT

    Example 2

    Since the DEPOSIT ROOT UNIQUE_IDENTIFIER command always stores
    the Unique Identifier value in ALL storage area file headers when
    the user executes the RMU/ALTER "COMMIT" command, it would be
    redundant to execute the DEPOSIT AREA_HEADER UNIQUE_IDENTIFIER
    command if a DEPOSIT ROOT UNIQUE_IDENTIFIER command is already
    pending for the current RMU/ALTER session. Therefore, as the
    following example shows, in this case a DEPOSIT AREA_HEADER
    UNIQUE_IDENTIFIER command cannot be executed until the user ends
    the current session with a COMMIT or ROLLBACK command.

    $ RMU/ALTER MF_PERSONNEL
    %RMU-I-ATTACH, now altering database
     "DEVICE:[DIRECTORY]MF_PERSONNEL.RDB;1"
      DEPOSIT ROOT UNIQUE_IDENTIFIER = NEW
    (marked) Root file unique identifier is: "22-OCT-2010 13:49:31.72"
     (00AA55786ACFB115)

      DEPOSIT AREA_HEADER SALARY_HISTORY UNIQUE_IDENTIFIER
    %RMU-F-COMROOTCOM, COMMIT or ROLLBACK DEPOSIT ROOT
     UNIQUE_IDENTIFIER command to use this command
      commit
      DEPOSIT AREA_HEADER SALARY_HISTORY UNIQUE_IDENTIFIER
    Area SALARY_HISTORY:
    (marked) Root file unique identifier is: "22-OCT-2010 13:49:31.72"
     (00AA55786ACFB115)

      COMMIT
      EXIT

    Example 3

    The following example shows that RMU/ALTER is invoked specifying
    the database MF_PERSONNEL.RDB. The user then displays the current
    Unique Identifier value in the root file. He then executes the
    "deposit" commands to designate that the Unique Identifer value
    in the root file is to be moved to the DEPARTMENTS area storage
    and the DEPARTMENTS area snapshot files, displays the Unique
    Identifier value that is to be moved to the DEPARTMENTS area
    storage and the DEPARTMENTS area snapshot files, and finally
    specifies "commit" to actually write the root unique identifier
    value to the DEPARTMENTS area storage and the DEPARTMENTS area
    snapshot files. The display messages designate the pending
    Unique Identifier value as "(marked)" until the user either
    executes "commit" to write out the Unique Identifier value or
    "rollback" to restore the original Unique Identifier value. The
    user then verifies the database changes. The example shows that
    the user can use either the storage area name or the storage area
    identifier number in the root to designate the target storage
    area.

    $ RMU/ALTER MF_PESONNEL
    %RMU-I-ATTACH, now altering database "DEVICE:[DIRECTORY]MF_PERSONNEL.RDB;1"
      DISPLAY ROOT UNIQUE_IDENTIFIER
               Root file unique identifier is: "22-OCT-2010 13:49:28.34"
     (00AA557868CC9F7A)

      DEPOSIT AREA_HEADER DEPARTMENTS UNIQUE_IDENTIFIER
    Area DEPARTMENTS:
    (marked) Root file unique identifier is: "22-OCT-2010 13:49:28.34"
     (00AA557868CC9F7A)

      DEPOSIT AREA_HEADER 2 SNAPSHOT UNIQUE_IDENTIFIER
    Area DEPARTMENTS:
    (marked) Root file unique identifier is: "22-OCT-2010 13:49:28.34"
     (00AA557868CC9F7A)

      DISPLAY AREA_HEADER DEPARTMENTS UNIQUE_IDENTIFIER
    Area DEPARTMENTS:
    (marked) Root file unique identifier is: "22-OCT-2010 13:49:28.34"
     (00AA557868CC9F7A)

      DISPLAY AREA_HEADER 2 SNAPSHOT UNIQUE_IDENTIFIER
    Area DEPARTMENTS:
    (marked) Root file unique identifier is: "22-OCT-2010 13:49:28.34"
     (00AA557868CC9F7A)

      COMMIT
      EXIT
    $ RMU/VERIFY/ALL/NOLOG MF_PERSONNEL
Close Help